+ Reply to Thread
Results 1 to 3 of 3

Subtract ounces sold from total beginning to get remaining

  1. #1
    Registered User
    Join Date
    07-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Subtract ounces sold from total beginning to get remaining

    Hello every one,
    I am not a master in excel but i have seen lot of professional here, so i am looking for a small help.

    I am making bar inventory sheet, in which I am calculating 1 bottle is = 750 ml ie 25 ounce from 1 bottle.
    I have filled in the details in which I am considering 1 bottle = 0.25 Serving.
    So if I exceed above 0.25 it should automatically calculate 1.00.
    For Eg I have taken 1 bottle in stock ie 1.00 but when I close my shift and I sold 0.05 ounce.
    So my answer in balance column should show 0.20 but its showing 0.95 which i dont want
    If I sell 0.15 ounce the balance figure should show 0.10 but its showing 0.85

    I am stuck and dont know which formula will give me the exact figure which i want,

    I have atached excel file.
    Looking forward for you kind help .
    Regards
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: A Simple Formula For Correct Answer

    Hello Yasinamdar & Welcome to the Forum,

    After reading your requirements, it seems you would just subtract the sale from the opening 25 ounces or else there is more to it...

    J5 copied down =0.25-I5

    Administrative Note:
    • We would love to continue to help you with your query, but first, before we can proceed…
    • Please see Forum Rule #1 about proper thread titles and adjust accordingly...
    • Changed for you this time, but please do so in the future
    Last edited by jeffreybrown; 07-30-2013 at 01:18 PM.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    07-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Subtract ounces sold from total beginning to get remaining

    It would be great if someone just have a look on my attached excel sheet and i think its just a simple formula which i am not able to figure it out.
    Really looking forward to it.

    Regards

+ 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] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  2. Running Total of Days Remaining?
    By demonfly100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2012, 09:40 AM
  3. SUMPRODUCT of total qty sold for each SKU
    By 19magic75 in forum Excel General
    Replies: 2
    Last Post: 06-27-2012, 08:38 AM
  4. Ticket sequence and total sold
    By michaelof36 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-27-2012, 04:22 PM
  5. [SOLVED] Total remaining formula
    By jbsand1001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2005, 01:06 PM

Tags for this Thread

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