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

Thanks

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.