| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statements
I need a statement that will allow me to get answer based on a certain criteria
I have a column of answers ranging from -400 to 400. Now I need a certain range of numbers to be changed into one value. < -150 has to come as a -2 150 to -20 has to come up at a -1 20 - 150 has to come up as a 0 150 - 250 has to come up as a1 250 has to come up as a 2 I want the single integars in a column right beside the larger number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if- then statements | Excel Worksheet Functions | |||
| IF statements | Excel Discussion (Misc queries) | |||
| IF Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| If statements | Excel Discussion (Misc queries) | |||
Threaded Mode
