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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I convert Imperial lbs to Stones and lbs in the same cell? (https://www.excelbanter.com/excel-discussion-misc-queries/250868-can-i-convert-imperial-lbs-stones-lbs-same-cell.html)

John415

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

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

Mike H

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

Hi,

Wity pounds in a1 use this

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

or

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

Mike

"John415" wrote:

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

All times are GMT +1. The time now is 12:34 AM.