Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
complex formula
i have a list of random numbers in column A1 0-75. i am trying to make a
formula that will predict results based on the number in column A that will appear in column B up to 29 should result in a letter W in column B 30 - 37 should result in a number 1 38 - 44 should result in 2C 45 - 55 should result in 2B 56 -65 should result in 2A 66 and over should result in 3 Have been trying all day, can get the numbers but as soon as I try to add letters I am lost. any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex average formula | Excel Worksheet Functions | |||
A formula that is too complex for Excel? | Excel Worksheet Functions | |||
Complex Formula Getting Error.. | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Complex formula | Excel Discussion (Misc queries) |