0

Is there a way to have multiple conditions using some sort of "or" so that I don't have to nest so many if statements?

I currently have cells like this:

=IF(E2 = "District1","North",IF(E2 = "District2","North",IF(E2 = "District3","North",IF(E2 = "District4","North","Not North"))))

I have tried using OR in two ways and neither work.

=IF(E2 = "District1" OR E2 = "District2" OR E2 = "District3" OR E2 = "District4","North","Not North")

=IF(E2 = "District1" OR "District2" OR "District3" OR "District4","North","Not North")

Is there some kind of "or" conditional or do I have to keep with my long winded nested ifs?

EDIT: It turns out I have too many nested If statements for Excel to handle. It seems Excel only accepts 8 nested IF statements (despite the help saying that I can have up to 64).

Edited by Borzoi: Adding more information.

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by Borzoi
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.