Convert lbs to stones and lbs | MrExcel Message Board
...Hi, could somebody please help me convert a weight in lbs to stones and lbs? I can obviously get it converted into a decimal but can't quite sort the lbs....
https://www.mrexcel.com/board/threads/convert-lbs-to-stones-and-lbs.566455/
Formula to change 'Stones - Pounds' to Pounds? - MrExcel
...Hi All, Does anyone know of a formula to change imperial stones and pounds to just pounds eg 13 stones 3 lbs = 185lbs ? (14 pounds to a stone) Thanks, papillon...
https://www.mrexcel.com/board/threads/formula-to-change-stones-pounds-to-pounds.80736/
Formula to convert stone and pounds into pounds - MrExcel
...The other issue I have is how to enter stone and pounds into a single cell in the custom number format "00st 0lbs" so it can be converted to pounds - would it be better to use 2 cells for stones and pounds? Help would be appreciated - many thanks!...
https://www.mrexcel.com/board/threads/formula-to-convert-stone-and-pounds-into-pounds.1181152/
Converting from kilos to stones and pounds - MrExcel
...I think it's something to do with the "ROUND" function but I'm struggling. Any help would be much appreciated. 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....
https://www.mrexcel.com/board/threads/converting-from-kilos-to-stones-and-pounds.272150/
Converting pounds into stone? | MrExcel Message Board
...Hi all, Here is an example of what I'm trying to do, and how I would like the data displayed: A1=178 and I want to get to: B1=12st 10lbs Now, if I use the formula =A1/14, I get the value 12.71. Is there a way of converting this into the above format? For display purposes, I can probably use......
https://www.mrexcel.com/board/threads/converting-pounds-into-stone.468435/
Adding/subtracting imperial stones and lbs - MrExcel
...Hiya I'm using this to convert kgs to Stones and Lbs which works great: =INT (ROUND (N1*2.2046,0)/14)&"st "&MOD (ROUND (N1*2.2046,0),14)&"lbs" and gives this result: 9st 11lbs For any cells with the stones and lbs results in them I'd like to be able to add/subtract and it add or subtract it correctly - if I use use plus or minus I get #VALUE!...
https://www.mrexcel.com/board/threads/adding-subtracting-imperial-stones-and-lbs.1004949/
How do you put weights ( in stones and pounds) in a column ... - MrExcel
...A B 1 12 st 6 lbs 2 13 st 7 lbs 3 10 st 3 lbs I would like to be able to put weights(as stones and pounds) into a column and be able to perform calculations on the data. Currently the only way I can manage this is to put the stones and pounds in seperate columns. Is there......
https://www.mrexcel.com/board/threads/how-do-you-put-weights-in-stones-and-pounds-in-a-column-and-add-or-subtract-them-from-one-another.814033/
Column/Bar Chart Displaying Stones/Pounds - MrExcel
...Here's one way. You need to have each weight entered into a single cell, so for example 12 stone 7 pounds would be entered as 12.5 Right click on the chart's Y axis, and go into the Scale tab. Untick the option for Auto on Major unit, and set this to 1, so this will be your marker for stones. Untick the option for Minor Unit, and set this to 0.0714285714 - this is the same as saying 1/14. Then ......
https://www.mrexcel.com/board/threads/column-bar-chart-displaying-stones-pounds.324894/
Stones and Pounds | MrExcel Message Board
...Hi If there a way you can change the metric system in an excel spreadseet cell so instead of running 1.1 - 1-10 you can enter stones pounds and ounces . e.g. 1.1 - 1.14 with 1.14 being highest rather then low. It should include ounces also. My scales show stones pounds (each pound to a quater)......
https://www.mrexcel.com/board/threads/stones-and-pounds.333530/
Writing Stones and Pounds into Excel | MrExcel Message Board
...I have done as you said and put new columns for stone and lbs in D and E. In column C i have put Weight and i am entering 15st 10.1lbs (example). In column D i am using "left (c3,2)" to get the weight (doubt me ever getting below 10 stone so this is fine). In column E i am using "Mid (c3,6,4) which brings back the pounds....
https://www.mrexcel.com/board/threads/writing-stones-and-pounds-into-excel.1265299/