"IF" Checkbox function question.

I have several checkboxes in my SS. I would like each check box to represent a cost to be added to a "total cost" field. (i.e. if Checkbox 1 is checked, add $2,750, If Checkbox 2 is checked, add $3,750, etc.).

Can someone tell me how to accomplish this?

Thank you!

Find more posts tagged with

Accepted answers

All comments

There's option one, which is baking in the values of the checkboxes into the formula itself:

Formula: =Subtotal@row + SUM(IF(Tax@row = 1, 2750), IF([S&H]@row = 1, 3750), IF([Rush Charge]@row = 1, 5000))

You could also treat the $ amounts as variables, and create them as fields in the Sheet Summary pane.

That formula looks like this: =Subtotal@row + SUM(IF(Tax@row = 1, Tax#), IF([S&H]@row = 1, [S&H]#), IF([Rush Charge]@row = 1, [Rush Charge]#))

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.