GETPIVOTDATA
 

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?

--
Sunny FL

GETPIVOTDATA
 

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)
--
Regards
Roger Govier

"Sunny FL" wrote in message
...
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?

--
Sunny FL

GETPIVOTDATA
 

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


"Roger Govier" wrote:

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)
--
Regards
Roger Govier

"Sunny FL" wrote in message
...
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?

--
Sunny FL