Greater then *OR equal* to 4 returns 100:

=LOOKUP(A1,{0,1,2,3,4;0,92.5,95,97.5,100})
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"charlie" wrote in message
...
I need to write an IF statement that will tell me the following:
If A1 is = 1 but <2, return 92.5%
If A1 is = 2 but <3, return 95%
If A1 is =3, but <4, return 97.5%
If A1 is 4 return 100%

Can someone please help?