{"id":1407,"date":"2018-07-04T14:45:59","date_gmt":"2018-07-04T14:45:59","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1407"},"modified":"2023-11-02T19:00:27","modified_gmt":"2023-11-02T19:00:27","slug":"convert","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/convert\/","title":{"rendered":"CONVERT function"},"content":{"rendered":"\n
The CONVERT function in Excel is used to convert a value from one measurement unit to another. It’s a handy tool for converting various types of units, such as length, volume, temperature, and more, directly in your Excel worksheet.<\/p>\n\n\n\n
CONVERT(number, from_unit, to_unit)<\/strong><\/p>\n\n\n\n To use the CONVERT function, follow this simple syntax:<\/p>\n\n\n\n Here’s a practical example: let’s say you have a length in inches (from_unit) and you want to convert it to centimeters (to_unit). The formula would look like this:<\/p>\n\n\n\n This will convert the value in cell A1 from inches to centimeters.<\/p>\n\n\n\n Optional: If you have a measurement that might be optional (for example, if you don’t always have a “from_unit”), you can enclose it in square brackets and specify that it’s optional in the explanation.<\/p>\n\n\n\n Now, let’s see a few examples of how you can use the CONVERT function:<\/p>\n\n\n\n These examples demonstrate how you can convert different units using the CONVERT function.<\/p>\n\n\n\n If you encounter unfamiliar units or terms, you can refer to external resources or websites for definitions and explanations.<\/p>\n","protected":false},"excerpt":{"rendered":" The CONVERT function in Excel is used to convert a value from one measurement unit to another. It’s a handy tool for converting…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
number<\/strong><\/td> The value you want to convert.<\/td><\/tr> from_unit<\/strong><\/td> The current unit of measurement for the value.<\/td><\/tr> to_unit<\/strong><\/td> The unit of measurement to which you want to convert the value.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=CONVERT(number, from_unit, to_unit)<\/code><\/pre>\n\n\n\n
=CONVERT(A1, \"in\", \"cm\")<\/code><\/pre>\n\n\n\n
=CONVERT(100, \"mi\", \"km\") ' Converts 100 miles to kilometers\n=CONVERT(32, \"\u00b0F\", \"\u00b0C\") ' Converts 32 degrees Fahrenheit to degrees Celsius\n=CONVERT(500, \"gal\", \"L\") ' Converts 500 gallons to liters<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n