PDA

View Full Version : Solved: Avoiding errors in formulas



YasserKhalil
07-26-2010, 06:18 AM
I know that in 2007 there's a function which can be used to avoid errors in formulas
=IFERROR(.............;"")

What about Office 2003???

How can I cure these errors?

Bob Phillips
07-26-2010, 06:33 AM
=if(iserror(formula),"",formula)

but the correct approach is to fix the error.

YasserKhalil
07-26-2010, 06:45 AM
Great
Wonderful

Thanks a lot