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

Chapter 3. Build the Budget Worksheet > Calculate a Percent Diff p. 34

Calculate a Percent Diff p. 34

  • The number of decimal places that appear in the results of the formula depends on the width of the column the formula is in.

  • Don't worry that the percentages Excel calculates don't look like percentages. Later, in Chapter 6, we'll format the worksheet so the numbers look like percentages.

  • If the budgeted amount in a cell is 0, the formula for the percent difference will display the error message #DIV/0! Enter this formula in cell E3 to prevent that error: =IF(ISERR(D3/B3),0,D3/B3) This rather complex formula uses logic to determine whether the formula results in an error and, if it does, results in 0.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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