B
BCraft
Is there any way to calculate weight (ounces into pounds) in Excell? I am
using the Home and Office version 2007.
using the Home and Office version 2007.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Enter the weight in oz in A1 and in B1 enter:
=16*A1
=16*A1
G
Gary''s Student
Sorry:
=A1/16
=A1/16
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)
=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).
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).