Can't get IF formula to work,

AllanH

I have two columns with numbers, and one column with at checkbox, I want to use IF to automatically check the box if the cell in column 2 I bigger than the cell in column 1.

This is my formula in the the checkbox column

=IF([Column 2]@row<[Column 1]@row) 1, 0

But I keep getting the Unparseable message

Nic Larsen

=IF([Column 2]@row > [Column 1]@row, 1, 0)

Nic Larsen

=IF([Column 2]@row > [Column 1]@row, 1, 0)

AllanH

Fantastic works like a charm :)