Google Sheets-Funktion

CONVERT

Converts a number from one measurement system to another.

Formel mit KI erstellen Dieselbe Funktion in Excel

Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.

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.

Argumente

numbererforderlichThe numeric value in from_unit that you want to convert.
from_uniterforderlichThe unit for the number.
to_uniterforderlichThe unit for the result.

Beispiele

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

Ergebnis: 32.80839895

Converts 10 meters into feet.

FAQ

Are unit abbreviations case-sensitive?

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

CONVERT

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen

CONVERT

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen