2007 to 2003 functionality
 

I have excel 2007 and transferred a file to a user that only has 2003. When
trying save this in the 2003 format the compatibity checker gives me 42
formulas that have significant loss of functionality. All of the formulas
have the IFERROR function in them. Is there a fix for this problem? It
casuse all 42 of thes formulas to put the #name error in the field. One of
the formulas looks like this.
Did the IFERROR function even exist in 2003 version?


=IFERROR(HLOOKUP(F7,$D$36:$N$40,5,FALSE),"")

2007 to 2003 functionality
 

The IFERROR function is new to 2007, and is not available in earlier
versions, regardless of how the file is saved. Users with 2003 or
earlier will get a #NAME? error anywhere the IFERROR function is used.
You can write your formulas like

=IF(ISERROR(your formula),result if error,your formula)

In your example, this would be

=IF(ISERROR(HLOOKUP(F7,$D$26:$N$40,5,FALSE)),"",HL OOKUP(F7,$D$26:$N$40,5,FALSE))

This accomplishes the same thing as IFERROR, except that in most cases
the formula will be calculated twice, once within ISERROR and then
again in the FALSE part of the IF function, assuming the formula is
not an error. With large workbooks and/or complicated lookups, you
might take a performance hit.


Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]





On Wed, 27 Jan 2010 14:13:01 -0800, Russell P
wrote:

I have excel 2007 and transferred a file to a user that only has 2003. When
trying save this in the 2003 format the compatibity checker gives me 42
formulas that have significant loss of functionality. All of the formulas
have the IFERROR function in them. Is there a fix for this problem? It
casuse all 42 of thes formulas to put the #name error in the field. One of
the formulas looks like this.
Did the IFERROR function even exist in 2003 version?


=IFERROR(HLOOKUP(F7,$D$36:$N$40,5,FALSE),"")

2007 to 2003 functionality
 

To replicate Iferror in 2003, use:
=IF(ISERROR(HLOOKUP(F7,$D$36:$N$40,5,FALSE)),"",HL OOKUP(F7,$D$36:$N$40,5,FALSE))

Regards
Fred

"Russell P" wrote in message
...
I have excel 2007 and transferred a file to a user that only has 2003.
When
trying save this in the 2003 format the compatibity checker gives me 42
formulas that have significant loss of functionality. All of the formulas
have the IFERROR function in them. Is there a fix for this problem? It
casuse all 42 of thes formulas to put the #name error in the field. One
of
the formulas looks like this.
Did the IFERROR function even exist in 2003 version?


=IFERROR(HLOOKUP(F7,$D$36:$N$40,5,FALSE),"")

2007 to 2003 functionality
 

Chip and Fred gave you the solution, but you may want to consider using xl2003
if you have to support xl2007 and xl2003.

I bet you'll have fewer problems with xl2007 users opening an xl2003 workbook.

(It's never a bad idea to develop the workbook in the earliest version of excel
that you have to support.)

Russell P wrote:

I have excel 2007 and transferred a file to a user that only has 2003. When
trying save this in the 2003 format the compatibity checker gives me 42
formulas that have significant loss of functionality. All of the formulas
have the IFERROR function in them. Is there a fix for this problem? It
casuse all 42 of thes formulas to put the #name error in the field. One of
the formulas looks like this.
Did the IFERROR function even exist in 2003 version?

=IFERROR(HLOOKUP(F7,$D$36:$N$40,5,FALSE),"")

--

Dave Peterson