route217

asked on

# formula error when file is opened in 2003

Hi Experts

i am using the following formula in excel 2007

=IFERROR(SUM(OFFSET('Summary - Daily'!$U$49,MATCH($D52,'Summary - Daily'!$D$50:$D$53,0),MATCH(F$8,'Summary - Daily'!$F$8:$AK$8,0),1,6)),"")

which work fine

when i save the workbook as as 97-2003 and open it up in excel 2003 i am getting #name error and the formula changes to

=_xlfn.IFERROR(SUM(OFFSET('Summary - Daily'!$U$49,MATCH($D52,'Summary - Daily'!$D$50:$D$53,0),MATCH(F$8,'Summary - Daily'!$F$8:$AK$8,0),1,6)),"")

how do i fix this

i am using the following formula in excel 2007

=IFERROR(SUM(OFFSET('Summa

which work fine

when i save the workbook as as 97-2003 and open it up in excel 2003 i am getting #name error and the formula changes to

=_xlfn.IFERROR(SUM(OFFSET(

how do i fix this

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hi experts

second part of the question

https://www.experts-exchange.com/questions/28226951/amend-formula-part-2.html

second part of the question

https://www.experts-exchange.com/questions/28226951/amend-formula-part-2.html

IFERROR is only supported since XL2007

pls try

Open in new window

Regards