If, then formula for percentage calculation

[Smyth_County]

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

[TheTimeSavingCo · Accepted solution]

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

[Smyth_County]

Thank you that fixed it!