| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
range in an IF statement
I need the IF statement to look for numbers 1100 through 1199, then put 11 in
another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement (non nested) that compares cell value against range | Excel Worksheet Functions | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Using a worksheet name from a range | Excel Worksheet Functions | |||
| How do I use a range of numbers in an if statement? | Excel Worksheet Functions | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
Threaded Mode
