Forum Discussion
Solved
if/Or statement
Hello I needed help with a formula that would populate either "outbreak" or "not an outbreak" based on a few conditions. so if column p says CDSS and the number in column q is higher than 5 than column will populate ethe word "outbreak" OR if column p says CDPH and the number in column q is higher than 1 that column b will populate the word outbreak. if none of those criteria are met, then "Not an outbreak" will populate.
=IF(OR(AND(P3="CDSS",Q3>5),AND(P3="CDPH",Q3>1)),"outbreak","not an outbreak")You can try this formula.
=IF(OR(AND(P3="CDSS",Q3>5),AND(P3="CDPH",Q3>1)),"outbreak","not an outbreak")You can try this formula.
- This worked! thank you!
Re-reading your post, I suppose I need to edit it for both conditions. And to make it slightly different from the other answer at time of writing:
=IF((P3="CDSS")*(Q5>5)+(P3="CDPH")*(Q5>1),"Outbreak", "Not an outbreak")
