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 co...
=IF(OR(AND(P3="CDSS",Q3>5),AND(P3="CDPH",Q3>1)),"outbreak","not an outbreak")You can try this formula.
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")