Skip to main content

If Nesting formula with checkboxes

A

I have 2 check box fields and a cost field. If one checkbox is checked and the other is unchecked I want the amount in the estimated shipping cost field to go into the Unshipped Cost column(this is the formula for the Unshipped Column cost field)

I have
IF({We Ship}=1 and {Shipped}=0)={Est Ship Cost}

Thanks in advance.

2 replies

JonathanBowen
Forum|alt.badge.img+18

Hi @Alma_Barlow - you can do this:

IF(
  AND({We Ship}, NOT(Shipped)), 
  {Est Ship Cost}
)

Which translates to:

If We ship is true and Shipped is false, then return the Est Ship Cost

Note that there’s 3 other possible scenarios for the checkbox combos and with the above all of these will return null or empty, so you might want to expand the formula to return zero or other values for these cases

A
  • Alma_Barlow
  • Author
  • New Participant
  • 1 reply
  • March 10, 2021
JonathanBowen wrote:

Hi @Alma_Barlow - you can do this:

IF(
  AND({We Ship}, NOT(Shipped)), 
  {Est Ship Cost}
)

Which translates to:

If We ship is true and Shipped is false, then return the Est Ship Cost

Note that there’s 3 other possible scenarios for the checkbox combos and with the above all of these will return null or empty, so you might want to expand the formula to return zero or other values for these cases


Thanks works perfect.

Reply


Most helpful members this week

Terms & Conditions