IF, AND with FIND formula

[Jeffreyxx01]

Hi guys,

Do anyone know how to nest my formula to add another option using AND/OR in my FIND formula,

=IF(ISNUMBER(SEARCH("Junior",N2)),"Junior","Adult")

This is what I have but I wanna add another criterion: "On campus" and if this is correct it will give me "Junior"

Thanks for your help

 

[KB_Miner]

You can nest multiple IF statements. Try this:

=IF(ISNUMBER(SEARCH("Junior",N2)),"Junior",IF(ISNUMBER(SEARCH("On campus",N2)),"Junior", "Adult"))

 

[Jeffreyxx01]

I actually forgot this possibility,

Thanks for the support, I could have think of it earlier

 

[Joe4]

Or just use the OR function, so you do not have to nest (which is a little shorter too), i.e.

=IF(OR(ISNUMBER(SEARCH("Junior",N2)),ISNUMBER(SEARCH("On campus",N2))),"Junior","Adult")