Morning all,
I need to calculate my bonus pay-out against achievements as follows:
- Above 95% achievement but below or equal to 100% the pay-out follows a linear rule.
- Above 100% and until 110% the pay-out doubles thus reaching 200% at 110%.
-
I am using this formula but not sure is right:
=IF(I16<0,95;0;IF(I16<=1;(I16-0,9)/0,1;IF(I16>1,2;2;1+((I16-1)/0,2))))*H16*$M$5
I6 = achievement %
H16= input data i.e. sales
M5 = salary info
Thanks all in advance,
I need to calculate my bonus pay-out against achievements as follows:
- Above 95% achievement but below or equal to 100% the pay-out follows a linear rule.
- Above 100% and until 110% the pay-out doubles thus reaching 200% at 110%.
-
I am using this formula but not sure is right:
=IF(I16<0,95;0;IF(I16<=1;(I16-0,9)/0,1;IF(I16>1,2;2;1+((I16-1)/0,2))))*H16*$M$5
I6 = achievement %
H16= input data i.e. sales
M5 = salary info
Thanks all in advance,