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 •

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:


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

Report •

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