Weight ====== Cost
If weight = 0.5 Kg. then cost is $50
for each additional 0.5 cost is $45,
Weight has 0.5 Kg slab, i.e. 0.60 comes in 1Kg. slab.
How to create formula to calculate per slab charge in Airtable ?
Solved
Shipping charge calculation formula
Best answer by JonathanBowen
Hi @Manish_Patell - I think I understand what you mean. How about this:
Slabs is:
ROUNDUP(Weight/0.5, 0)
and Shipping is:
50 + ((ROUNDUP(Weight/0.5, 0) - 1) * 45)
(You don’t need Slabs, tbh, this was just for understanding)
JB
+18Hi @Manish_Patell - I think I understand what you mean. How about this:
Slabs is:
ROUNDUP(Weight/0.5, 0)
and Shipping is:
50 + ((ROUNDUP(Weight/0.5, 0) - 1) * 45)
(You don’t need Slabs, tbh, this was just for understanding)
JB
@JonathanBowen Thank you very very much, you made my day. this worked. Appreciated :thumbs_up: :thumbs_up:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.