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

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
Time Functions in Excel 2013
Excel Text Functions You'll Find Helpful
How to Calculate the Future Value in Excel 2013
Excel Functions You're Likely to Use
How to Use the Database Functions in Excel 2013
Advertisement

Inside Dummies.com