How to Create a Constant Formula in Excel 2013
How to Describe a Custom Excel 2013 Function
How to Calculate the Future Value in Excel 2013

How to Enter a Formula Using Cell Names in Excel 2013

Step 1 of 3
Previous
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

Recommends

Promoted Stories From Around The Web

COMMENTS »
blog comments powered by Disqus
The PMT Function in Excel 2013
Excel 2013's Formula-Auditing Tools
Excel Dashboards and Reports: The VLOOKUP Function
Error-Checking Options in Excel 2013
White-Out Errors with Conditional Formatting in Excel 2013