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

M

Mike H

Hi,

Wity pounds in a1 use this

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

or

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conversions in Exel 1
A few problems involving LOOKUP and SUMPRODUCT... 2
Imperial Weights in Excel 1
display lbs and ozs 11
how do i format a number into stones, pounds and ounces, please? 2
Sumifs statemenet returns - , how to use in if statement? 2
Can you convert 120lbs to show as 8st 8lbs? 6
adding lbs & oz's 4

Top