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.
+29Excel’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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.