Nested IF Statement Help
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
|