### Troubleshoot the
Formulas

**What Do
You See?**
The
**#Value! **means that there is an error. Please audit the
spreadsheet. Double click on **Cell D9.** Excel highlights
the cells in this formula: =D8+B5

**How Did
That Happen?
**Part of the formula is still correct. It equals yesterday’s sales—the
Cell above me—and adds to it.

Most formulas automatically use **Relative References**. A
Relative Reference adjusts the the cell references when you copy or
fill it down.

In our example, **
=D8+B5 **becomes **=D9+B6** in the next Row down.

In **Cell D9**, the formula adds a number to
a label. Hence, the error **#Value!**