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
Advertisement

Inside Dummies.com