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!!
Solved
Adding x IF Yes/No box is checked
Best answer by Rey_Crisostomo
Hey Rey. Here is a screenshot!
Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)
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)
Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)
You are the man, REY!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.