Desperate help needed on formula

P

prabbetts

Hi all,

really struggling with this one.........

I am trying to create a commision sheet where by when certain percentages
are reached different pay levels are met.....

ie

<75% = £35
76-100% = £45
101 > = £55

I have tried using if formulas but will only give me a choice of two not
three :-(

Any ideas??????
 
J

Jacob Skaria

Try the below and feedback..

Using IF statements...
=IF(A1<75,35,IF(A1<=100,45,IF(A1>100,55)))


Alternatively if you have more conditions use LOOKUP will ease a bit easy
for you to edit and reuse...
=LOOKUP(A1,{0,1,75,101},{0,35,45,55})

If this post helps click Yes
 
Top