Where did SUM creep in, try this instead

=INT(A1/14)&" Stones "&MOD(A1,14)&" Pounds "

Mike

"Mike H" wrote:

Hi,

With pounds in A1 try this

=INT(SUM(A1)/14)&" Stones "&MOD(A1,14)&" Pounds "

Mike

"carol" wrote:

Does excell recognise weight in st and lbs? Iam trying to devise a weight
monitoring s/s that tracks the percentage gain or loss each week, but want it
to be shown in st and lbs not total lbs.

Thanks

Carol