• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Build the Budget Worksheet > Calculate a Difference p. 33

Calculate a Difference p. 33

  • In Excel, all formulas begin with an equals sign (=).

  • Although you can write a formula that subtracts one number from another, using cell references in the formula ensures that the formula's results remain correct, even if referenced cells' values change.

  • As our formula is written, if the actual amount is lower than the budgeted amount, the difference appears as a negative number. You can make this appear as a positive number by switching the order of the cell references so the formula is =B3-C3.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint