Manuals/calci/LOG

Revision as of 16:38, 5 December 2013 by Swapna (talk | contribs) (→‎Examples)

LOG(n, base)

  • Where 'n' is a positive real number and
  • 'base' is the base of the logarithm.

LOG() determines the logarithm of a number to a specified base.

Description

LOG(n, base)

For Example,

LOG(10, 2) returns 3.3219280948873626

LOG(100,10) returns 2

  • The number should be a positive real number. Else Calci displays NaN error message.
  • The base should be a positive real number. Else Calci displays NaN error message.
  • If the base is omitted, Calci assumes it to be 10.
  • The function can be used to find the logarithm of array of numbers with a specified base.

e.g. LOG(10..15, 2) that displays the output as below -

number base LOG Output
10 2 3.3219280948873626
11 2 3.4594316186372977
12 2 3.5849625007211565
13 2 3.700439718141092
14 2 3.8073549220576037
15 2 3.9068905956085187

Examples

10 2
50 10
7.5 7.5
120
700
=LOG(A1,B1)  : Calculates
=LOG(A1:A5,B2)  : Calculates
=LOG(A4)  : Calculates
=LOG(100,B3)  : Calculates

See Also

References