Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting weight
Hi there,
I have a spreadsheet and I want to have four columns: A - kilogram B - stone C - pounds D - total pounds I want to be able to enter data in any of the columns (B,C count as one because someone could weigh 11stone 4lb for example) and have the other columns automatically update. I've managed to do this if someone enters their weight in stone and pounds, but I have no idea how it would be achieved if I entered data in any one of the columns. Ideas? Can I use some kind of IF statement? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting weight
You will have to enter the data into a different column and also
indicate the units you are entering, as you can't have both a formula and a value in a cell. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting weight
Hi Mark
Assuming that there will either be an input in column A, or B &C and that you have your headers in row 1, then in D2 enter =IF(A20,CONVERT(A2*1000,"g","lbm"),B2*14+C2) If you also wanted a Kilo entry to not only show total pounds, but Stone and pounds, or stone and pound entries to be shown as kilos, then mirror your headings in columns E to G E - Stone F - Pounds G - Kilos In cell E2 enter =IF(A20,INT(D2/14),"") in F2 enter =IF(A20,MOD(D2,14),"") in G2 enter =IF(A2=0,D2/2.205,"") Format cells to required number of decimal places and copy down as far as required. -- Regards Roger Govier "Mark Allison" wrote in message ... Hi there, I have a spreadsheet and I want to have four columns: A - kilogram B - stone C - pounds D - total pounds I want to be able to enter data in any of the columns (B,C count as one because someone could weigh 11stone 4lb for example) and have the other columns automatically update. I've managed to do this if someone enters their weight in stone and pounds, but I have no idea how it would be achieved if I entered data in any one of the columns. Ideas? Can I use some kind of IF statement? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
does anyone have a chart for weight gain or loss in kilos? | Excel Discussion (Misc queries) | |||
Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel | |||
Converting CSV files into Excel files | Excel Worksheet Functions | |||
How to determine a quantity that is weight restricted... | New Users to Excel | |||
roundoff when converting text to numbers | Excel Worksheet Functions |