Excel 2007 : IFERROR to work in 2003

After doing a little Googling, I have found that IFERROR can't work in 2003.
Is there a viable alternative?

Here is the code I am using

=IF(ISBLANK(C6)=TRUE,"",IFERROR(IF(C6<=0,1234,1232),""))

This references the cell C6 and if that cell has a plus figure cell A6 will report 1232 and will report 1234 for a debit figure.
However, I need the ISBLANK and IFERROR so that if cell C6 is blank, then cell A6 will stay blank and report nothing.
Unfortunately, in my office, some are using Excel 2007 and others are using 2003.
Is there an alternative to my IFERROR so that all users can use this spreadsheet?

Thanks

Nick

Originally Posted by Nikeyg

After doing a little Googling, I have found that IFERROR can't work in 2003.
Is there a viable alternative?

Here is the code I am using

=IF(ISBLANK(C6)=TRUE,"",IFERROR(IF(C6<=0,1234,1232),""))

This references the cell C6 and if that cell has a plus figure cell A6 will report 1232 and will report 1234 for a debit figure.
However, I need the ISBLANK and IFERROR so that if cell C6 is blank, then cell A6 will stay blank and report nothing.
Unfortunately, in my office, some are using Excel 2007 and others are using 2003.
Is there an alternative to my IFERROR so that all users can use this spreadsheet?

Thanks

Nick

Hi and welcome to the board

If C6 is or blank or contains a value, you will not need the IFERROR( ISERROR in 2003) because the error has alrady been dealt with in the first part of the function.


So =IF(ISBLANK(C6)=TRUE,"",IF(C6<=0,1234,1232))

If C6 can also contain an error value ( being the result of some calculation,

=IF(or(iserror(c6),ISBLANK(C6)),"",IF(C6<=0,1234,1232))

Thanks for the quick responses guys.

arthurbr's solution works perfectly, and now I have a fully functioning worksheet,
Brilliant.

Thanks for the warm welcome, expect my idiotic questions again in future