Google Sheets-funktion

CONVERT

Converts a number from one measurement system to another.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

numberobligatorisktThe numeric value in from_unit that you want to convert.
from_unitobligatorisktThe unit for the number.
to_unitobligatorisktThe unit for the result.

Exempel

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

Resultat: 32.80839895

Converts 10 meters into feet.

Vanliga frågor

Are unit abbreviations case-sensitive?

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

Relaterade funktioner

ROUND ABS