Adding x IF Yes/No box is checked

[Zack_Crilley]

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!!

[Rey_Crisostomo]

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

[Zack_Crilley]

Hey Rey. Here is a screenshot!

[Rey_Crisostomo · Accepted solution]

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

[Zack_Crilley]

You are the man, REY!