Introducing how to use the CONVERT function in Excel in the most detail

When working in Excel, you may encounter a situation where your spreadsheet has many blank cells and need to fill in values ​​in those cells. Don't worry, read the article below which will introduce the convert function in Excel to learn how to quickly fill in values ​​into blank cells in Excel spreadsheets.

CONVERT function structure in Excel

The CONVERT function supports converting a number of measurement units such as weight, volume, distance, time, pressure, force, energy, power, magnetism, temperature, volume, area, information…

Function syntax: =CONVERT(number; from_unit; to_unit)

In there:

number : Required argument, is the value in from_units to convert.
from_unit : Required argument, which is the unit of number .
to_unit : Required argument, is the unit you want to convert to.

Attention:

If the input data type is incorrect -> the function returns the #VALUE! error value.
If the unit does not exist -> the function returns the #N/A error value.
If the unit does not support binary prefixes -> the function returns the #N/A error value.
If form_unit, to_unit do not belong to the same group of measurement units -> the function returns the error value #N/A.
Unit names and prefixes are case sensitive.

How to use the CONVERT function in Excel

For example, we have a table of values ​​and units that need to be converted as follows:

Picture 1 of Introducing how to use the CONVERT function in Excel in the most detail

Number 1: We need to convert 1054 grams to tons. In cell E3 we have the formula: =CONVERT(B3;'g';'ton')

We get the result: 1054 grams = 0.001161836 tons

Number 2: We need to convert 220.06 meters to yards. In cell E4 we have the formula: =CONVERT(B4;'m';'yd')

We get the result: 220.06 meters = 240.6605424 yards

Similarly, the 3rd number is the conversion from seconds to days, the 4th number is the conversion from bits to bytes, the 5th number is the conversion from atmosphere degrees to pascal degrees.

With the 6th number, it converts from inches to millimeters. Because these two units are not in the same unit group, they cannot be converted. At this point, Excel will report the #N/A error .

Picture 2 of Introducing how to use the CONVERT function in Excel in the most detail

Update 04 April 2024
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile