Mangesharalkar
New Member
- Joined
- Apr 27, 2016
- Messages
- 10
Hi All,
I am entering the below formula but it says missing parenthesis
=IF(AND(C10>0%,C10<80%),0,IF(AND(C10>=80%,C10<=100%),C7*C10,IF(AND(C10>=100%,C10<=120%),(C5*0.5%+(C7-C5)*1.5%,IF(C10>120%,(C5*0.75%+C5*120%*1.5%+(C7-C5*120%)*2%
Can any one help
C5 is Domain Target
C7 is Achievement
Range is below
<colgroup><col><col></colgroup><tbody>
</tbody>
I am entering the below formula but it says missing parenthesis
=IF(AND(C10>0%,C10<80%),0,IF(AND(C10>=80%,C10<=100%),C7*C10,IF(AND(C10>=100%,C10<=120%),(C5*0.5%+(C7-C5)*1.5%,IF(C10>120%,(C5*0.75%+C5*120%*1.5%+(C7-C5*120%)*2%
Can any one help
C5 is Domain Target
C7 is Achievement
Range is below
Range | Incentive % |
0-80% | Nil |
80-100% | 0.75% |
100 -120 % | 1.50% |
120 & above% | 2.00% |
<colgroup><col><col></colgroup><tbody>
</tbody>
Last edited: