Can't get IF formula to work,

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

Find more posts tagged with

Accepted answers

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

All comments

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

Fantastic works like a charm :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.