how do i use excel to calculate weight (as in stone and lbs)?

C

Clive Jones

Hello.

I'm trying to find out how to use excel to calculate a number in to weight
(stone and pounds).

What I need it to do is when the lbs gets to 14, then it needs to add 1 to
the stone. I suppose the best way would be to have a seperate stone and lbs
column but I'd like to keep it in one column if possible (as in 00.00).

Any help greatly appreciated.

Thanks :)
 
J

Jacob Skaria

Try the below formula

=(INT(A1/14)&"."&MOD(A1,14))+0

If this post helps click Yes
 
J

Jacob Skaria

Not sure whether this is what you are looking for.. If it is the below will
display the value as text in 00.00 format

=TEXT((INT(A1/14)&"."&MOD(A1,14)),"00.00")

If this post helps click Yes
 
D

David Biddulph

OK for A1 values such as 140 or 141, but look (for example) at A1 values of
139.999 or 142.1 or 153.99
 
J

Jacob Skaria

Should have been..(still not sure whether this is what OP is looking for)

=TEXT((INT(A1/14)&"."& ROUND(MOD(A1,14),)),"00.00")

If this post helps click Yes
 
D

David Biddulph

Better, but still get such answers as 09.14 and 10.14 from A1 values of
139.999 and 153.99.

An alternative might be =TEXT((INT(ROUND(A1,)/14)&"."&
MOD(ROUND(A1,),14)),"00.00")
 
C

Clive Jones

Thank you to both of you for your help.

With the answers you both gave me, I have managed to get the desired result
I wanted.

Appreciate your help :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top