# CONVERT Function – Google Sheets

## CONVERT Function Summary

### Function Type: Parser

The CONVERT function returns a converted numerical value for a specified unit.

## CONVERT Function Purpose

Convert a numerical value from one unit of measure to another. Both units of measure need to be in the same category. There are 13 different categories.

• Weight
• Distance
• Time
• Pressure
• Force
• Energy
• Power
• Magnetism
• Temperature
• Volume
• Area
• Information
• Speed

## CONVERT Syntax

``=CONVERT(value, start_unit, end_unit)``
• Function Name.
• value- [Required] The numerical value to be converted to a different unit.
• start_unit- [Required] The initial unit of measurement.
• end_unit- [Required] The unit of measurement you will convert your value to.

### Sample of the CONVERT Function

• `=CONVERT(A1,"ft","in")`
• `=CONVERT(32,"F","C")`
• `=CONVERT(A1,"yr","day")`

## CONVERT Practice Sheet

Copy our practice sheet below to see all of the available CONVERT variables you can utilize. We have created a simple dynamic dropdown menu so you can easily select the category, start unit, and end unit. We will utilize the CONVERT function to convert the provided value, but also provide the formula used to convert your unit. Now, you can easily see the proper variables being used.

## CONVERT Variables

### Relate Functions

• `DATE`: Converts a year, month, and day into a date.
• `DATEVALUE`: Converts a provided date string in a known format to a date value.
• `TIME`: Converts an hour, minute, and second into a time.
• `TIMEVALUE`: Returns the fraction of a 24-hour day the time represents.