Subscribe
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
