Can I use IF function in calculated fields in a pivot table?

  • Thread starter Bloke in Excel Trouble
  • Start date
B

Bloke in Excel Trouble

I want to add a logical function to the calculated field but I don't seem
able top do so - is there a limit on the functions you can use?
 
P

Peo Sjoblom

If you are referring to a text value like

=if(field2="name",

then you can't since all the text values are seen as zero in a calculated
field. AFAIK the only way is to add the if function to the source data
--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
C

Charles Williams

There are limits on the functions you can use but IF is ok:
=IF(Sales>0,PROFIT/SALES,0)
 
Top