# Thread: IFERROR Question

1. Hi

I have created a workbook in Excel 2007 for my daughter using IFERROR, but she has Excel 2003 I have saved the workbook a 97-2003 but will the IFERROR work in 2003?

Regards

Braddy

2. No, IFERROR won't work in Excel 2003. You will have to change a formula of the form

=IFERROR(X,Y)

to

=IF(ISERROR(X),Y,X)

or

=IF(NOT(ISERROR(X)),X,Y)

3. [quote name='HansV' post='788764' date='13-Aug-2009 10:56']No, IFERROR won't work in Excel 2003. You will have to change a formula of the form

=IFERROR(X,Y)

to

=IF(ISERROR(X),Y,X)

or

=IF(NOT(ISERROR(X)),X,Y)[/quote]
Hi Hans

Thanks for the information I have had several attempt to convert this =IFERROR(VLOOKUP(G8,milesto,2,0),"") I just cant get the sequance correct

Regards
Braddy

4. Try

=IF(ISERROR(VLOOKUP(G8,milesto,2,0)),"",VLOOKUP(G8 ,milesto,2,0))

5. [quote name='HansV' post='788773' date='13-Aug-2009 12:57']Try

=IF(ISERROR(VLOOKUP(G8,milesto,2,0)),"",VLOOKUP(G8 ,milesto,2,0))[/quote]

Hi Hans

My grateful Thanks.

Regards

Bradddy

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•