2003 replacement formula for 2000

  • Thread starter Thread starter Richardjs60
  • Start date Start date
R

Richardjs60

Hi
I have a formula which works in excel 2003 it trckes the change from a
pivot table cell and places it in a seperate spreedsheet
as the pivot table changes the formula trckes where the new cell is and
corrects the other spreedsheet
the formula is
=IF(ISERROR(GETPIVOTDATA("Amount",Breakup!$B$7,"Code",A7)),0,GETPIVOTDATA("Amount",Breakup!$B$7,"Code",A7))

I need to use this in excel 2000 BUT it keeps returning as an error .
Can anybody help with a substitute formula that will do same in 2000
thanks for any help
Richard
 
The following should work in Excel 2000:


=IF(ISERROR(GETPIVOTDATA(Breakup!$B$7,A7)),0,GETPIVOTDATA(Breakup!$B$7,A7))
 
Yes it was
when I copied I ended up with a space between "pivot"
I now appears to be working fine
thank you very much
regards

Richard Sutton
 
Back
Top