ROUNDUP inside an IF formula

[MrQuestion]

=IF(C13<=B3*D3,"IN STOCK","BACKORDER"),IF(B3*D3/C13>=1,"IN STOCK ",ROUNDUP(B3*D3/C13,0))

Can someone tell me what is wrong with this formula? The first part works, but when I combine a second if function it doesn't work. It gives me a value error.

This is what was assigned to me.

• A number.
  This means we do not have enough on-hand in our inventory, but we can get it in time. And, we need this many boxes from our supplier.
  Let's look at the glue rows. The order requests 40 glue sticks but we have only 36 in stock. It takes 1 day for us to get more from our supplier and we have 2 days to fill the order. So we have time to get this item in stock and fulfill the order, and we need 1 box of glue sticks to do it. You may want to use the =ROUNDUP function here.

 

[Michael M]

Excellent.........would you like to share your final formula ??

 

[MrQuestion]

Excellent.........would you like to share your final formula ??

Sure

=IF(C14<=B4*D4,"IN STOCK",IF(E4>E14,"BACK ORDER",ROUNDUP((B4*D4)/C14,0)))

 

[Ashik Ahmed]

Hi! need your help to explain this roundup function. Blue text area is okay. Not understand next syntax properly . Thank you.
Here M8=26000 , K8= 4, I8 = 18

=IF(M8<=5000,20*K8+(M8/I8),IF(((ROUNDUP(M8/I8/25000,0))*20)>50,50,(ROUNDUP(((M8-5000)/I8)/25000,0)*20))*K8+(M8/I8))