+ Reply to Thread
Results 1 to 14 of 14

Formula calculation stock

  1. #1
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Question Formula calculation stock

    To all masters,

    Please help me to make the formula in columns E, F AND G which I marked yellow. I ask for 2 solutions for the first and second processes. Please help and thank you

    Thanks

    Roykana
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,066

    Re: Formula calculation stock

    how do you get to 30 and 35? what is the reasoning?

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,066

    Re: Formula calculation stock

    Perhaps j4 is =SUMIF($C$4:$C$11,I4,$E$4:$E$11)

    as it equals 30 but you have not explained why!

    and j5 is
    Perhaps j4 is =SUMIF($C$4:$C$11,I5,$E$4:$E$11)

  4. #4
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48
    Quote Originally Posted by davsth View Post
    how do you get to 30 and 35? what is the reasoning?
    It is total quantity for each product A & B

  5. #5
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48
    Quote Originally Posted by roykana View Post
    It is total quantity for each product A & B
    Quantity available of stock

  6. #6
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,066

    Re: Formula calculation stock

    and available stock is defined as?

  7. #7
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Formula calculation stock

    So in columns j4 and j5 are the quantity of stock available and in columns e, f, g then it is used as an analysis of the order quantity with the existing stock assessments.
    So I want the yellow markings to use a formula so I don't need a manual.

    Thanks
    Roykana

  8. #8
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Formula calculation stock

    Dear all master,

    Please help me

    Thanks

    Roykana

  9. #9
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Formula calculation stock

    Dear all master,

    Please help me

    Thanks

    Roykana

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,675

    Re: Formula calculation stock

    You still haven't told us exactly how you have mentally calculated the quantity on hand of 30 x A and 35 x B.

    Explain EXACTLY how you mentally calculate 30 in cell J. Until you do this, nobody can help.
    Last edited by AliGW; 02-20-2020 at 10:15 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  11. #11
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Question Re: Formula calculation stock

    In columns j4 and j5 are the last amount of stock that I marked green.
    So that was the result of the last stock on 10-02-2020.

    Please Help me

    Thanks

    kana
    Attached Files Attached Files
    Last edited by AliGW; 02-20-2020 at 10:20 AM. Reason: Please don't quote unnecessarily!

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,675

    Re: Formula calculation stock

    I cannot help you until you give the information I need.

    There are no entries for that date, so why should the results be 30 and 35 respectively? And how wis Excel meant to know about that date?

  13. #13
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Formula calculation stock

    I want to monitor the number of orders from the last stock so that I can determine which items can be sold and can also be produced. So I want the formula in columns e, f, g that I marked yellow by taking the last stock from columns j4 & j5 that I marked green

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,675

    Re: Formula calculation stock

    No, sorry - you aren't making this clear at all. Sorry - I can't help unless you tell me how you are calculating those values. I cannot see what your logic is.

+ 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] Planned stock expiry calculation
    By ABSTRAKTUS in forum Excel General
    Replies: 6
    Last Post: 09-28-2018, 12:48 AM
  2. How to set up formula on stock order by respective the stock cover day
    By leakhna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2016, 06:25 AM
  3. Replies: 31
    Last Post: 10-28-2015, 01:54 AM
  4. Stock Calculation
    By Aland2929 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-22-2013, 03:14 AM
  5. Stock register, calculation mechanic.
    By maana in forum Excel General
    Replies: 3
    Last Post: 10-14-2012, 03:22 PM
  6. stock calculation
    By kooty in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2012, 05:28 AM
  7. Total stock calculation query
    By Ramzes in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-27-2011, 05:16 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