Error message

[alexm999]

I have a cell adding =D5+D6

When nothing is in D5 and D6 I get an error #Value in the cell.
How can I get rid of that??

 

[Sandy Mann]

Alex,

To get that error message you must have something in the cell. Are you b
any chance 'clearing' the cell the cell by entering a space? I another cell
try =ISTEXT(D5) and =ISTEXT(D6). If you get a TRUE then you have text in
the cell. The plus sign will give you this error if you have text in either
of the cells but =SUM(D56) will not.

HTH

Sandy

 

[alexm999]

Thanks! Did the trick..