Publishers of technology books, eBooks, and videos for creative people

Home > Articles

  • Print
  • + Share This
This chapter is from the book

calculate a difference

Column D, which will display the difference between budgeted and actual amounts, will contain simple formulas that subtract one cell's contents from another's using cell references. In this step, we'll write the first formula. Later, we'll copy the formula to other cells in the column.

one.jpg Activate cell D3.

two.jpg Type =.

three.jpg Click in cell C3.

Its cell reference appears in cell D3.

four.jpg Type .

five.jpg Click in cell B3.

Its cell reference is appended to the formula in cell D3.

six.jpg Press Enter (Windows) or Return (Mac OS).

The result of the formula you entered appears in cell D3.

  • + Share This
  • 🔖 Save To Your Account