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

Nested IF Statement Help
 

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(L291,"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" wrote:

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

Nested IF Statement Help
 

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


"Donnie" wrote:

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

Nested IF Statement Help
 

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

Let me know if it works.

Good Luck.



"Donnie" wrote:

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

Nested IF Statement Help
 

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

"art" wrote:

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

Let me know if it works.

Good Luck.



"Donnie" wrote:

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