=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)
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.