GETPIVOTDATA

  • Thread starter Thread starter Sunny FL
  • Start date Start date
S

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?
 
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)
 
Back
Top