Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISERROR on GETPIVOTDATA
I have the following formula, but I need to factor in the ISERROR function as
well, but I'm not sure how to include it. It needs to go in just before the 2 GETPIVOTDATA functions but I've tried it and it doesn't seem to work for me. Could someone just clarify how I should include them? =IF($S30V$9,"",IF($H30="",GETPIVOTDATA("GWP exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"BrokerCo mpanyId",$F30,"Group Code","","Years",YEAR(V$9)),GETPIVOTDATA("GWP exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group Code",$H30,"Years",YEAR(V$9)))) Many thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISERROR on GETPIVOTDATA
Hi,
Try =IF($S30V$9,"",IF($H30="",GETPIVOTDATA("GWP exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"BrokerCo mpanyId",$F30,"Group Code","","Years",YEAR(V$9)),IF(ISERR(GETPIVOTDATA( "GWP exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group Code",$H30,"Years",YEAR(V$9))),"",GETPIVOTDATA("GW P exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group Code",$H30,"Years",YEAR(V$9))))) If you are using 2007 look at IFERROR instead. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sarah (OGI)" wrote: I have the following formula, but I need to factor in the ISERROR function as well, but I'm not sure how to include it. It needs to go in just before the 2 GETPIVOTDATA functions but I've tried it and it doesn't seem to work for me. Could someone just clarify how I should include them? =IF($S30V$9,"",IF($H30="",GETPIVOTDATA("GWP exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"BrokerCo mpanyId",$F30,"Group Code","","Years",YEAR(V$9)),GETPIVOTDATA("GWP exc. IPT",'Company Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group Code",$H30,"Years",YEAR(V$9)))) Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with ISERROR | Excel Worksheet Functions | |||
iserror help | Excel Worksheet Functions | |||
use of ISERROR | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) |