Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Create a Constant Formula in Excel 2013
How to Describe a Custom Excel 2013 Function
Analysis ToolPak Add-In Financial Functions

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 Use the Database Functions in Excel 2013
Excel Dashboards and Reports: The VLOOKUP Function
Excel 2013's Formula-Auditing Tools
Excel Text Functions You'll Find Helpful
How to Calculate the Future Value in Excel 2013
Advertisement

Inside Dummies.com