Calculate weight (ounces into pounds) in Excell?

B

BCraft

Is there any way to calculate weight (ounces into pounds) in Excell? I am
using the Home and Office version 2007.
 
M

Mike H

with ounces in a1

=INT(A1/16)& " Pounds "&MOD(A1,16)&" Ounces"
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)
 
J

JLatham

I personally like either of the ways that have already been offered, but
there's one more to consider:
=CONVERT(16,"ozm","lbm")
but it does require the Analysis ToolPak add-in be active to use without a
#NAME error taking place (thus my preference for doing it "the hard way" as
Gary''s Student and Mike H have offered up).
 

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

Top