Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 25, 2021 09:40 AM
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.
Jan 25, 2021 02:25 PM
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.