+ Reply to Thread
Results 1 to 2 of 2

subtracting total

Hybrid View

  1. #1
    Registered User
    Join Date
    09-05-2006
    Posts
    13

    subtracting total

    I have a spread sheet that keeps track of indirect items. I have an On-Hand qty column and would like to know a formula that will allow me to add a column before the On-Hand that when a number is put in the new column, it will subtract from the On-Hand qty Column. It also has to remain the new number when the column is cleared.

    Ex.
    Initial) run Qty On-Hand
    10

    After run) Run Qty On-Hand
    3 7

    Next Day) Run Qty On-Hand
    7

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Why don't you upload a zipped copy of your worksheet ...?
    HTH
    Carim


    Top Excel Links

+ 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