Trying to use multiple if

[jimd1768]

I have a small template. I have a team of 8 people and I am trying to calculate a bonus payment for them.

In the payment column, if the percentage is between 80-90%, then their actual is * by 2.50 and so on.

In the Bonus column if they are 100% - 124.9% - a payment of 100 is made and 200 if 125% or above.

I am not sure if you can use multiple "If" statements.

any help would be greatly appreciated.

Thank you in advance

[Moo the Dog]

Hi jimd,

Try this in E9: =C9*LOOKUP(D9,{0,0.8,0.9,1,1.25},{1,2.5,5,7.5,9})

and this in F9: =IF(D9>=1.25,200,IF(D9>=1,100,0))

Hope this helps...

- Moo

[FDibbins]

what about between 90 and 100%?

[Moo the Dog]

It has more detail in the file, including the 90% scenario.

[jimd1768]

Thank you Moo. That was exactly what I was looking for.

I really appreciate your help.


Jim

[Moo the Dog]

Glad to help!