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

Home > Articles

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

calculate a percent diff

Column E calculates the percent difference between the budgeted and actual amounts. The percentage is based on the budgeted amount. We'll write the first formula now and copy it to other cells in column E later.

one.jpg Activate cell E3.

two.jpg Type =.

three.jpg Click in cell D3.

Its cell reference appears in cell E3.

four.jpg Type /.

five.jpg Click in cell B3.

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

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

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

  • + Share This
  • 🔖 Save To Your Account