Help

Adding x IF Yes/No box is checked

Topic Labels: Formulas
Solved
Jump to Solution
623 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Zack_Crilley
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions

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

See Solution in Thread

4 Replies 4
Rey_Crisostomo
6 - Interface Innovator
6 - Interface Innovator

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

Zack_Crilley
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey Rey. Here is a screenshot!

Airtable

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

You are the man, REY!