Función de Google Sheets

CONVERT

Converts a number from one measurement system to another.

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

CONVERT(number, from_unit, to_unit)

The CONVERT function allows you to translate values between different units of measurement, such as weight, distance, time, pressure, or temperature. It is highly useful for standardizing data sets that contain mixed units.

Argumentos

numberobligatorioThe numeric value in from_unit that you want to convert.
from_unitobligatorioThe unit for the number.
to_unitobligatorioThe unit for the result.

Ejemplos

=CONVERT(10, "m", "ft")

Resultado: 32.80839895

Converts 10 meters into feet.

Preguntas frecuentes

Are unit abbreviations case-sensitive?

Yes, unit abbreviations are case-sensitive; for example, 'm' represents meters while 'M' represents miles.

Funciones relacionadas

ROUND ABS