Nested IF statements

Can anyone assist me in where I am going wrong?

=IF([GEAR.]@row = true, [C/N SQD]@row, IF(LTG@row = true, [C/N LIGHTING]@row), IF(AND([GEAR.]@row = true, LTG@row = true) = true, [PROJECT TOTAL]@row))

If checkbox1 = true, set value to cell 1, if checkbox2 = true, set value to cell2, if BOTH checkboxes = true, set value to cell 3 (I would like to sum two cells together, but I just made another column that does the summing for me ahead of time.

Find more posts tagged with

Formulas

Accepted answers

Jason Tarpinian

You will have to check your IF(AND( statement first. The way you have it currently, if both boxes are checked, the logic would stop at the first statement because box 1 is checked, and not even check the logic on box 2. So you almost have it, just shift the IF(AND( combo as the first step in the logic:

=IF(AND([GEAR.]@row = true, LTG@row = true), [PROJECT TOTAL]@row, IF([GEAR.]@row = true, [C/N SQD]@row, IF(LTG@row = true, [C/N LIGHTING]@row, "No Match")))

Where "No Match" would be the result if nothing is checked.

All comments

Jason Tarpinian

=IF(AND([GEAR.]@row = true, LTG@row = true), [PROJECT TOTAL]@row, IF([GEAR.]@row = true, [C/N SQD]@row, IF(LTG@row = true, [C/N LIGHTING]@row, "No Match")))

Where "No Match" would be the result if nothing is checked.

Travis Myers

That makes sense. I didn't think about it logically enough. That did the trick though!

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.