Formulas almost always refer to other cells which then subsequently refer to other cells, etc. etc.
Use Tools, Formula Auditing, Trace Error
Helps to visualize steps through all cells referenced by the formula