View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clive Jones Clive Jones is offline
external usenet poster
 
Posts: 2
Default how do i use excel to calculate weight (as in stone and lbs)?

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 :)