One way:

=IF(COUNT(A1),IF(A1=4,100%,IF(A1=3,97.5%,IF(A1= 2,95%,IF(A1=1,92.5%,"")))),"")

Format as Percentage 1 decimal place.

--
Biff
Microsoft Excel MVP


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