Nested OR function within and AND logical statement
I am trying to have the following into a single logic statement:
Nucleotide Category is "Labeled" AND Characterization Status is "Characterized"
AND QC Status is either "Pending" OR "Incomplete"
=IF(AND(Nucleotide Category]@row = "labeled", [Characterization Status]@row="Characterized", (OR([QC Status]@row="Pending",[QC Status]@row="Incomplete")),"True","False"))
The above formula is unparseable. I think I am close and have overlooked a bracket somewhere..
Help Article Resources
Check out the Formula Handbook template!