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.
- LOG() can be used in an equation as -
LOG(LOG(10,2),3) + LOG(10,2) returns 4.414711580210549
- 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,B2) : Calculates the logarithm of 10 with base 10. Returns 1 as a result. =LOG(A4:A5,B1) : Calculates the logarithm of values in the range A4 to A5 (120, 700) with base B1 (2). Returns 6.906890595608519, 9.451211111832329 as a result. =LOG(A4) : Calculates the logarithm of 120. Here base is assumed to be 10. Returns 2.0791812460476246 as a result. =LOG(100,B3) : Calculates the logarithm of 100 with base 7.5. Returns 2.2855542619359994 as a result.