#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
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!