How do I work with Euler's number in Excel?

1 Answer
Jul 3, 2018

Please see below.

Explanation:

Excel has an exponential function and a natural log function.

The function is =EXP(value) and it gives the result of e^(value) (this is called syntax). For example, to find the value of e, we can write =EXP(1). Further if we put a number x in A1 and in A2 we put the formula =EXP(A1^2-1), this gives us e^(x^2-1).

In other words, whatever is in the exponent goes in the parentheses.

Similarly the syntax for natural log in Excel is =LN(value).

In other words if we put a number x in A1 and in A2 we put the formula =LN(A1^2-1), this gives us ln(x^2-1).