| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specific formula query
Excel 2003
I want a cell to show a different value depending on whether another cell shows less than, equal to, or more than a range of values. For example: If value in cell X is 16 or less, I want cell Y to show 1 If value in cell X is more than 16, but less than or equal to 32, I want cell Y to show 2 If value in cell X is more than 32, but less than or equal to 48, I want cell Y to show 3 And so on... Help please, can't seem to create the right syntax to make this happen... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| query formula | Excel Discussion (Misc queries) | |||
| Query Items Listed During a Specific Time Period | Excel Discussion (Misc queries) | |||
| formula Query | Excel Discussion (Misc queries) | |||
| Query into specific columns | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Threaded Mode
