IF, AND formula for checkbox

Sophie Knudson

Hello,

I'm trying to make a formula for a checkbox column where if the column titled "Expected result" is positive, but the "Results" column is negative, then the checkbox will be filled (and vice versa if expected is negative and result is positive). However, I cannot say if the expected result column and results column don't equal each other to check the box, because there are other rows in the sheet that I don't want checked and aren't equal.

I tried this formula, but got an #unparseable error. Any suggestions for improvement?

=if([Expected result]@row = "+" AND([Results]@row = "+"), 0, IF([Expected result]@row = "-" AND([Results]@row = "-"), 0, IF([Expected result]@row = "+" AND([Expected result]@row = "-"), 1, IF([Expected result]@row = "-" AND([Results]@row = "+"), 1))))

Paul Newcome

Try something like this...

=IF(OR(AND([Expected Result]@row = "-", Result@row = "+"), AND([Expected Result]@row = "+", Result@row = "-")), 1)

Paul Newcome

Try something like this...

=IF(OR(AND([Expected Result]@row = "-", Result@row = "+"), AND([Expected Result]@row = "+", Result@row = "-")), 1)

Sophie Knudson

Ah that was brilliant. It works perfectly. Thank you!

Paul Newcome

Happy to help. 👍️