Adding x IF Yes/No box is checked

Hello! I am having trouble creating a formula to calculate my service fee.

Our fee is 10% of the order total (min fee $10, max $25.) We charge and extra $20 IF the order is for delivery.

Please Help!!

Please give the column names and type that are available in the table where you want the formula column to added.

Hey Rey. Here is a screenshot!

Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)

1 Like

You are the man, REY!

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