Formulas -> Formula Auditing->Trace Precedents

Tracing Errors What Does an Error Look Like? Here is a simple example we can try.   Before You Begin: Setup a Mistake Select Cell E8 and type: 360 Now Cell E8 does NOT have a formula. Yet, how would you know?   Try This: Trace the Precedents Select Cell E25. Go to Formulas->Formula Auditing. Click Trace Precedents. You will see an arrow from Cell E25 to Cell E6.    Click Trace Precedents again. What Do You See? You should see arrows in each Row that trace the formulas. You should see a "gap" in the tracings. This gap indicates that there is no formula in Cell E8.