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.
=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!
