| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDEX function to return array row. | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Return value with using Excel function | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
