Applies ToSharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint in Microsoft 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint in Microsoft 365 Small Business Windows SharePoint Services 3.0

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

Syntax

LN(number)

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

Remark

LN is the inverse of the EXP function.

Examples

Formula

Description (Result)

=LN(86)

Natural logarithm of 86 (4.454347)

=LN(2.7182818)

Natural logarithm of the value of the constant e (1)

=LN(EXP(3))

Natural logarithm of e raised to the power of 3 (3)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.