. . . 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