Error message

A

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??
 
S

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(D5:D6) will not.

HTH

Sandy
 
Top