Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 1st 10, 08:19 PM posted to microsoft.public.excel.misc
j j is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 128
Default 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   Report Post  
Old January 1st 10, 08:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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   Report Post  
Old January 1st 10, 08:38 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 561
Default 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   Report Post  
Old January 1st 10, 08:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 561
Default 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   Report Post  
Old January 1st 10, 08:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert kilograms to stones AND pounds Bristlepete Excel Discussion (Misc queries) 13 October 29th 08 03:26 PM
Inputting data as Stone, pounds and ounces BigAndy Excel Discussion (Misc queries) 2 September 13th 07 12:33 AM
how can I put weights in stones and pounds into an excel spreadshe SteveM Excel Discussion (Misc queries) 1 September 6th 05 09:32 AM
how can i use imperial units eg stones and pounds Rod C Excel Discussion (Misc queries) 2 February 16th 05 11:55 AM
I've got a formula for stones and pounds - how do I get an excel . mikelenno Charts and Charting in Excel 4 January 25th 05 08:45 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017