Nested IF Statement Help

  • Thread starter Thread starter Donnie
  • Start date Start date
D

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
 
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
 
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
 
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.
 
Back
Top