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