+ Reply to Thread
Results 1 to 2 of 2

formula for adding pounds and ounces

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    1

    formula for adding pounds and ounces

    I am having trouble constructing a spreadsheet to track weights of equipment (cameras, computer, etc.) when I travel. I need to value the items in pounds and ounces, but don't know how to state the formula. Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: formula for adding pounds and ounces

    Assuming Range A1:A20 has lbs part of the weight and Range B1: B20 has Oz part, then the following will give you total weight:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Vandan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Re: Convert decimal Pounds to Pounds-Ounces
    By Sindhiiu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-24-2012, 11:37 AM
  2. Pounds and ounces ???
    By diana15 in forum Excel General
    Replies: 1
    Last Post: 10-17-2006, 07:00 PM
  3. [SOLVED] adding pounds and ounces
    By Model-man in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-07-2006, 06:00 AM
  4. [SOLVED] Stones,Pounds and Ounces
    By Carole in forum Excel General
    Replies: 4
    Last Post: 03-01-2005, 05:06 PM
  5. Pounds to ounces
    By Fizz in forum Excel General
    Replies: 3
    Last Post: 02-02-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1