Hi All,
I have formula with calculating order and after round in up to nearest 100. I have issue with one additional argument - if result is bigger then 0 but smaller then 500 round up to 500. As my minimum order is 500 after this its just 500+100 ect... any suggestions ?
=IF(AD107="Order",ROUNDUP(IF((SUM(OFFSET(O104,0,0,1,AB106))-O105)<0,0,(SUM(OFFSET(O104,0,0,1,AB106))-O105)),-2),0)
Thank you in advance
I have formula with calculating order and after round in up to nearest 100. I have issue with one additional argument - if result is bigger then 0 but smaller then 500 round up to 500. As my minimum order is 500 after this its just 500+100 ect... any suggestions ?
=IF(AD107="Order",ROUNDUP(IF((SUM(OFFSET(O104,0,0,1,AB106))-O105)<0,0,(SUM(OFFSET(O104,0,0,1,AB106))-O105)),-2),0)
Thank you in advance