Help with formulas (log10?)

Topic Labels: Formulas
744 1
Showing results for 
Search instead for 
Did you mean: 
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 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.