Hi Mick,
Before I can help you further, please explain how you enter the pounds.
Specifically, how do you differentiate between 12 stones 1 pound and 12
stones 10 pounds? By your described system, both would be 12.1 is this
correct?
Peter
----------------------------------
[log in to unmask]
-----Original Message-----
I understood you up to the =INT(A5) ... then I don't understand.
Imagine I have entered the weight like this in A5 12.5 (meaning 12 stones
and 5 pounds). There is 14 lbs in a stone.
What I'd like to appear in B5 is 173
TIA ... Mick
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
|