I want to return the #VALUE! as a blank cell.

K

kgb1953

I am creating an electronic order form and need to show #VALUE! as a blank
cell. When using =IF(ISERROR(A2)="TRUE"," ",<REST OF FORMULA>), I can no
longer total that column. Any suggestions?
 
D

David Biddulph

Firstly you are checking for the text string "TRUE", whereas you ought to
check for the boolean value TRUE.
Secondly for such a boolean you don't need ...=TRUE, you just need
=IF(ISERROR(A2),...
Thirdly you are writing a non-zero length string " " where you could get
away with the empty string ""
Fourthly, you'll find that totalling the column using a formula like
=SUM(F1:F14) will work in situations where =F1+F2+... won't.
 
Top