Member Avatar for Borzoi

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 because: Adding more information.
  • 2 Contributors
  • 2 Replies
  • 109 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Borzoi
Member Avatar for Borzoi

Ah yes, thank you. That has solved the problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.