Help with formulas (log10?)

Hi guys im trying to utilize a formula from excel to calculate a score based off of two different fields but I cant seem to get it working.

here is the formula
=Total*(10^(0.751945030*((LOG10(Weightclass/175.508))^2)))

Total and Weightclass are two of my fields and are set to integer inputs.

any help is greatly appreciated.

Excel’s syntax for exponents and logs are different from Airtable’s.

For exponents, Airtable does not recognize ^ as an operator. You need to use the POWER() function. (Not the EXP() function.)

For log, you will need to use the LOG() function.

These functions are documented in the formula field reference.

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