E
Eva Shanley
Hi,
I need to modify a formula in a spreadsheet created in XP;
I'm making the changes in Excel 2000. I get a message
saying there's an error in the formula when I enter it.
The formula seems to return the correct data when the file
is opened in 2000, I just can't edit it. I wondered if
anyone knew why; I've included the formula below. The
highlighted word in the formula bar is "Sub Segment".
Thanks for all your help.
=IF(AM$6=0,0,IF(ISERR(GETPIVOTDATA("Sum of
Present",Pivot1H!$A$2,"Sub
Segment",$A9,"CountPromo",$E9,"Week2",OFFSET
(PlanMonths7to12,0,AM$6,1,1))),IF($E9="Turn",1,""),IF
(GETPIVOTDATA("Sum of Present",Pivot1H!$A$2,"Sub
Segment",$A9,"CountPromo",$E9,"Week2",OFFSET
(PlanMonths7to12,0,AM$6,1,1))>0,1,0)))
I need to modify a formula in a spreadsheet created in XP;
I'm making the changes in Excel 2000. I get a message
saying there's an error in the formula when I enter it.
The formula seems to return the correct data when the file
is opened in 2000, I just can't edit it. I wondered if
anyone knew why; I've included the formula below. The
highlighted word in the formula bar is "Sub Segment".
Thanks for all your help.
=IF(AM$6=0,0,IF(ISERR(GETPIVOTDATA("Sum of
Present",Pivot1H!$A$2,"Sub
Segment",$A9,"CountPromo",$E9,"Week2",OFFSET
(PlanMonths7to12,0,AM$6,1,1))),IF($E9="Turn",1,""),IF
(GETPIVOTDATA("Sum of Present",Pivot1H!$A$2,"Sub
Segment",$A9,"CountPromo",$E9,"Week2",OFFSET
(PlanMonths7to12,0,AM$6,1,1))>0,1,0)))