Skip to main content

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!


Hey Rey. Here is a screenshot!


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


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


You are the man, REY!