Help

Trying To Get Formula to Add Percentage

Topic Labels: Formulas
Solved
Jump to Solution
1417 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Smyth_County
6 - Interface Innovator
6 - Interface Innovator

I know this is simple but I’m struggling for some reason. {Average Weight}/2000 * {Base Rate} + {Surcharge Calc} It adds the ‘Surcharge Calc’ which is a percentage just as a number.

What I’m trying to accomplish: Average Weight = 10000, Base Rate = 15, Surchage Calc = 20%
10000/2000 X 15 + 20% = 90
I’m getting 75.20

Thanks

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Yeah…percentages are sort of just treated as decimals on Airtable, so to achieve what you’re looking for you’d probably need to do something like the following I’m afraid

({Average Weight}/2000 * {Base Rate}) * (1 + {Surcharge Calc})

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Yeah…percentages are sort of just treated as decimals on Airtable, so to achieve what you’re looking for you’d probably need to do something like the following I’m afraid

({Average Weight}/2000 * {Base Rate}) * (1 + {Surcharge Calc})

Thank you that fixed it!