Can I convert Imperial lbs to Stones and lbs in the same cell?

  • Thread starter Thread starter John415
  • Start date Start date
Hi,

Wity pounds in a1 use this

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

or

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

Mike
 
Back
Top