A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula needed



 
 
Thread Tools Display Modes
  #1  
Old November 25th, 2005, 04:40 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Formula needed

We are trying to workout a formula to do with weight loss. So far we have
everything correct apart from one colum and thats column E

Column B = Weight in Kgs so B4 = 151.5 (formula =Sheet1!$C$25 - which is
151.5 (weight in Kgs)
Column C = BMI so C4 = 45.24 (formula =Sheet1!$H$25 - which is 45.23874
(Body Mass Index BMI)
Column D = Weight loss in Kgs (calculation we use is Column B figure minus
Column C figure)
Column E = Weight in Stones & Pounds ( This is where we are struggling to
come up with a formular that works)
Column F = Loss in pounds (And as a consequence of column E we are having
problems with column F

Can anyone give us a clue as to what we can use in the way of formulas for
column E and F.

TIA


  #2  
Old November 25th, 2005, 05:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Formula needed

You have the cart before the horse!
It is easy to convert kg to lb with either =CONVERT(C4*1000,"g","lbm") or
=C4*2.2046 in F4
To get stones & lbs, you could use in E4: =INT(F4/14)&"st
"&ROUND(MOD(F4,14),0)&"lbs"
or in E4 use =F4/14 and use custom format # ??/14
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"S" wrote in message
...
We are trying to workout a formula to do with weight loss. So far we have
everything correct apart from one colum and thats column E

Column B = Weight in Kgs so B4 = 151.5 (formula =Sheet1!$C$25 - which is
151.5 (weight in Kgs)
Column C = BMI so C4 = 45.24 (formula =Sheet1!$H$25 - which is 45.23874
(Body Mass Index BMI)
Column D = Weight loss in Kgs (calculation we use is Column B figure minus
Column C figure)
Column E = Weight in Stones & Pounds ( This is where we are struggling to
come up with a formular that works)
Column F = Loss in pounds (And as a consequence of column E we are having
problems with column F

Can anyone give us a clue as to what we can use in the way of formulas for
column E and F.

TIA



  #3  
Old November 25th, 2005, 06:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Formula needed

Thanks for that, one small problem though, in the E column, where it gives
the conversion into Stones and pounds, it gives it as a percentage of a
Stone, we want it to read say 23 Stone 12 pounds, how can we do it?


"Bernard Liengme" wrote in message
...
You have the cart before the horse!
It is easy to convert kg to lb with either =CONVERT(C4*1000,"g","lbm") or
=C4*2.2046 in F4
To get stones & lbs, you could use in E4: =INT(F4/14)&"st
"&ROUND(MOD(F4,14),0)&"lbs"
or in E4 use =F4/14 and use custom format # ??/14
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"S" wrote in message
...
We are trying to workout a formula to do with weight loss. So far we
have everything correct apart from one colum and thats column E

Column B = Weight in Kgs so B4 = 151.5 (formula =Sheet1!$C$25 - which is
151.5 (weight in Kgs)
Column C = BMI so C4 = 45.24 (formula =Sheet1!$H$25 - which is 45.23874
(Body Mass Index BMI)
Column D = Weight loss in Kgs (calculation we use is Column B figure
minus Column C figure)
Column E = Weight in Stones & Pounds ( This is where we are struggling to
come up with a formular that works)
Column F = Loss in pounds (And as a consequence of column E we are having
problems with column F

Can anyone give us a clue as to what we can use in the way of formulas
for column E and F.

TIA





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
help on and/or formula needed Fred General Discussion 5 October 14th, 2005 03:06 PM
formula results take up to 2 lines if needed, but keep border smurf Worksheet Functions 0 August 17th, 2005 08:55 PM
Running total formula needed Frank Kabel Worksheet Functions 1 May 30th, 2004 11:26 AM
Possible If, Or formula needed Jason Morin Worksheet Functions 0 April 20th, 2004 06:09 PM
formula needed Worksheet Functions 5 January 28th, 2004 10:22 PM


All times are GMT +1. The time now is 12:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.