Nested IF Statement Help

[Donnie]

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(L2>91,"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

 

[Sheeloo]

1. Assuming Age is in L2 put this in AGE column row 2
=IF(L2<31,"0-30",IF(AND(L2>=31,L2<=60),"31-60",IF(AND(L2>=61,L2<=90),"61-90", IF(L2>91,"90>","ERROR"))))
This will put the correct range for any given age...
(I corrected the boundary conditions, you may check them again)
You do not need to have the four columns

2. If you already have data in the four columns say B-E
then you can simple put in the AGE column row 2
B2&C2&D2&E2 since three cells are blank and one contains the correct value
you will get the right result

 

[Donnie]

Let me correct something from down below. The current if statements I used
evaluate a Column of data called DAYS OUTSTANDING (column L). So I want to
nest the if statements for the AGE column (M).

DOS Age
132 91>
97 91>
84 61-90
83 61-90
83 61-90
83 61-90
83 61-90
53 31-60

 

[art]

You did very well, just you have to nest it like this:

=IF(L2<30,"0-30",IF(AND(L2>=31,L2<=60),"31-60",IF(AND(L2>=61,L2<=90),"61-90",IF(L2>91,"91>","")

Let me know if it works.

Good Luck.

 

[Donnie]

Thanks Art and Sheeloo. Both of you solved my issue.