something like
=if(a121,.2,if(a113,.25,if(a16,.33,if(a1=0,.45 ,""))))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"vsors" wrote in message
...
. . . 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