Excel Conditional formula for different scenarios

Joined
Dec 26, 2019
Messages
1
Reaction score
0
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top