Home / Archive by Category "Excel"

Archives

Convert measurements in Excel with function

Function to convert measurements in Excel Objective: To demonstrate how to use the function convert to convert measurements in Excel. Example Celsius to Fahrenheit Data Conversion in Excel, much easier than establishing values and formulas to perform conversions is to use the CONVERT function. It has the following syntax and parameters: Formula: = CONVERT (num; de_unidade; para_unidade) number: Number that must be converted; from_unit: Data Type the number is; to_unit: Data type you want the data conversion. Example: = CONVERT (10, ā€œCā€, ā€œFā€) Conversion Table: Description From_unit or to_unit Classification Gram "g" Weight and mass Slug "sg" Weight and mass Pound mass (avoirdupois) "lbm" Weight and mass U (atomic mass unit) "u" Weight and mass Ounce mass (avoirdupois) "ozm" Weight and mass Meter "m" Distance...