Convert realizes the conversion between different units

Source: Internet
Author: User
Tags numeric numeric value

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")

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.