Weight convertor

[Guest]

My wife has started another diet! I promised to help by producing a
spreadsheet that would record her progress (her idea). Apart from her
excercise regime and calorie counting I also wanted to include a weight
convertor for her (she has heard of lbs but Kg remain a bit of a mystery for
her). My intention in column D was to have her input her weight in lbs in row
9. Row 10 would convert this to stones and lbs (her favourite). Row 11 would
convert this to Kg (worth a try). Row 12 would record her weekly loss and row
13 would record the running total loss. I thought I had it sussed but for
some reason the rows do not automatically calculate although they will work
if I reconfirm the function of each cell. Can anyone advise please? The
formulae I have been using are;
Assuming the input cell (lbs) is D9 (ROW 9) then the Stones cell (ROW 10)
formula is =QUOTIENT(D9,14) and the remaining lbs cell (ROW 10) formula is
=MOD(D9,14).
To convert to Kg (ROW 11) the formula is =D9*0.4536 and the weekly loss in
column F is =IF(F9=0,0,D9-F9). I used IF(F9=0) because the input cell would
contain a zero for future weeks. I was hoping to use IF(F9=BLANK,0) but this
gives me the #NAME remark and I can't seem to resolve this using the excel
help. It would be preferable just to have a blank cell for future weeks
weight input.
For the 1st week running total cell F13 is just =F12. After that I have used
for the 3rd column (H) the following =IF(H12=0,F13,H12+F13) ie if the weight
loss this week is 0 then use last week's total else sum this week plus last
week's total.
I am using Excel 2000. Can anyone please advise why the cells don't
automatically populate once the initial weight has been input or perhaps
something simpler than my attempt. What started off as a "yes I can knock
that up for you dear" has turned into a major project. Thanks
Chrys

 

[Guest]

for stones see:

http://groups.google.com/group/micr...t+group:*excel+stones&rnum=1#498b5ab90ba96d89

in place of
IF(F9=BLANK,0)
use
IF(F9="",0)
but give the false option as well.

 

[Guest]

Hello GS,
Thanks for the prompt reply. The F9="" works fine and the INT solution gave
the same results as my Quotient/Modulus attempt. The problem remains that the
cells do not update automatically ie if I enter 150 lbs in D9 then D10/E10 do
not automatically give 10 10 and D11 does not automatically give 68.04 (kg).
They will work if select the cell and confirm the function formula. I am
wondering if it is a fault with my copy of Excel as opposed to incorrect
formula ??

rgds
Chrys

 

[Guest]

GS,
Checked tools/options and found that the "calculation" tab sheet was
selected for manual. Don't know why/how but it's ok now. Thanks for your help.
rgds,
Chrys