IF / OR Formula issue
I have a ticket tracker that I need and IF, OR formula to determine if either field has a Yes.
My formula works, but will only show Yes if BOTH of the other fields are Yes. I need it to say Yes if either of them are Yes.
=IF(OR([Started MRR less than $500?]@row = "Yes", [MRR Change less than $300?]@row = "Yes"), "Yes", "No")
Can someone help me?
Best Answer
-
Hi @Meghan Davis
Hope you are fine, please try the following formula:
=IF(OR([Started MRR less than $500?]@row = "Yes",[MRR Change less than $300?]@row = "Yes"), "Yes", "No")
the following screenshot shows the result:
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Meghan Davis
Hope you are fine, please try the following formula:
=IF(OR([Started MRR less than $500?]@row = "Yes",[MRR Change less than $300?]@row = "Yes"), "Yes", "No")
the following screenshot shows the result:
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you for your help.
-
You are welcome and i will be happy to help you any time.
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Check out the Formula Handbook template!