How to Describe a Custom Excel 2013 Function
How to Create a Constant Formula in Excel 2013
Excel Functions You're Likely to Use

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.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

COMMENTS »
blog comments powered by Disqus
Time Functions in Excel 2013
Analysis ToolPak Add-In Financial Functions
Error-Checking Options in Excel 2013
The PMT Function in Excel 2013
How to Use the Database Functions in Excel 2013