![]() They are limited to the base measures, not multipliers like km / kilometres. However the suggestions don’t always make a lot of sense in the real world. To avoid many of these errors, Autocomplete can help you type in the right matching conversion factor – it can limit the to_unit suggestions to the ones applicable for the from_unit. For ounces in weight/mass use ‘ozm’.Īll measurement ‘to’ and ‘from’ units are case-sensitive. Some of the abbreviations aren’t what you expect. Mostly likely it should be =CONVERT(100,”tsp”,”cup”). =CONVERT(100,”tsp”,”c”) will get a #N/A result because it’s trying to convert a 100 teaspoons of liquid measure into a thermodynamic calorie (quite a different animal). =CONVERT(51234,”sec”,”hr”) is correct.Īnother mistake is to try converting mismatching measurements. Such a powerful but flexible function means there’s plenty of scope for formula mistakes.Ī common one is forgetting the quote marks around the “to” and “from” units.įor example =CONVERT(51234,sec,hr) looks like it will convert 51,234 seconds into hours but it won’t – the double-quotes are missing. For example ‘m’ is the abbreviation for metre and ‘k’ is the multiplier prefix for ‘kilo’ or x 1000 – put the two together to get ‘km’ the CONVERT abbreviation for kilometre (also the standard abbreviation, the metric system is wonderfully consistent).Įven with the multipliers, the convert function list of measurements is by no means complete as we’ll see later. In addition to the basic units, there are also multiplier options which apply mostly to the metric measurements. =CONVERT(100, “ km“, “ mi“) converts 100 kilo metres into miles The UnitsĬONVERT has a long list of measurement units to choose from. Of course any of these are reversible for example: =CONVERT( 100,” oz“,” l“) converts 100 fluid ounces ( oz) into liters. =CONVERT( 25,” C“,” F“) converts 25° Celsius into Fahrenheit. =CONVERT( 100,” mi“,” km“) converts 100 miles into kilo meters Sounds imposing but here are some simple and common examples. It’s a text value that can be typed into the formula or referenced from another cell. To_unit is the measurement you want converted to. Enter a value in any one field and click Calculate equivalent values are automatically displayed. Number is the incoming value – probably a reference to another cell.įrom_unit is the measurement scale that applies to the number. Home Resources Calculators Standard to Metric Converter. Most commonly this is used for imperial/US metric conversions but can also be used to convert between scales of the same type (feet to miles or seconds to hours). How to convert metric to imperial and other measure conversions in Excel.Ĭonverting measurements from one system to another can be done by Excel using the CONVERT function … here’s how it works and then we’ll tell you what CONVERT can’t do or should do better.Īs usual, we decided to write about an Office feature thinking it will be straight-forward only to find curious anomalies and problems even in such a supposedly mature product like Excel.ĬONVERT() lets you change a measurement in one scale to another scale using in-built conversion factors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |