Rock your resolutions. Take the Dummies challenge and you could WIN $1,000! Get Started.
How to Create a Constant Formula in Excel 2013
How to Describe a Custom Excel 2013 Function
Special Date Functions in Excel 2013

How to Enter a Formula Using Cell Names in Excel 2013

Create the formula.

Put the cell cursor in cell K3. Type = (equal sign) to start the formula. Select the first cell referenced in the formula by selecting its cell (either by clicking the cell or moving the cell cursor into it). For this example, select the Hours cell by selecting cell I3.

Type the arithmetic operator to use in the formula. For this example, you would type * (asterisk) for multiplication.

Select the second cell referenced in the formula by selecting its cell (either by clicking the cell or moving the cell cursor into it). For this example, you select the Rate cell by selecting cell J3.

blog comments powered by Disqus
Analysis ToolPak Add-In Financial Functions
Excel Functions You're Likely to Use
Excel Dashboards and Reports: The VLOOKUP Function
How to Calculate the Future Value in Excel 2013
Error-Checking Options in Excel 2013
Advertisement

Inside Dummies.com