Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How would I put this together as a nested IF statement? It's evaluating 4
cells (which only 1 cell would contain data). 0-30 =IF(L2<30,"0-30","") 31-60 =IF(AND(L2=31,L2<=60),"31-60","") 61-90 =IF(AND(L2=61,L2<=90),"61-90","") 91 =IF(L291,"91","") I want the AGE column to contain the if statement. So it looks to find which field that contains the values and places it under the AGE column. Age 0-30 31-60 61-90 91 91 91 91 91 61-90 61-90 61-90 61-90 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF statement | Excel Worksheet Functions | |||
Nested if statement | Excel Worksheet Functions | |||
how to do a nested if statement | Excel Discussion (Misc queries) | |||
Nested if then else statement | Excel Worksheet Functions | |||
Nested If statement | Excel Worksheet Functions |