Between Function
 

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.

Between Function
 

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?

--
Rick (MVP - Excel)


"Lynn Brown" wrote in message
...
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.

Between Function
 

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" wrote:

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?

--
Rick (MVP - Excel)


"Lynn Brown" wrote in message
...
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.

Between Function
 

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.

--
Rick (MVP - Excel)


"Lynn Brown" wrote in message
...
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" wrote:

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?

--
Rick (MVP - Excel)


"Lynn Brown" wrote in message
...
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.