SheetFX
≡
<< Go back to all functions

CONVERT

The CONVERT function in Google Sheets is a powerful tool that allows you to convert a numeric value from one unit of measure to another. Whether you're converting lengths, weights, temperatures, or any other units, the CONVERT function simplifies the task. Read on to learn how to use this function effectively.

Function Syntax and Parameters

Syntax: CONVERT(value, start_unit, end_unit)

Parameters:

  • value: The numeric value that you want to convert.
  • start_unit: The unit of measure that the value is currently in.
  • end_unit: The unit of measure that you want to convert the value to.

Step-by-Step Tutorial

  1. Converting a value from one unit to another:
    • Example: =CONVERT(10, "m", "ft")
    • Result: The value 10 meters will be converted to feet.

Use Cases and Scenarios

  1. Metric to Imperial Conversion: Convert metric measurements (meters, kilograms) to imperial units (feet, pounds).
  2. Temperature Conversion: Convert temperatures from Fahrenheit to Celsius or vice versa.
  3. Currency Conversion: Convert currency values from one currency to another.

Related Functions

  • UNITCONVERT: A more powerful function for unit conversion which allows you to specify unit conversion factors.

Related Articles