Excel Conditional formula for different scenarios

Dec 26, 2019
Reaction score
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:


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