Google Sheets-functie

CONVERT

Converts a number from one measurement system to another.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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.

Argumenten

numbervereistThe numeric value in from_unit that you want to convert.
from_unitvereistThe unit for the number.
to_unitvereistThe unit for the result.

Voorbeelden

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

Resultaat: 32.80839895

Converts 10 meters into feet.

Veelgestelde vragen

Are unit abbreviations case-sensitive?

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

Gerelateerde functies

ROUND ABS