Creating a "Point System" Spreadsheet
One option might be =IF(A3=7.5%,2+INT((A37.5%)/0.5%),"")
It is a bit inconsistent as to how it treats values which lie right on the
border, as presumably some values fall victim to rounding errors in fixed
point binary. If need be, a ROUND function could presumably tidy the
situation up.

David Biddulph
"lanmari" wrote in message
...
Hi There,
I am trying to create a spreadsheet where if a certain cell has a number
that falls into a certain range, it would be assigned a certain
number/point.
For example: If a rate is 7.5%8%, 2 pts will be assigned; if 8%8.5%,
then
3 points will be assigned and so on.
How do I do this?
Thank you,
MT
