Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Engineering > CONVERT
 

CONVERT(number, from_unit, to_unit)

 
 Returns the number in one measurement system converted to another.

 numberThe number you want to convert.
 from_unitThe units to convert the number from.
 to_unitThe units to convert the number to.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• This function allows conversion between the following types of units: weight & mass, distance, time, pressure, force, energy, power. magnetism, temperature and liquid measure.
     
  		• Unit names and prefixes are case sensitive.
     
  		• If "from_unit" and "to_unit" are not comparable, then #N/A is returned.
     
  		• If the unit does not support an abbreviated unit prefix, then #N/A is returned.
     
  		• If the unit does not exist, then #N/A is returned. See Example 9.
     
  		• If the input datatypes are incorrect, then #VALUE! is returned. See Example 8.
     
  		• There are also 18 unit prefix abbreviations that allow metric units to be used easily kg = kilogram, mg = microgram.
     
  		• Example 8 - If the "from_unit" and the "to_unit" are not compatible, then #N/A is returned.
     
  		• For more examples please refer to the CONVERT Function page.

     EXAMPLES
     
     A
    1=CONVERT(1,"lbm","kg") = 0.454
    2=CONVERT(10,"g","ozm") = 0.353
    3=CONVERT(68,"F","C") = 20
    4=CONVERT(10,"in","cm") = 25.4
    5=CONVERT(10,"yr","day") = 3652.5
    6=CONVERT(10,"mn","sec") = 600
    7=CONVERT(CONVERT(100,"ft","m"),"ft","m") = 9.290
    8=CONVERT(10,"ft","sec") = #N/A
    9=CONVERT(10,"MN","sec") = #N/A
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top