![]() In this tutorial, we used a simple example to demonstrate how you can convert kilogrammes to stones and pounds in Excel. Now to get all the other results, drag down from the first result using the auto-fill handle, and our final result will be similar to the below image. The value of a stone is represented by st in the formula A2, which is the address of our values in the excel sheet, and pounds are represented by lbs. =INT(CONVERT(A2,"kg","lbm")/14)&"st"&ROUND(MOD(CONVERT(A2,"kg","lbm"),14),0)&" lbs "Īnd press Enter to get the first result, as shown in the image below. To convert the values to stones and pounds, click on an empty cell, in this case cell B2, and enter the formula as follows. We use the following conversion identities to convert weight between metric and imperial units: 1 stone 6.35029318 kilograms 1 stone 14 pounds. Step 1Ĭonsider the following image of an Excel sheet containing a list of weights in kilograms. Let us look at a simple procedure for converting kilogrammes to stones and pounds in Excel using formulas. Conversion Formulae The conversion formulae for stones (st) and pounds (lb) to kilograms (kg) conversions are as follows: 1 stone 6. Here, we will first use the INT formula to get the first result, then use the autofill handler to get all the results. Converting Kilograms to Stones and Pounds in Excel One kilogramme is always equal to 6.350 stones, and one kilogramme is 2.204 pounds. Some of the other metrics used to measure weight other than the kilogramme and stone are grams, tons, and quintals. We can complete this process simply by using the formulas supported by Excel. So, according to this definition, to calculate a kilogram value to the corresponding value in stone, just multiply the quantity in kilogram by 6.35029318 (the conversion factor). ![]() Converting the values that are in kilogrammes into stones and pounds can be a complex process if we are trying to do it manually, as those both belong to different categories. The metric system of weights and measures is rarely used. In general, we always try to measure weight in kilogrammes or grams, but there can be a situation where we need those values in stones or pounds. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |