CODEWITHSUNDEEP
excelexcel-formula
Elakkiya Lucky
Elakkiya Lucky

Reputation: 168

How LN() function works in Excel?

When do I calculate LN(E2:E4) in excel, it returns #VALUE! Error.

If I calculate the same formula as embedded formula like INTERCEPT(LN(L1:L2),LN(M1:M2)) it returns -21.3071 and also if i use SUM function SUM(LN(L1:L2),LN(M1:M2)) it returns #VALUE! Error .

Please anyone share your opinion when LN formula returns #VALUE! Error. Also, whether INTERCEPT formula only returns value or else is there any other excel formula in which LN returns value?

Upvotes: 1

Views: 1231

Answers (1)

teylyn
teylyn

Reputation: 35915

Maybe you want to read the help for the LN function, found here.

Syntax

LN(number)

The LN function syntax has the following arguments:

Number Required. The positive real number for which you want the natural logarithm.

You seem to be passing a range, not a number.

Upvotes: 1

Related Questions