Help with formulas (log10?)

[Aqueduct_Projec]

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.

[kuovonne]

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.