You didn't say what you want to happen if A1 is less than 1. Assuming you
can't have such values, this formula will work for the numbers you posted...

=0.9+MIN(0.025 * INT(A1),1)

where you would format the cell as Percentage. If numbers less than 1 are
possible and you want such values to be 0, then use this formula instead...

=MAX(0,0.9+MIN(0.025 * INT(A1),1))

where you can replace the first 0 with whatever fractional value less than
0.925 that you want.

--
Rick (MVP - Excel)


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