Help

Trying To Get Formula to Add Percentage

Topic Labels: Formulas
Solved
Jump to Solution
126 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

See Solution in Thread

2 Replies 2

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

Thank you that fixed it!

Labels