PDA

View Full Version : Using if statements in PivotTable formulas



Djblois
11-12-2009, 12:47 PM
I am trying to use an if Statement in Pivot Table Calculated fields but it is not doing anything. Do I need to do something special?

This is what I had:

=IF(Amt="",0,Profit/Amt)

and no matter what it always calculates the Profit/Amt portion

Bob Phillips
11-12-2009, 02:03 PM
Guessing, but maybe

=IF(Amt=0,0,Profit/Amt)

Djblois
11-12-2009, 02:05 PM
Thanks Xld but I tried that as well and it did the same thing. I tried with nothing, with "", and with 0. They all do the same thing.