Convert realizes the conversion between different units

First, convert grammar and description

Grammar:

CONVERT (number, from_unit, to_unit)

Parameter description

Number required. The numeric value to be converted in from_units units.

From_unit required. The unit of numeric number.

To_unit required. The unit of the result.

Examples are as follows:

For example, the B12 cell has a value of 200

So, when we use the following formula:

=convert (D12, "Day", "yr") is to convert the number 200, D12 in day, to the corresponding number in yr. The following are: 0.54757015742642

One day represents days, yr years, and more simply, the above example, in fact, is to convert 200 days to years, equal to how many years meaning.

Another example

=convert (1.0, "LBM", "kg") converts 1 points to kilograms, with a result of 0.453592

A partial list of units corresponding to the CONVERT function

Simple to use, the key is to be familiar with the unit, let's look at some of the commonly used units corresponding to the letter bar.

① Category: Weight and quality

Grams "g"

Slugs "SG"

LB (avoirdupois) "LBM"

U (atomic mass unit) "U"

Ounce (Avoirdupois system) "OZM"

② class: Distance

M "M"

Legal Mile "Mi"

Sea "Nmi"

Inch "in"

FT "FT"

Code "yd"

Aye "Ang"

Macro "Pica"

③ Class: Date Time

Year "Yr"

Th "Day"

Hour "HR"

Minute "MN"

Sec

④ Type: Pressure

Pascal "Pa" (or "P")

Atmospheric pressure "ATM" (or "at")

MM Mercury column "MmHg"

⑤ class: Force

Newton "N"

Diane "Dyn" (or "dy")

Pound force "lbf"

⑥ class: Energy

Joule "J"

The Loya Jirga "E"

Thermodynamic card "C"

IT card "Cal"

E-volt "EV" (or "EV")

Horsepower-hour "HPh" (or "HH")

Watt-Hour "Wh" (or "Wh")

Foot-pound "FLB"

BTU "BTU" (or "BTU")