Help

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

Help with formulas (log10?)

Topic Labels: Formulas
285 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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.