| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb
I have a table of weights, in pounds. How do I convert them to stones and
pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7 pounds. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb
Hi,
With pounds in a1 try this =INT(A1/14) & " Stones " & MOD(A1,14)&" Pounds" Mike "J" wrote: I have a table of weights, in pounds. How do I convert them to stones and pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7 pounds. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb
Try this:
=TRUNC(A1/14) & " STONES " & ROUND(SUM(11/14,-TRUNC(11/14))*14,0) & " POUNDS" Micky "J" wrote: I have a table of weights, in pounds. How do I convert them to stones and pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7 pounds. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert pounds to stones eg 200 pounds is 14 stone 4
11 should read: A1
Anyhow, Mikes formula is "nicer" Micky Try this: =TRUNC(A1/14) & " STONES " & ROUND(SUM(11/14,-TRUNC(11/14))*14,0) & " POUNDS" Micky "J" wrote: I have a table of weights, in pounds. How do I convert them to stones and pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7 pounds. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert pounds to stones eg 200 pounds is 14 stone 4
Micky,
I bet you meant this :) =TRUNC(A1/14) & " STONES " & ROUND(SUM(A1/14,-TRUNC(A1/14))*14,0) & " POUNDS" But I'd still go with my shorter version. Mike "מיכאל (מיקי) אבידן" wrote: Try this: =TRUNC(A1/14) & " STONES " & ROUND(SUM(11/14,-TRUNC(11/14))*14,0) & " POUNDS" Micky "J" wrote: I have a table of weights, in pounds. How do I convert them to stones and pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7 pounds. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert kilograms to stones AND pounds | Excel Discussion (Misc queries) | |||
| Inputting data as Stone, pounds and ounces | Excel Discussion (Misc queries) | |||
| how can I put weights in stones and pounds into an excel spreadshe | Excel Discussion (Misc queries) | |||
| how can i use imperial units eg stones and pounds | Excel Discussion (Misc queries) | |||
| I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel | |||
Hybrid Mode
