રીત ૧
Formula convert
=CONVERT(6,"C","F") Convert 6 degrees Celsius to
Fahrenheit (42.8)
=CONVERT(6,"tsp","tbs") Convert 6 teaspoons to tablespoons
(2)
=CONVERT(6,"gal","l") Convert 6 gallons to liters (22.71741274)
=CONVERT(6,"mi","km") Convert 6 miles to kilometers
(9.656064)
=CONVERT(6,"km","mi") Convert 6 kilometers to miles
(3.728227153)
=CONVERT(6,"in","ft") Convert 6 inches to feet (0.5)
=CONVERT(6,"cm","in") Convert 6
centimeters to inches (2.362204724)
example
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).
રીત ૨
cell a1માં 12 લખો, cell
a2 માં m લખો, cell
a3 માં ft લખો અને
cell a4 માં નીચે ની ફોર્મુલા લખો
=CONVERT(
a1, a2, a3) હવે તમે નીચે
આપેલ શોર્ટ ફોર્મ નો ઉપઓગ કરી ને બીજુ કન્વર્ટ કરી શકો શો.
Distance Units
Meter "m"
Statute Mile "mi"
Nautical Mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica "Pica"
Liquid Units
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")
Temperature Units
Degree Celsius "C" (or
"cel")
Degree Fahrenheit "F" (or "fah")
Kelvin "K" (or
"kel")
Power Units
Horsepower "HP" (or "h")
Watt "W" (or "w")
Magnetism Units
Tesla "T"
Gauss "ga"
Time Units
Year "yr"
Day "day"
Hour "hr"
Minute "mn"
Second "sec"
Weight & Mass Units
Gram "g"
Slug "sg"
Pound Mass "lbm"
U (Atomic Mass Unit) "u"
Ounce Mass "ozm"
Force Units
Newton "N"
Dyne "dyn" (or "dy")
Pound Force "lbf"
Pressure Units
Pascal "Pa" (or "p")
Atmosphere "atm" (or
"at")
mm of Mercury "mmHg"
Energy Units
Joule "J"
Erg "e"
Thermodynamic Calorie "c"
IT Calorie "cal"
Electron Volt "eV" (or
"ev")
Horsepower-Hour "HPh"
Watt-Hour "Wh"
Foot-Pound "flb"
BTU "BTU" (or
"btu")
Multiplier Multiplier
Value Abbreviation
exa 1.00E+18 "E"
peta 1.00E+15 "P"
tera 1.00E+12 "T"
giga 1.00E+09 "G"
mega 1.00E+06 "M"
kilo 1.00E+03 "k"
hecto 1.00E+02 "h"
dekao 1.00E+01 "e"
deci 1.00E-01 "d"
centi 1.00E-02 "c"
milli 1.00E-03 "m"
micro 1.00E-06 "u"
nano 1.00E-09 "n"
pico 1.00E-12 "p"
femto 1.00E-15 "f"
atto 1.00E-18 "a"
=Abbr("Automated Teller Machine")
No comments:
Post a Comment