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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
blank cell return vs. a 0 8
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
formula finds values in apparently blank cells 1
Blank Check? 1
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b 2
#value error for sumproduct using RIGHT cmd 0

Back
Top