One more to work with.

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


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 07:13:01 -0700, vsors
wrote:

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