how to use imperial weights in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
Zebedee,

One way: Starting in row 2, enter the pounds in one column (A), and the ounces in another (B).

Then in a third column (C), use the formula
=SUM($A$2:A2) + INT(SUM($B$2:B2)/16)

and in a fourth column (D), use the formula
=SUM($B$2:B2) -INT(SUM($B$2:B2)/16)*16

and copy down to match your columns of data.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Imperial Weights in Excel 1
format for weight 4
nested sumif? 2
I need serious help Worksheet functions 4
Can I convert Imperial lbs to Stones and lbs in the same cell? 1
Display Weight in Lbs and Oz. 4
Conversions in Exel 1
display lbs and ozs 11

Back
Top