GETPIVOTDATA

[Sunny FL]

I have a situation where my GETPIVOTDATA returns nothing (#REF) because that
reference isn't in the source data, but I want a 0, to appear when this
happens rather than a #REF. It seems like there is a syntax that I could use
in my formula to make this happen.

Help?

 

[Roger Govier]

Hi Sunny

Substitute your GetPivotData formula in place of your_formula in the
following.
If you are on XL2007 then use
=IFERROR(your_formula,0)

If on XL2003 or earlier use
=IF(ISERROR(your_formula),0,your_formula)

 

[Sunny FL]

That's EXACTLY the syntax I was looking for. Thanks so much!