Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Adding x IF Yes/No box is checked

Topic Labels: Formulas
Solved
Jump to Solution
509 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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!

Airtable

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

You are the man, REY!