Hello! I am working on an IF statement with some AND and OR functions nested inside. I keep getting the generic notification that there is an error in my formula, but I can't seem to find it anywhere.
IF(OR(AND(K25="$15k-$50k",OR(M25="Location 1",M25="Location 2”)),AND(K25="$15k-$50k",O25="<1 week”, OR(M25="Location 3",M25="Location 4”)),"Option 1",0)
What I'm trying to achieve is:
Print "Option 1" IF:
Either:
K25 = "$15k-$50k" AND M25 is either "Location 1" OR "Location 2"
OR
K25 = "$15k-$50k" AND O25="<1 week” AND M25 is either "Location 3" OR "Location 4"
Bookmarks