Help with a checkbox triggering a formula

JPavlasek

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], "")

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

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!