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

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?

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

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


"rancher fred" wrote:

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?

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

Hi Fred, try this

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

HTH
Martin