Converts a number from one measurement system to another.
구문
CONVERT(number, from_unit, to_unit)인수
number필수
The numeric value in from_unit that you want to convert.
from_unit필수
The unit for the number.
to_unit필수
The unit for the result.
The CONVERT function allows you to translate values between different units of measurement, such as weight, distance, time, pressure, or temperature. It is highly useful for standardizing data sets that contain mixed units.
=CONVERT(10, "m", "ft")→32.80839895Converts 10 meters into feet.
Select the cell
Click on the cell where you want the converted value to appear.
Enter the formula
Type =CONVERT followed by the number, the source unit, and the target unit in quotes.
Yes, unit abbreviations are case-sensitive; for example, 'm' represents meters while 'M' represents miles.