How to Create a Constant Formula in Excel 2013
How to Describe a Custom Excel 2013 Function
The PMT Function in Excel 2013

How to Enter a Formula Using Cell Names in Excel 2013

Step 1 of 3
Next Slideshow
Next Slideshow

Assign range names to the individual cells.

Click the Name Manager button in the Defined Names group on the Formulas tab of the ribbon. Give the name Hours to cell I3 and the name Rate to cell J3.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
White-Out Errors with Conditional Formatting in Excel 2013
Special Date Functions in Excel 2013
Excel Functions You're Likely to Use
Analysis ToolPak Add-In Financial Functions
Excel 2013's Formula-Auditing Tools