The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Shipping charge calculation formula

posted May 27, 2019 9:12:13 PM

Topic Labels: Formulas

Solved

Jump to Solution

0 3114 2

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 ?

1 Solution

Accepted Solutions

Solved

Hi @Manish_Patell - I think I understand what you mean. How about this:

Screenshot 2019-05-28 at 15.27.06.png

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

See Solution in Thread

2 Replies 2

Solved

Hi @Manish_Patell - I think I understand what you mean. How about this:

Screenshot 2019-05-28 at 15.27.06.png

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: