i want to create an IF formula to bring back one of four results .

[vsors]

. . . which would be dependant on the value of the cell.
eg.
0-5 = 45%
6-12 = 33%
13-20 = 25%
21 > = 20%

i want the formula to automatically return the correct percentage, can
anyone tell me how the formula should look please?

thanks,
Vicky

 

[Don Guillett]

something like
=if(a1>21,.2,if(a1>13,.25,if(a1>6,.33,if(a1>=0,.45,""))))

 

[vsors]

thank you both so much for the help - worked first time!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

 

[Gord Dibben]

One more to work with.

=LOOKUP(B1,{0,6,13,21},{0.45,0.33,0.25,0.2})


Gord Dibben MS Excel MVP