Funzione di Google Sheets

CONVERT

Converts a number from one measurement system to another.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

numberobbligatorioThe numeric value in from_unit that you want to convert.
from_unitobbligatorioThe unit for the number.
to_unitobbligatorioThe unit for the result.

Esempi

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

Risultato: 32.80839895

Converts 10 meters into feet.

Domande frequenti

Are unit abbreviations case-sensitive?

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

Funzioni correlate

ROUND ABS