Difference between revisions of "Manuals/calci/LOG"

From ZCubes Wiki
Jump to navigation Jump to search
Line 70: Line 70:
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|}
 
|}
 +
 +
=LOG(A1,B1)  : Calculates
 +
 +
=LOG(A1:A5,B2)  : Calculates
 +
 +
=LOG(A4)  : Calculates
 +
 +
=LOG(100,B3)  : Calculates
  
 
== See Also ==
 
== See Also ==

Revision as of 17:35, 5 December 2013

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