| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does anyone have a template to convert Kilos to Pounds & Ounces | Excel Worksheet Functions | |||
| how do i format a number into stones, pounds and ounces, please? | Excel Discussion (Misc queries) | |||
| Inputting data as Stone, pounds and ounces | Excel Discussion (Misc queries) | |||
| How set up a spread in pounds & ounces? | Excel Discussion (Misc queries) | |||
| How can I add pounds and ounces in excel, | Excel Discussion (Misc queries) | |||
Linear Mode
