+ Reply to Thread
Results 1 to 3 of 3

hif - Highest in first out

  1. #1
    Registered User
    Join Date
    01-14-2021
    Location
    pakistan
    MS-Off Ver
    2019
    Posts
    3

    hif - Highest in first out

    I need a formaula - that works somewhat like FIFO -
    like we have purchases of stocks on various dates- the prices var on each date of purchase -
    so when i make sale - i want to deduct from the sale price the purchase price that has the heighest value in order to minimise my profits and ultimately the Tax.
    now when we make next sale - we will check that how much units are deducted from the highest priced purchased and how much units are there -so that we may dededuct units adn then goes to second highest and so on.

    Purchases
    Date Units price
    1-jan-2020 2 3
    2 jan-2020 3 2
    3- jan -2020 4 5

    Sales

    Date Units Price
    2 jan 2020 3 6

    Now the formula shall (keeping the dates in mind) goes to 1 -jan purchase as it has the highest purchase price and then from the sale price deduct the purchase price and give us profit on that sale - but it will just deduct the amount of 2 units and the third one shallbe from the next highest (with dates order) and deduct the remaining from those units like in this case the 2nd jan products and price.
    hope you understand
    Last edited by ASFAND123; 01-14-2021 at 08:53 AM.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: hif - Highest in first out

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    01-14-2021
    Location
    pakistan
    MS-Off Ver
    2019
    Posts
    3

    Re: hif - Highest in first out

    Ok - here is the attachment
    Attached Files Attached Files

+ 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. Replies: 3
    Last Post: 05-27-2019, 06:19 AM
  2. Replies: 3
    Last Post: 10-16-2017, 01:27 AM
  3. Replies: 3
    Last Post: 06-09-2016, 12:51 PM
  4. [SOLVED] Need to select earliest five rows matching highest value, and next highest if not enough
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-05-2016, 11:26 AM
  5. [SOLVED] Max formula to return total of highest, second highest and third highest value
    By JonWilf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-06-2016, 08:20 AM
  6. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  7. Replies: 3
    Last Post: 08-10-2006, 11:40 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