#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
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





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
continuous sum formula needed NN Excel Discussion (Misc queries) 2 November 4th 05 07:49 PM
Formula Help Needed BDY Excel Discussion (Misc queries) 3 October 26th 05 05:35 PM
More Help Needed with Count formula Greegan Excel Worksheet Functions 4 July 31st 05 06:31 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Help! Formula needed. Samrasr Excel Discussion (Misc queries) 1 January 26th 05 01:01 PM


All times are GMT +1. The time now is 10:44 AM.

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

About Us

"It's about Microsoft Excel"