IF, AND formula for checkbox
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))))
Best Answer

Try something like this...
=IF(OR(AND([Expected Result]@row = "", Result@row = "+"), AND([Expected Result]@row = "+", Result@row = "")), 1)
Answers

Try something like this...
=IF(OR(AND([Expected Result]@row = "", Result@row = "+"), AND([Expected Result]@row = "+", Result@row = "")), 1)

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

Help Article Resources
Categories
Check out the Formula Handbook template!