Calculate weight (ounces into pounds) in Excell?
 

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

Calculate weight (ounces into pounds) in Excell?
 

Enter the weight in oz in A1 and in B1 enter:

=16*A1
--
Gary''s Student - gsnu200909


"BCraft" wrote:

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

Calculate weight (ounces into pounds) in Excell?
 

Sorry:

=A1/16
--
Gary''s Student - gsnu200909


"BCraft" wrote:

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

Calculate weight (ounces into pounds) in Excell?
 

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)


"BCraft" wrote:

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

Calculate weight (ounces into pounds) in Excell?
 

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


"BCraft" wrote:

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