Help

Help with formulas (log10?)

Topic Labels: Formulas
1087 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Aqueduct_Projec
4 - Data Explorer
4 - Data Explorer

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.