If function returns #REF!, want it to return 0

R

rancher fred

I am trying to extract and sum data from a pivot table. In order to reduce
the number of formulas I am trying to nest the functions. My formula is as
follows:

=IF(GETPIVOTDATA("Meal",$A$3,"Formula #",175100,"Group
#",Sheet1!C2)="#REF!",0,GETPIVOTDATA("Meal",$A$3,"Formula #",175100,"Group
#",Sheet1!C2))

Sometimes the logic test will result in a #REF! error because the Formula #
175100 is not present at every Group #. Instead of returning the #REF! error
I want it to return a 0. How do I achieve this?
 
J

JMB

try:
=IF(ISERROR(GETPIVOTDATA("Meal",$A$3,"Formula #",175100,"Group
#",Sheet1!C2)),0,GETPIVOTDATA("Meal",$A$3,"Formula #",175100,"Group
#",Sheet1!C2))
 
M

MartinW

Hi Fred, try this

=IF(ISERROR(GETPIVOTDATA("Meal",$A$3,"Formula #",175100,"Group
#",Sheet1!C2)),0,GETPIVOTDATA("Meal",$A$3,"Formula #",175100,"Group
#",Sheet1!C2))

HTH
Martin
 
Top