Between Function

[Lynn Brown]

Good Morning All
I have a whole workbook full of data. I have compiled a summary page, and
the results are now numbers with decimals. They want this number converted
to a word (ie: Fair, Poor, Good, etc). I can do the change to word when it
is just a solid number (ie: 3, 4, 5, etc) but is there a way to tell it that
if the cell value is between 3 & 4 (ie: number is 3.5) that the value would
equal "Fair". I don't want to round the numbers up so they don't have a
decimal, as it will effect the end result.

 

[Rick Rothstein]

Your "etc" didn't help any... can you show us all the *ranges* and the word
descriptions that go with them? Also, you posted in a programming
newsgroup... are you really looking for a VB code solution or were you after
a worksheet formula solution?

 

[Lynn Brown]

I am not looking for VB solution, as the person that I am helping/advising
isn't that strong of an Excel user.
Currently, here are the numbers and values:
0 = No Skills
1 = Poor
2 = Fair
3 = Average
4 = Good
5 = Excellent

The actual data is a number from 0 - 5. Then they wanted an average by
category, so now the numbers are all decimal numbers. They still want the
numbers to be changed to the values indicated below, but we don't want to
round up 4.7 to 5 just to get a solid number. They would like 4.# to still
equal "Good"

 

[Rick Rothstein]

Since your data runs from 0 to 5, it sounds like it would be almost
impossible to get a final rating of Excellent. In any event, try this
formula in Row 2 of your column devoted to displaying the word
descriptions...

=IF(A2="","",CHOOSE(INT(A2)+1,"No
Skills","Poor","Fair","Average","Good","Excellent"))

Note, I started the formula in Row 2 because I assumed there was header
information in Row 1. Also, obviously, change the two column A references to
whatever column actually has your numerical ratings.

 

[Lynn Brown]

Thanks.

Since your data runs from 0 to 5, it sounds like it would be almost
impossible to get a final rating of Excellent. In any event, try this
formula in Row 2 of your column devoted to displaying the word
descriptions...

=IF(A2="","",CHOOSE(INT(A2)+1,"No
Skills","Poor","Fair","Average","Good","Excellent"))

Note, I started the formula in Row 2 because I assumed there was header
information in Row 1. Also, obviously, change the two column A references to
whatever column actually has your numerical ratings.