hiding #value error
Posted by Bill Weaver on January 16, 2002 3:12 PM
Like Dargan 3 or 4 messages back I am having trouble hiding the #value error. I am multiplying to cells D8*A8. D8 contains a value that will be plugged in as the form is filled out. I want the cell where the #value is appearing to remain blank until the vaes are filled in. The short of it....how do you hide this #value. Any ideas?
Posted by Aladin Akyurek on January 16, 2002 3:27 PM
Bill --
Try instead, e.g.,:
=IF(ISNUMBER(D8), D8*A8,0) or
=IF(AND(ISNUMBER(D8),ISNUMBER(A8)),D8*A8,0)
BTW, if D8 and or A8 are really empty, until a numeric comes in, you shouldn't get a #VALUE! error in the cell of D8*A8.
Aladin
Posted by Bill Weaver on January 16, 2002 3:36 PM
Re: Aladin...
D8 actually pulls data from another worksheet anthe formula involved was causing the error I presume. Your fix worked great though. Thanks for your time.
Bill
