IF with nested OR and AND
I'm struggling with this formula and getting and incorrect argument error.
I'm wanting my priority column to give me the correct drop down ("Half") if either or both of my conditions or met. Here's what I have.
=IF(OR(AND([Micro or QC?]@row = "Micro", AND([Micro or QC?]@row = "QC"), "Half")))
I can get the formula to work with the OR statement, but I cannot get it to work if I try to add AND.
What am I missing here?
Help Article Resources
Check out the Formula Handbook template!