How to put the if condition formula in calculated filed?

[basavarajkh]

How to put the if condition formula in calculated filed? in pivot table, Excel 2003


My clints condition is

98-100 0%

96-97.9 10%

93-95.9 30%

90-92.9 50%

85-89.9 65%

<84.9 No Incentive


& I applied formula like below


=IF(E18>100,"0%",(IF(E18>97.9,"0%",(IF(E18>95.9,"10%",(IF(E18>92.9,"30%",(IF(E18>89.9,"50%",IF(E18>84.9,"65%","NO INCENTIVE"))))))))))


but how to put the above formula in calculated filed in Pivot Table, Excel 2003


Please help me Immediately.


- Basavaraj K H

Jagdamba Infosys Services

Bengaluru

Karnataka

 

[oldchippy]

Hi,


Take a look here


http://www.contextures.com/excel-pivot-table-calculated-field.html