| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF question
Hi all
Can anyone help me with some syntax please? I have a value in column T, an integer indicating age. In column U I need to enter a string depending on the age band it falls into: If less than 25, "band 1" If between 25 and 49, "band 2" If over 49, "band 3" I figure this is a nested if but am beaten by band 2 (=25 AND <50). Thanks in advance as ever! Sue JB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
| Excel nested IF formula question | Excel Discussion (Misc queries) | |||
| large formula question - Max nested functions | Excel Worksheet Functions | |||
| Nested if question | Excel Discussion (Misc queries) | |||
| IF NESTED Question | Excel Worksheet Functions | |||
Threaded Mode
