# Trying To Get Formula to Add Percentage

Topic Labels: Formulas
Solved
1430 2
cancel
Showing results for
Did you mean:
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
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})`

2 Replies 2
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})`

6 - Interface Innovator

Thank you that fixed it!