Forum Discussion

KenH99's avatar
KenH99
Copper Contributor
Sep 22, 2023

Excel formula is stock sheet

Hi, I have a stock ordering sheet where the stock in hand is 4.25 and par stock is 5 order number is .75 round up to 1, however the order value is calculating at .75 not 1    
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 23, 2023

KenH99 

You mean this doesn't work for you (see picture below)?

 

  • KenH99's avatar
    KenH99
    Copper Contributor
    Sep 23, 2023

    Riny_van_Eekelen 

     

    Thanks of course it works!! I was using IF

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Sep 23, 2023

      KenH99 Just realized that you want to avoid a negative reorder qty if the qty on hand is larger than par.

      Then you may use: 

      =MAX(0,ROUNDUP(B2-A2,0))

      • KenH99's avatar
        KenH99
        Copper Contributor
        Sep 23, 2023
        Thats great thanks, i have a new issue when the on hand stock is 90 and the par stock is 96 but the re-order until is 24 how do i do that?

Resources