یکی از مزایای صفحه گسترده ی اکسل ، قابلیت تبدیل واحدهای اندازه گیری به یکدیگر است ، که در ساختار رشته های مهندسی بسیار پرکاربرد است .
تابع قدرتمند convert واحدهای ۱۰ گروه اندازه گیری را به یکدیگر تبدیل می کند. این گروه ها عبارتند از :
1- وزن و حجم
2- مسافت
3- زمان
4- فشار
5- نیرو
6- انرژی
7- توان
۸- جاذبه
۹- دما
۱۰- حجم مایعات
شکل این تابع به صورت زیر است :
=convert( واحد نهایی ; واحد اولیه ; مقدار )
مقدار مورد نظر را وارد کرده , واحد ها را با علامت گیوه و به ترتیب وارد می کنیم تا اکسل مقدار داده شده را از واحد اولیه بهواحد نهایی تبدیل کند.
مثال : فرض کنید می خواهیم بدانیم یک گرم چند پوند است ؟
به جدول راهنمای تابع نگاه کنید ، علامت اختصاری گرم "g" و پوند "lbm" است . این نکته مهم است که علامت های اختصاری انحصارا باید شبیه آنچه در راهنما ذکر شده است در تابع نوشته شوند ( کوچک و بزرگ بودن مهم است )
=convert(1;"g";"lbm") = 0.002205
CONVERT
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.
Syntax
CONVERT(number,from_unit,to_unit)
Number is the value in from_units to convert.
From_unit is the units for number.
To_unit is the units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit.
| 1-Weight and mass |
From_unit or to_unit |
| Gram |
"g" |
| Slug |
"sg" |
| Pound mass (avoirdupois) |
"lbm" |
| U (atomic mass unit) |
"u" |
| Ounce mass (avoirdupois) |
"ozm" |
| 2-Distance |
From_unit or to_unit |
| Meter |
"m" |
| Statute mile |
"mi" |
| Nautical mile |
"Nmi" |
| Inch |
"in" |
| Foot |
"ft" |
| Yard |
"yd" |
| Angstrom |
"ang" |
| Pica (1/72 in.) |
"Pica" |
| 3-Time |
From_unit or to_unit |
| Year |
"yr" |
| Day |
"day" |
| Hour |
"hr" |
| Minute |
"mn" |
| Second |
"sec" |
| 4-Pressure |
From_unit or to_unit |
| Pascal |
"Pa" (or "p") |
| Atmosphere |
"atm" (or "at") |
| mm of Mercury |
"mmHg" |
| 5-Force |
From_unit or to_unit |
| Newton |
"N" |
| Dyne |
"dyn" (or "dy") |
| Pound force |
"lbf" |
| 6-Energy |
From_unit or to_unit |
| Joule |
"J" |
| Erg |
"e" |
| Thermodynamic calorie |
"c" |
| IT calorie |
"cal" |
| Electron volt |
"eV" (or "ev") |
| Horsepower-hour |
"HPh" (or "hh") |
| Watt-hour |
"Wh" (or "wh") |
| Foot-pound |
"flb" |
| BTU |
"BTU" (or "btu") |
| 7-Power |
From_unit or to_unit |
| Horsepower |
"HP" (or "h") |
| Watt |
"W" (or "w") |
| 8-Magnetism |
From_unit or to_unit |
| Tesla |
"T" |
| Gauss |
"ga" |
| 9-Temperature |
From_unit or to_unit |
| Degree Celsius |
"C" (or "cel") |
| Degree Fahrenheit |
"F" (or "fah") |
| Kelvin |
"K" (or "kel") |
| 10-Liquid measure |
From_unit or to_unit |
| Teaspoon |
"tsp" |
| Tablespoon |
"tbs" |
| Fluid ounce |
"oz" |
| Cup |
"cup" |
| U.S. pint |
"pt" (or "us_pt") |
| U.K. pint |
"uk_pt" |
| Quart |
"qt" |
| Gallon |
"gal" |
| Liter |
"l" (or "lt") |
The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.
| Prefix |
Multiplier |
Abbreviation |
| exa |
1E+18 |
"E" |
| peta |
1E+15 |
"P" |
| tera |
1E+12 |
"T" |
| giga |
1E+09 |
"G" |
| mega |
1E+06 |
"M" |
| kilo |
1E+03 |
"k" |
| hecto |
1E+02 |
"h" |
| dekao |
1E+01 |
"e" |
| deci |
1E-01 |
"d" |
| centi |
1E-02 |
"c" |
| milli |
1E-03 |
"m" |
| micro |
1E-06 |
"u" |
| nano |
1E-09 |
"n" |
| pico |
1E-12 |
"p" |
| femto |
1E-15 |
"f" |
| atto |
1E-18 |
"a" |
Remarks
- If the input data types are incorrect, CONVERT returns the #VALUE! error value.
- If the unit does not exist, CONVERT returns the #N/A error value.
- If the unit does not support an abbreviated unit prefix, CONVERT returns the #N/A error value.
- If the units are in different groups, CONVERT returns the #N/A error value.
- Unit names and prefixes are case-sensitive.
Example
The example may be easier to understand if you copy it to a blank worksheet.
- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
|
|
| A |
B |
| Formula |
Description (Result) |
| =CONVERT(1.0, "lbm", "kg") |
Converts 1 pound mass to kilograms (0.453592) |
| =CONVERT(68, "F", "C") |
Converts 68 degrees Fahrenheit to Celsius (20) |
| =CONVERT(2.5, "ft", "sec") |
Data types are not the same so an error is returned (#N/A) |
| =CONVERT(CONVERT(100,"ft","m"),"ft","m") |
Converts 100 square feet into square meters (9.290304). | |
angstrom to yard calorie to volt celsius celsius to fahrenheit change from one pressure to another conversion tables conversion units convert convert celsius to fahrenheit convert distances convert energy measurements convert foot to inch convert from one time to another convert function convert gallons to liters convert KM to miles convert liquid measures convert minutes to seconds convert to a date convert to metric convert to other language convert to string convert weight and mass CONVERT WORKSHEET FUNCTION convert years to days date conversion dyne to pound force feet to meters fluid ounce to cup foot-pound to btu force conversion gallon to liter grams to ounce horsepower to watt hour to minute inch to foot inches to feet joule to erg kelvin to celsius kilometers to miles length units magnetism conversion meter to mile meter to pica metric conversion metric to English metric to english conversions METRIC TO IMPERIAL metric units newton to dyne pascal to atmosphere pascal to mm of mercury pint to quart pound to atomic mass unit teaspoon to tablespoon temperature equivalents tesla to gauss volume metric conversions what function can I use to convert from one unit of measure to another? xl
بنام خدا