Automated Check box when a sum of cells is greater than another cell

I am trying to create a formula that checks the box if two cells are equal to one other cell. Getting so frustrated, please help! 🙏 This is the formula I have that is not working for me:

=IF(AND(TotalA@row, TotalR@row = TotalM@row, 1, 0))

What am I doing wrong?

Find more posts tagged with

Accepted answers

Nic Larsen

Try this:

=IF(SUM(TotalA@row, TotalR@row) = TotalM@row, 1, 0)

All comments

SSFeatures

Hi Cheri, please try the following formula:

=IF(AND([Column2]@row = [Column4]@row, [Column3]@row = [Column4]@row), 1, 0)

I also noticed that in your formula one of your ")" is in the wrong location.

Before:

=IF(AND(TotalA@row, TotalR@row = TotalM@row, 1, 0))

After:

=IF(AND(TotalA@row, TotalR@row = TotalM@row), 1, 0)

Hope this helps!

Nic Larsen

Try this:

=IF(SUM(TotalA@row, TotalR@row) = TotalM@row, 1, 0)

Cheri J

Thank you so much @Nic Larsen !! That worked!!! 😊 I just spent soooooo much time on that. You're a lifesaver.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.