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?
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?