Difference between revisions of "Manuals/calci/LOG"
Jump to navigation
Jump to search
| Line 19: | Line 19: | ||
*The base 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. | *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. | *The function can be used to find the logarithm of array of numbers with a specified base. | ||
| Line 71: | Line 74: | ||
|} | |} | ||
| − | =LOG(A1, | + | =LOG(A1,B2) : Calculates the logarithm of 10 with base 10. Returns ''1'' as a result. |
| − | =LOG( | + | =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 | + | =LOG(A4) : Calculates the logarithm of 120. Here base is assumed to be 10. Returns ''2.0791812460476246'' as a result. |
| − | =LOG(100,B3) : Calculates | + | =LOG(100,B3) : Calculates the logarithm of 100 with base 7.5. Returns ''2.2855542619359994'' as a result. |
== See Also == | == See Also == | ||
Revision as of 18:49, 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.
- 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.