Trying To Get Formula to Add Percentage

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


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

1 Like

Thank you that fixed it!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.