Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error.
It's important to note that both columns are numbers.
My original formula was:
=IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0)
However, this would not result in a checked box when one cell had an error.
So now my current formula is:
=IFERROR(IF(OR([COLUMN A]@row <> [COLUMN B]@row ), 1, 0), 1)
It seemingly works in all cases with one quirky exception.
When COLUMN A is blank and COLUMN B has "0", the checkbox is unchecked.
It's as if the formula is viewing a blank cell and a cell with "0" as equal.
