Search results
Results From The WOW.Com Content Network
I need to be able to read a cell value and if it has a grams value then convert it to kilograms. Example Cell A1 has the value 800g Our formula in cell A2 reads this and converts to 0.8 kg Some of my cells will also have kg values so I need a formula that can take that into consideration.
But, If all your data is in grams for amounts less than 1000 and any data entered greater than 1000 is KG, so 999 is 999g but: 1001 is enterd in KG not grams so you can never enter something like 1.1KG then this Custom Format will work: [>=1000]#,##0.00"kg";0.00"g". Note this does not convert grams to kilograms only determins if "g" or "kg ...
Hello, I have the following table: A B 20 KG 10 G 30 G 15 KG I would like to select only cells written in G (10 and 30) and multiply them by 1000 to...
Isn't a tonne a 1000 kilograms or 1,000,000 grams? If so shouldn't 28,324 grams equal .028324 tonnes? In other words, just divide grams by 1,000,000. 0.
I was working with the convert command, which provides grams to ounces or pounds; the trick is what to do with the remainder and avoid rounding in the first field. Say your result is 4.6 pounds ... the first field needs to say 4 (w/out rounding up) and the second needs to add the ounces in 16ths of a pound.
Sep 25, 2014. #2. howard said: I would like to know how to convert 50 grams to Milliliters using Excel. I have tried =CONVERT (50,"g",ml), but get #name? Grams are a mass measurement and milliliters are a volume measurement... in order to convert between the two, don't you need to know what the liquid is and, more specifically, the conversion ...
Thanks. By the way, for non-Imperial weight people, multiplying by 2.2046 converts kilos to pounds, and there are 14 pounds (lbs) in a stone. Thanks again.
Hi. Am new to this site. I found a formula converting grams to pounds and ounces. But I need opposite. Am relatively new to Excel working with formulas and am very frustrated. Any help would be appreciated. Thanks. Cris
Dec 5, 2005. Messages. 6. Dec 7, 2005. #4. Followup question. I have a followup question. If I enter a value like 16.3 lbs, the formula above returns 1 lb 0.300000000000001 oz. The correct answer should be 1 lb 4.8 oz.
Thanks. For Haf's benefit, it works by calculating which 1/16th of the compass (22.5°) the direction can be found in and uses the number thus derived to choose between the possible values, adding 1 so that 0° (the first 1/16th) returns the 1st value, etc, and with "N" being repeated at each end of the list because its 1/16th lies half at the beginning of the range and half at the end.