Microsoft Office Tutorials and References
In Depth Information
Auditing Your Formulas
5. Select the Scenario Summary radio button.
6. Click in the Result Cells text box and then click in a cell that contains
a formula that your scenario affects.
7. Click OK.
Auditing Your Formulas
Your spreadsheet results are only as good as the data you give it and the
formulas you create. Feed a spreadsheet the wrong data, and it will obviously
calculate the wrong result. More troublesome is when you feed a spreadsheet
the right data but your formula is incorrect, which produces a misleading
and incorrect result.
Even if Excel appears to be calculating your formulas correctly, recheck your
calculations just to make sure. Some common errors that can mess up your
formulas include:
Missing data: The formula isn’t using all the data necessary to calculate
the proper result.
Incorrect data: The formula is getting data from the wrong cell (or
wrong data from the right cell).
Incorrect calculation: Your formula is incorrectly calculating a result.
If a formula is calculating data incorrectly, you probably didn’t type the
formula correctly. For example, you may want a formula to add two numbers,
but you accidentally typed in the formula to multiply two numbers instead.
To check whether a formula is calculating data incorrectly, give it data that
you already know what the result should be. For example, if you typed the
numbers 4 and 7 into a formula that should add two numbers, but it returns
28 instead, you know that it’s not calculating correctly.
If your formula is correct but it’s still not calculating the right result, chances
are good it’s not getting the data it needs from the correct cells. To help you
trace whether a formula is receiving all the data it needs, Excel offers
auditing features that visually show you which cells supply data to which
formulas. By using Excel’s auditing features, you can
Make sure that your formulas are using data from the correct cells.
Find out instantly whether a formula could go haywire if you change a
cell reference.
Search JabSto ::

Custom Search