The CONVERT function in Excel is used to convert a value from one measurement unit to another. It’s a handy tool for converting various types of units, such as length, volume, temperature, and more, directly in your Excel worksheet.

## Syntax

**CONVERT(number, from_unit, to_unit)**

## Arguments

number | The value you want to convert. |

from_unit | The current unit of measurement for the value. |

to_unit | The unit of measurement to which you want to convert the value. |

## How to use

To use the CONVERT function, follow this simple syntax:

1 |
=CONVERT(number, from_unit, to_unit) |

Here’s a practical example: let’s say you have a length in inches (from_unit) and you want to convert it to centimeters (to_unit). The formula would look like this:

1 |
=CONVERT(A1, "in", "cm") |

This will convert the value in cell A1 from inches to centimeters.

Optional: If you have a measurement that might be optional (for example, if you don’t always have a “from_unit”), you can enclose it in square brackets and specify that it’s optional in the explanation.

Now, let’s see a few examples of how you can use the CONVERT function:

1 2 3 |
=CONVERT(100, "mi", "km") ' Converts 100 miles to kilometers =CONVERT(32, "°F", "°C") ' Converts 32 degrees Fahrenheit to degrees Celsius =CONVERT(500, "gal", "L") ' Converts 500 gallons to liters |

These examples demonstrate how you can convert different units using the CONVERT function.

## Additional Information

If you encounter unfamiliar units or terms, you can refer to external resources or websites for definitions and explanations.