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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |