Help

Re: Shipping charge calculation formula

Solved
Jump to Solution
1696 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

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
JonathanBowen
13 - Mars
13 - Mars

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
JonathanBowen
13 - Mars
13 - Mars

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

Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

@JonathanBowen Thank you very very much, you made my day. this worked. Appreciated :thumbs_up: :thumbs_up: