Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
continuous sum formula needed | Excel Discussion (Misc queries) | |||
Formula Help Needed | Excel Discussion (Misc queries) | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Help! Formula needed. | Excel Discussion (Misc queries) |