Need Help Creating a Bonus Formula On Excel

[akeemceo]

Hello everyone, I'm very new to excel, the company I work with gave me the task to come up with a bonus structure for our team since I kept asking them about it. As a beginner I do not no where to start, but I saw the following Nested If and would like to know how I can put this together in an logical excel format. Respectfully


Nested If Statement! - Excel
Excel Forum
Thank you in advance for all your help!

I am looking for the correct setup of a nested if statement with 4-5 arguments

if sales reach a certain thershold 1% bounus

if sales increase 5% - 10% = 2% bonus

if sales increase 11%-15% = 3% bonus

and if sales increase 15% = 4% bonus

Thanks again for all the help!

[pecoflyer]

Suppose sales are in A2 and threshold in B2 the the percentage is returned by

Code: Select all

=IF(A2<B2;"";IF(A2=B2;0,01;MIN(0,04;(CEILING(A2/B2;0,05)-1)/5)))


I suppose you still have to multiply this percentage with another value to obtain the bonus, but I will leave that over to you

[Kevin UK]

As you are using the latest version of excel, use the new IFS function.