O'Reilly logo

Excel Scientific and Engineering Cookbook by David M Bourg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7.4. Exploring Exponential and Logarithmic Functions

Problem

You need to compute logarithms in your calculations but aren't familiar with Excel's support for such calculations.

Solution

Excel provides nine built-in functions for computing logarithms and one exponential function (excluding the special class of exponential functions known as hyperbolic functions, for which Excel provides six built-in functions). A few of these logarithm functions are related to the log-normal probability distribution, while others are related to complex numbers. See Chapter 6 for recipes dealing with probability and check out Recipe 7.13 for dealing with complex numbers. Read the following discussion to learn about the remaining logarithmic functions .

Discussion

Table 7-4 shows several of Excel's built-in logarithmic and exponential functions.

Table 7-4. Common logarithmic and exponential functions

Function

Syntax

Description

LOG

=LOG( n , base )

Returns the log of the number n to the specified base

LOG10

=LOG10( n )

Returns the log of the number n to the base 10

LN

=LN( n )

Returns the natural logarithm of n

EXP

=EXP( n )

Returns e n

POWER

=POWER( n , p )

Returns n p and is the same as the syntax n ^ p using the ^ operator

SINH

=SINH( n )

Returns (e n - e -n )/2

COSH

=COSH( n )

Returns (e n + e -n )/2

TANH

=TANH( n )

Returns (e n - e -n ) / (e n + e -n )

ASINH

=ASINH( n )

Returns the inverse hyperbolic sine, ln(n + sqrt( ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required