+ Reply to Thread
Results 1 to 2 of 2

how to add or subtract from two cells into one

  1. #1
    labjr1231
    Guest

    how to add or subtract from two cells into one

    I am new to formulas. I would like to run an inventory. 3 columns, A1
    recieve,B1 Shipped, C1 Balance.
    I want C1 to give total weither I place a number in A1 or B1.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479
    Quote Originally Posted by labjr1231
    I am new to formulas. I would like to run an inventory. 3 columns, A1
    recieve,B1 Shipped, C1 Balance.
    I want C1 to give total weither I place a number in A1 or B1.

    Thanks
    Hi labjr1231

    with the info you have given try in C2 =A1-B1

    However to keep your inventory balance you will surely need a column for Opening Stock?

    In which case if Opening Stock was in A1, recieve B1 Shipped C1 and Balance D1, try in D2 =A1+B1-C1
    Paul

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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