PC Review


Reply
Thread Tools Rate Thread

Calculate weight (ounces into pounds) in Excell?

 
 
BCraft
Guest
Posts: n/a
 
      14th Jan 2010
Is there any way to calculate weight (ounces into pounds) in Excell? I am
using the Home and Office version 2007.
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      14th Jan 2010
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.

 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      14th Jan 2010
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.

 
Reply With Quote
 
Mike H
Guest
Posts: n/a
 
      14th Jan 2010
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.

 
Reply With Quote
 
JLatham
Guest
Posts: n/a
 
      14th Jan 2010
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using weight (pounds/ounces) in Access database =?Utf-8?B?QmFzc21hbiBNaWtl?= Microsoft Access 1 8th Aug 2005 10:38 PM
Pounds to ounces Fizz Microsoft Excel Discussion 3 2nd Feb 2005 02:57 PM
How to calculate pounds and ounces in a chart =?Utf-8?B?TWljaGVsbGUgSw==?= Microsoft Excel Charting 1 23rd Nov 2004 03:24 PM
Pounds/Ounces Mr. Moxie Microsoft Excel Discussion 4 29th Sep 2004 01:42 AM
I don't think ANYONE can add pounds and ounces! 1fishy Microsoft Excel Misc 9 6th Apr 2004 04:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:42 PM.