Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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

Dummies.com Sweepstakes

Win $500. Easy.