That's exactly what I needed!!! Thanks so much!

"Don Guillett" wrote:


just start at the top. Untested

=if(a14,1,if(a1=3,.975,if(a1=2,.95,if(a1=1,.92 5,"")))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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?