I see there is a log formula but I have some formulas using the natural log and that doesn't appear to be an option ive got even though I do have it in excel. Maybe I'm not looking the in the right place.
Im wondering if there is a way that I can express LN() in airtable.
You can add a second parameter to the LOG() function to specify the base, as documented in the Formula Field Reference. You cannot put "e" as the second parameter, but you can put in an approximation with lots of decimal places.
If you need something more precise, you can resort to an automation with a scripting action and use JavaScript.
Hi, I'm sorry, but EXP(1) is exactly e and it can be used as second parameter. Funny, I always though Airtable has only LOG with base 10, and I just knew it has a second parameter.
