Ratings based on numerical value

[OlSchool]

Hi All

I need some help with the following:

How do i do the following?

In column A i have a numerical value and in column B i have a alphabetical rating based on the value in column A. I need a formula that will automatically pull the ratings..

if the figure in column A is greater then 1056 the rating in column B is "A"
if the figure in column A is between 960 and 1055 the rating in column B is "B+"
if the figure in column A is between 864 and 959 the rating in column B is "B"
if the figure in column A is between 768 and 863 the rating in column B is "C"
if the figure in column A is below 767 the rating in column B is "D"

[Colin Legg]

Hi,

There are a few gaps in the logic, eg. what if the value is exactly 767?

if the figure in column A is between 768 and 863 the rating in column B is "C"
if the figure in column A is below 767 the rating in column B is "D

Allowing for adjustments depending on those gaps, I think the general formula you are looking for in B2 is this:

Please Login or Register  to view this content.

[Domski]

Or you can use a lookup table like this which makes it easy to maintain update the values should they change.

Dom

[OlSchool]

Thank you Colin and Domski!!!