Difference between revisions of "Manuals/calci/CONVERTCORE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 297: Line 297:
{| id="TABLE3" class="SpreadSheet blue"
{| class="wikitable"
|- class="even"
|- class="even"

Latest revision as of 04:07, 29 September 2021

CONVERTCORE (Number,FromUnit,ToUnit,DoNotTryConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)

  • is the value in to change.
  • is the units for the value.
  • is the units for the result.


  • This function converts one unit system to another unit system.
  • Example:To change the length in kilometer unit to standard unit meter.
  • and will accept any units which we need to give in " "(double quotes).

This function show the result as Error:

  1. when the input value are incorrect
  2. when the and does not exist
  3. when the units are in not same groups.

Unit names and indications are case-sensitive.

Weight/Mass Fromunit or Tounit
Gram "g"
Kilo gram "kg"
Slug "sg"
Pound mass "lbm"
U(atomic mass unit) "u"
Ounce mass "ozm"
Distance Fromunit or Tounit
Meter "m"
Kilometer "km"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
yard "yd"
Foot "ft"
Angstrom "ang"
Pica(1/72 in.) "Pica"
Time Fromunit or Tounit
Year "yr"
Day "day"
Hour "hr"
Minute "mn"
Second "sec"
Pressure Fromunit or Tounit
Pascal "Pa"
Atmosphere "atm"
mm of Mercury "mmHg"
Force Fromunit or Tounit
Newton "N"
Dyne "dyn"
Pound Force "lbf"
Energy Fromunit or Tounit
Joule "J"
Erg "e"
IT calorie "cal"
Thermodynamic calorie "c"
Electron volt "eV"
Foot pound "flb"
Horsepower hour "HPh"
Watt-hour "Wh"
Kilocalorie "kcal"
Power Fromunit or Tounit
Horse power "HP"
Watt "W"
Magnetism Fromunit or Tounit
Gauss "ga"
Tesla "T"
Temperature Fromunit or Tounit
Kelvin "K"
Degree Celsius "C"
Degree Fahrenheit "F"
Liquid Measure Fromunit or Tounit
Liter "l"
Milliliter "ml"
Gallon "gal"
Quart "qt"
U.K.pint "uk_pt"
U.S.pint "pt"
Cup "cup"
Fluid ounce "oz"
Teaspoon "tsp"
Tablespoon "tbs"


Equation Number Fromunit Tounit Result
CONVERTCORE(10,"ozm","sg") 10 ozm sg 0.019425668878sg
CONVERTCORE(30,"lbm","kg") 30 lbm kg 13.607769290559151kg
CONVERTCORE(0.5,"mi","m") 0.5 mi m 804.6719999999999m
CONVERTCORE(0.002,"km","Nmi") 0.002 km Nmi 0.0010799136069114472Nmi
CONVERTCORE(5,"ft","in") 5 ft in 60in
CONVERTCORE(7,"yd","ang") 7 yd ang 64007999999.99999ang
CONVERTCORE(5,"yd","Pica") 5 yd Pica 12959.999998668Pica
CONVERTCORE(15,"Pa","mmHg") 15 Pa mmHg 0.1125092562mmHg
CONVERTCORE(4, "yr","day") 4 yr day 1461day
CONVERTCORE(1.5,"min","sec") 1.5 min sec 90sec
CONVERTCORE(15,"lbf","N") 15 lbf N 66.7233298977046N
CONVERTCORE(10,"BTU","J") 10 BTU J 10550.582128368933J
CONVERTCORE(15,"W","HP") 15 W HP 0.020115300904786235HP
CONVERTCORE(45,"T","ga") 45 T ga 450000ga
CONVERTCORE(90,"degF","degK") 90 F K 305.3722222222222K
CONVERTCORE(100,"oz","cup") 100 oz cup 12.5cup
CONVERTCORE(25,"pt","qt") 45 pt qt 12.5qt

Related Videos


See Also


Convert Units