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.

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" <(E-Mail Removed)> wrote in message
news:C28B90AC-2768-45BC-92AD-(E-Mail Removed)...
> 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.
>

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" <(E-Mail Removed)> wrote in message
> news:C28B90AC-2768-45BC-92AD-(E-Mail Removed)...
> > 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.
> >
>
>

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" <(E-Mail Removed)> wrote in message
news:3B09B6FA-0834-43CB-9EDE-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:C28B90AC-2768-45BC-92AD-(E-Mail Removed)...
>> > 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.
>> >
>>
>>

Thanks.

"Rick Rothstein" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:3B09B6FA-0834-43CB-9EDE-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
> >> news:C28B90AC-2768-45BC-92AD-(E-Mail Removed)...
> >> > 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.
> >> >
> >>
> >>
>
>