Help with a checkbox triggering a formula

I have an order form that I'm creating. I have these three fields here in question.

Item 1 (Checkbox)
Item 1 Qty (Number Amount)
Item 1 Price (Formulated box that when Item 1 is checked and they put 2 in the Qty, it multiplies it by the price of the item)

I have written this formula and came up empty. Tried a few different things and STILL coming up empty. Help?

=IF([Item 1]@row = 1, [Item 1 Qty]@row * [10.40], "")

Find more posts tagged with

Accepted answers

JR90

Hey man,

Try this formula:

=IF([ITEM 1]@row = 1, IF(NOT(ISBLANK([ITEM 1 QTY]@row)), [ITEM 1 QTY]@row * 10.4))

This will work only if the check box is checked and there is a quantity in the "Item 1 Qty" cell.

Let me know if it works!

Thanks,

JRR

All comments

JR90

Hey man,

Try this formula:

=IF([ITEM 1]@row = 1, IF(NOT(ISBLANK([ITEM 1 QTY]@row)), [ITEM 1 QTY]@row * 10.4))

This will work only if the check box is checked and there is a quantity in the "Item 1 Qty" cell.

Let me know if it works!

Thanks,

JRR

JPavlasek

IT WORKED! Thank you so much!

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.