When you have an Excel spreadsheet that uses units of measurement like these, remember the CONVERT function.įor more, take a look at how to convert text to dates or how to convert text to numbers in Excel.Miles per hour to feet per second conversion cards This is handy for those abbreviations that are less than obvious. You can use this drop-down box to choose both the from_unit and to_unit arguments easily. Then, insert your closing parenthesis and press Enter or Return to apply the formula and receive the result. Double-click the unit you want and the abbreviation will appear in the formula. You can see when we place our cursor in the argument’s spot for the to_unit, a drop-down list appears. When you enter the CONVERT function into your sheet’s Formula Bar, you can select a unit argument to see the options and pick the one you need. RELATED: How to Find the Function You Need in Microsoft Excel You can take a look at Microsoft’s Support page for the function if you want to convert a unit that isn’t as common as some others. The most difficult part of using the CONVERT function in Excel is knowing the abbreviations for the units. You can also convert from meters per hour to miles per hour: =CONVERT(65,"m/h","mph")įor one more example, we’ll convert our A2 value from bits to bytes with this formula: =CONVERT(A2,"bit","byte") How about a speed conversion? Here, you can convert the value in cell A2 from meters per hour to meters per second: =CONVERT(A2,"m/h","m/s")
Need to perform some area conversions? This formula converts the value in cell A2 from square feet to square inches: =CONVERT(A2,"ft2","in2")Īnd with this formula, you can convert square meters to square miles: =CONVERT(A2,"m2","mi2")Īdditional area abbreviations you might need include: Here are a handful of additional volume abbreviations you might use: With this formula, you can convert a specific number U.S pints to U.K. You can convert teaspoons to tablespoons for the value in cell A2: =CONVERT(A2,"tsp","tbs") If you spend time in the kitchen, then you might find yourself converting those types of measurements. Tip: It’s likely that when using CONVERT with temperature and other units, it’s likely you’ll want to round decimal values. You can use this formula to convert 78 from Fahrenheit to Celsius: =CONVERT(78,"F","C") Note, you can also use “F” instead of “fah” and “C” instead of “cel.” Plus, you can use a number instead of a cell reference. Here, we’ll convert the temperature in cell A2 from Fahrenheit to Celsius: =CONVERT(A2,"fah","cel") Here are a few other abbreviations for common distance measurements:Ĭonverting temperatures is common when you’re working with someone who uses Celsius instead of Fahrenheit. You can also use a number as the reference and create the formula this way: =CONVERT(24,"in","ft") Distanceįor a simple distance conversion, we’ll convert the inches in cell A2 to feet using this formula: =CONVERT(A2,"in","ft") The reference argument can be a number or a cell reference. The syntax for the function is CONVERT(reference, from_unit, to_unit) where you’ll need all three arguments. Which Units Can You Convert?Īs mentioned, you can convert more than 12 types of units with the function. So not only is it simple to use, but it’s also easy to remember. The nice thing about this function in Excel is that it uses a basic formula with only a few arguments. Whether you need feet to meters, Fahrenheit to Celsius, or teaspoons to tablespoons, you can take advantage of the CONVERT function in Microsoft Excel for a dozen types of conversion.
0 kommentar(er)
