Forum Discussion

Copper Contributor

Jan 16, 2018

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

Formulas & Functions

Requests

SergeiBaklan

Diamond Contributor

Jan 16, 2018

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+")))))))))

Mark Gordon
Copper Contributor
Mar 25, 2018
Is there a way to have nested IF AND and NOT formulas? If so where can I read it? Thank you. ML Gordon
- SergeiBaklan
  Diamond Contributor
  Mar 26, 2018
  Mark, that is different topic, better if you start new conversation with it. As for the question I didn't catch what do you mean, within nested IF could be combination of any functions https://support.office.com/en-us/article/use-nested-functions-in-a-formula-9d7c966d-6030-4cd6-a052-478d7d844166
Paul Marsh
Copper Contributor
Jan 16, 2018
Thanks Sergei, all sorted!