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. |
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 |