(Formulas Ribbon | Formula Auditing Group)

If you have errors in your spreadsheet and not sure why there is a nice function called formula where you there is a handy feature in the Formula Auditing Group on the Formulas Ribbon called Trace Precedents and Trace Dependents.  This can help you to see how the formula is made up and where the possible error could be.