If Nesting formula with checkboxes

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.

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.