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

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.

No credit card required