I am creating a spreadsheet where I need to assign a point value to a range
of numbers. For instance, if a person was 100-102% of there sales target,
they would earn 5 points. If they were 98-99.9%, they earn 4 points. How
would I set up a formula to populate the points by just typing in the % they
were vs. their sales target?