How to use the Convert function on Excel

Convert function on Excel is used to convert measurement units, often used in value calculation data tables. To be able to calculate and quickly process Excel data tables, Excel functions are an effective tool for users. Each function has its own features to apply to Excel tables, such as the Convert function used to convert units of measurement in Excel.

This function belongs to the technical function, allowing users to switch between familiar measurement units such as g (gram), kg (kilogram), m (met), print (inch), day (day), hr (hours), mn (minutes), sec (seconds) . We just need to enter the formula in accordance with the format that the Convert function requires to convert. The following article will show you how to use the Convert function in Excel, for example changing from inch to cm.

1. Summary of expensive shortcuts in Microsoft Excel
2. How to combine 2 columns Full name in Excel does not lose content
3. How to combine Sumif and Vlookup functions in Excel

Instructions for using Convert function on Excel

Convert function on Excel has syntax = CONVERT (Number, From_Unit, To_Unit) . Inside:

1. Number: is the converted value
2. From_Unit: unit to convert
3. To_Unit: conversion unit

For example, I will proceed to convert units from inch to cm according to the data sheet as shown below.

How to use the Convert function on Excel Picture 1

In the cm input box, enter the formula = CONVERT (B5, "in", "cm") and press Enter.

How to use the Convert function on Excel Picture 2

Then you will get the result as shown below. The inch unit has been converted to cm using the Convert function.

How to use the Convert function on Excel Picture 3

How to use Convert functions convert extremely simple and easy to use Excel units of measurement. We can apply to different versions of Excel, with the same function formula.

I wish you all success!