Excel formula is stock sheet

Question

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&nbsp;&nbsp;

riny_van_eekelen · Answer

KenH99&nbsp;You mean this doesn't work for you (see picture below)?&nbsp;

kenh99 · Answer

Riny_van_Eekelen&nbsp;&nbsp;Thanks of course it works!! I was using IF

riny_van_eekelen · Answer

KenH99&nbsp;Just realized that you want to avoid a negative reorder qty if the qty on hand is larger than par.Then you may use:&nbsp;=MAX(0,ROUNDUP(B2-A2,0))

kenh99 · Answer

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 · Answer

KenH99&nbsp;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?&nbsp;Perhaps&nbsp;=MAX(0,CEILING.MATH(B2-A2,24))

Forum Discussion

Excel formula is stock sheet

7 Replies

Resources