2003 replacement formula for 2000

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
 
D

Debra Dalgleish

The following should work in Excel 2000:


=IF(ISERROR(GETPIVOTDATA(Breakup!$B$7,A7)),0,GETPIVOTDATA(Breakup!$B$7,A7))
 
R

Richardjs60

Hi Thanks BUT now in the relevant cell I get #NAME?
instaed of the figure ?
Richar
 
R

Richardjs60

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2000 pivot HELP!!!! 1
Rounding up values 1
Change GETPIVOTDATA cell reference to A1 style 1
2003 formula for Pivot 1
GETPIVOTDATA General 3
Slicing Data (Alternative to SUMIFS) 2
formulas referencing pivot table cells 1
Is there any way to disable the "getpivotdata" automatic formula? 2

Top