Forum Discussion
Nestled IF functions
Hi all, first time poster so apologies if there is something I should have done first!
I have a list of approx 5500 people and their ages and I am trying to get excel to assign them age bracket...
Hi Paul,
With nested it's like
=IF(B2<20,"17-19",IF(B2<25,"20-24",IF(B2<30,"25-29",IF(B2<35,"30-34",IF(B2<40,"35-39",IF(B2<45,"40-44",IF(B2<50,"45-49",IF(B2<55,"50-54",IF(B2<60,55-59,"60+")))))))))
Thanks Sergei, all sorted!