Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Describe a Custom Excel 2013 Function
How to Create a Constant Formula in Excel 2013
Time Functions 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

blog comments powered by Disqus
How to Calculate the Net Present Value in Excel 2013
White-Out Errors with Conditional Formatting in Excel 2013
Analysis ToolPak Add-In Financial Functions
Excel Functions You're Likely to Use
Excel 2013's Formula-Auditing Tools
Advertisement

Inside Dummies.com