Posts

Showing posts with the label convert formula

Convert Formula in Microsoft excel

Image
  CONVERT Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used  Convert Formula What Does It Do ? This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to Centimeters. Syntax =CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo) Formatting No special formatting is needed.   Example The following table was used by an Import / Exporting company to convert the weight and size of packages from old style UK measuring system to European system. Abbreviations This is a list of all the possible abbreviations which can be used to denote measuring systems. These characters can be used as a prefix  to access further units of measure. Using "c" as a prefix to meters "m" will allow centimeters "cm" to be calculated.