IF function not returning values correctly (what did I miss)

[Dan_B]

Hi Everyone

For some reason I can't figure out why this formula is still returning the wrong value

=IF(N2<18,"0-17",IF(AND(N2>=18,N2<=34),"18-34",IF(AND(N2>=35,N2<=50),"35-50",IF(N2>50,"50+",IF(N2="NULL", "No Age Given", "-"))))

I tried moving the final false criteria to the out parenthesis but I still get the wrong results i.e. if column N2 = NULL O2 = 50+

I'm sure it's a quick one but I've been looking at measures and formula for a while now and I've gone brain neutral

Thanks for your help

Daniel

[Special-K]

Test for NULL first of all, then check the number ranges.

Alternatively replace the formula with this

=IF(N2="NULL","No Age Given",LOOKUP(N2,{0,18,35,51},{"0-17","18-34","35-50","51+"}))