Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Adding a custom function to the default excel function list | Excel Programming |