Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

# Trying To Get Formula to Add Percentage

Topic Labels: Formulas
Solved
174 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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

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

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

5 - Automation Enthusiast

Thank you that fixed it!