willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
I just have a quick question about a formula I have that is referencing a pivot table. In some areas the pivot table will not have data yet. How can I modify the below formula that if there is an error, to display a blank cell?
=GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38
I tried:
=IFERROR(=GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38),"")
But Excel does not accept this and says I have an error somewhere.
Your help would be much appreciated.
Thank you very much.
Carla
=GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38
I tried:
=IFERROR(=GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38),"")
But Excel does not accept this and says I have an error somewhere.
Your help would be much appreciated.
Thank you very much.
Carla