IFERROR in 2003 version


D

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.
 
Ad

Advertisements

R

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.
 
D

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?
 
R

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.
 
D

Drew

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

Cheers.
 
Ad

Advertisements

M

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)),"")"
 
Ad

Advertisements


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

Top