CONVERTformula is used to convert a value from one unit of measurement to another. This formula is most commonly used to convert metric units to imperial units or vice versa.
- How to use
- Examples of using
CONVERTformula not working?
- Similar formulas to
CONVERT formula with the syntax shown below, it has 3 required parameters:
- value (required):
The value to be converted.
- start_unit (required):
The starting unit of measurement.
- end_unit (required):
The unit of measurement to convert to.
ExamplesHere are a few example use cases that explain how to use the
CONVERTformula in Google Sheets.
Converting temperature units
CONVERT formula to convert temperatures from Fahrenheit to Celsius or vice versa.
Converting distance units
CONVERT formula to convert distances from miles to kilometers or vice versa.
Converting weight units
CONVERT formula to convert weights from pounds to kilograms or vice versa.
CONVERTnot working? Here are some common mistakes people make when using the
CONVERTGoogle Sheets Formula:
Incorrect unit abbreviation
One of the unit abbreviations provided is incorrect or misspelled. Double-check the list of supported units and ensure the correct abbreviation is used.
Incorrect input type
The value being converted is not a number or contains characters that cannot be converted. Ensure the value is a number or correct any non-numeric characters.
Invalid combination of units
The combination of start_unit and end_unit is not valid for this conversion. Refer to the list of supported units and ensure the combination is valid.
The syntax used to write the formula is incorrect, ensure the formula follows the correct syntax: CONVERT(value, start_unit, end_unit).
The unit provided is not supported by the CONVERT formula. Refer to the list of supported units and ensure the correct unit is used.
The following functions are similar to
CONVERT or are often used with it in a formula:
You can learn more about the
CONVERT Google Sheets function on Google Support.