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

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?

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

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.
--
David Biddulph

"kgb1953" wrote in message
...
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?