iferror statement in excel 2003

May 12, 2011 at 12:21:44
Specs: Windows XP
i use the iferror a lot in 2007 to give me a blank or a 0 when a formula has an error.. it doesnt exist in 2003 what is a solution.. for instance iferror(k6/g6," ")

See More: iferror statement in excel 2003

Report •

#1
May 12, 2011 at 18:29:06
How about:

=IF(ISERROR(K6/G6)," ",K6/G6)

BTW, this will return a space if there is an error, as will your IFERROR function above.

If you want a blank cell you should use:

=IF(ISERROR(K6/G6),"",K6/G6)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 13, 2011 at 05:40:52
right... ok.. i will try that.. i vaguely remembered something about iserror and isblank.. thanks

Report •
Related Solutions


Ask Question