Forum Discussion

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

Platinum Contributor

Sep 23, 2023

KenH99

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

KenH99

Copper Contributor

Sep 23, 2023

Riny_van_Eekelen

Thanks of course it works!! I was using IF

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
  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?
  - Riny_van_Eekelen
    Platinum Contributor
    Sep 23, 2023
    KenH99 Sorry but I don't understand "the re-order until is 24". If the re-order level is not equal to par, what is it?
    
    Perhaps
    =MAX(0,CEILING.MATH(B2-A2,24))