| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF B11 is less than 1000, enter 0 in D11, IF B11 is between...
Would you please help me create a formual that will return one of five values?
If B11 is less than 1000, enter 0 in D11 If B11 is more than 1000 and less than 2000, enter 1 in D11 If B11 is more than 2000 and less than 3000 enter 2 in D11 if B11 is more than 3000 and less than 4000 enter 3 in D11 if B11 is equal to or greater than 4000 enter 4 in D11 Thank you very very much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To filter for 100 documents out of 1000 | Excel Discussion (Misc queries) | |||
| Multiply/ Round by 1000 | Excel Discussion (Misc queries) | |||
| 1000 to 1 and 1 to 1000 | Excel Worksheet Functions | |||
| 1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
| I am trying to figure out how to add per 1000 | Excel Worksheet Functions | |||
Threaded Mode
