Función de Google Sheets

LOG

Returns the logarithm of a number to a specified base.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

LOG(number, [base])

The LOG function calculates the logarithm of a positive number based on a provided base. If the base argument is omitted, Excel defaults to a base of 10.

Argumentos

numberobligatorioThe positive real number for which you want the logarithm.
baseopcionalThe base of the logarithm; if omitted, it defaults to 10.

Ejemplos

=LOG(100, 10)

Resultado: 2

Calculates the base-10 logarithm of 100, which is 2.

=LOG(8, 2)

Resultado: 3

Calculates the base-2 logarithm of 8, which is 3.

Preguntas frecuentes

What happens if the number is zero or negative?

The function will return a #NUM! error because logarithms are only defined for positive numbers.

Funciones relacionadas

LN LOG10 POWER