writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 19:
Line 19: + + + Line 71:
Line 74: − + − + − + − +
no edit summary
*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.
|}
|}
=LOG(A1,B1) : Calculates
=LOG(A1,B2) : Calculates the logarithm of 10 with base 10. Returns ''1'' as a result.
=LOG(A1:A5,B2) : Calculates
=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 ==