Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GETPIVOTDATA | Excel Worksheet Functions | |||
GETPIVOTDATA between XL 2K & 03 | Excel Discussion (Misc queries) | |||
GETPIVOTDATA = #N/A | Excel Discussion (Misc queries) | |||
GETPIVOTDATA | Excel Discussion (Misc queries) | |||
GetPivotData need help | Excel Worksheet Functions |