Difference between revisions of "Manuals/calci/LOG"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =LOG( | + | <div style="font-size:30px">'''LOG (Number,Base)'''</div><br/> |
| − | * | + | *<math>Number</math> is a positive real number and |
| − | *<math> | + | *<math>Base</math> is the base of the logarithm. |
| − | + | **LOG(), returns the logarithm of a number to a specified base. | |
| − | LOG() | ||
== Description == | == Description == | ||
| − | LOG( | + | LOG(Number,Base) |
For Example, | For Example, | ||
| Line 18: | Line 17: | ||
LOG(4, 0.5) ''returns -2'' | LOG(4, 0.5) ''returns -2'' | ||
| − | *The | + | *The <math>Number</math> should be a positive real number. Else Calci displays NaN error message. |
| − | *The <math> | + | *The <math>Base</math> should be a positive real number. Else Calci displays NaN error message. |
| − | *If the <math> | + | *If the <math>Base</math> is omitted, Calci assumes it to be 10. |
*LOG() can be used in an equation as - | *LOG() can be used in an equation as - | ||
LOG(LOG(10,2),3) + LOG(10,2) ''returns 4.414711580210549'' | LOG(LOG(10,2),3) + LOG(10,2) ''returns 4.414711580210549'' | ||
Latest revision as of 16:29, 17 August 2018
LOG (Number,Base)
- is a positive real number and
- is the base of the logarithm.
- LOG(), returns the logarithm of a number to a specified base.
is a positive real number and
is the base of the logarithm.
Description
LOG(Number,Base)
For Example,
LOG(10, 2) returns 3.3219280948873626
LOG(100,10) returns 2
LOG(4, 0.5) returns -2
- The should be a positive real number. Else Calci displays NaN error message.
- The should be a positive real number. Else Calci displays NaN error message.
- If the 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 -
| n | 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 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.
Related Videos
See Also
References