IFERROR in 2003 version

[Drew]

All ...

Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save
functionality when being viewed in Excel 2003?

Thank you.

 

[Roger Govier]

Hi Drew

Unfortunately, no.
You will need to use something to trap for the error so that it will work in
both versions.

Obviously it could be
=IF(ISERROR(your_formula),"",your_formula)

but dependent upon what your_formula is, it may be possible to use an easier
(faster) test to see whether Null or your_formula should be returned.

If you want to post back with your actual formula, maybe we can suggest a
different test.

 

[Drew]

Thanks Roger ... a couple of examples are below.

=IF(I5="","",IFERROR(C11-SUM(F3*I5),""))

=IF(I5="","",IFERROR(SUM(F11,I11,L11),""))

=IF(H12="","",IFERROR(G12*$I$5,"Section 1 First"))

Also ... is EDATE supported in 2003?

 

[Roger Govier]

Hi Drew

If they are numerical values in the cells, then you don't really need the
error traps.
If any values are 0, then you may end up with a zero result, but none of the
formulae shown are divisions, hence there will not be a #DIV/0 error

You could use
=IF(I5="","",IF(COUNT(C11,F3,I5)<3,"",C11-(F3*I5)))

Since none of the formulae are really complex, then you could simply use
=IF(I5="","",IF(ISERROR(C11-(F3*I5)),"",C11-(F3*I5)))

EDATE is available in XL2003, provided you have the Analysis Toolpak
installed, Tools>Addins>Analysis Toolpak.

 

[Drew]

Roger ... thank you kindly. The second option worked fine in all cases with
some ammendment specific to the cells formula requirement.

Cheers.

 

[mr.kazakh]

вторник, 8 Ð°Ð¿Ñ€ÐµÐ»Ñ 2008 г., 13:32:30 UTC+5 пользователь Roger Govier напиÑал:

Hi Drew

If they are numerical values in the cells, then you don't really need the
error traps.
If any values are 0, then you may end up with a zero result, but none of the
formulae shown are divisions, hence there will not be a #DIV/0 error

You could use
=IF(I5="","",IF(COUNT(C11,F3,I5)<3,"",C11-(F3*I5)))

Since none of the formulae are really complex, then you could simply use
=IF(I5="","",IF(ISERROR(C11-(F3*I5)),"",C11-(F3*I5)))

EDATE is available in XL2003, provided you have the Analysis Toolpak
installed, Tools>Addins>Analysis Toolpak.

Can anyone help me! I need to convert this function to make it readoble in excel 2003.
"=_xlfn.IFERROR(INDEX('List of ICT Contracts'!$A$3:$A$56,SMALL(IF($B$2='List of ICT Contracts'!$G$3:$G$56,ROW('List of ICT Contracts'!$A$3:$A$56)-2,""),ROW()-4)),"")"