MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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