Miltiple if and roundup question

[brazill23]

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

 

[AlanY]

just add a max() like this

=max(500,[your formula here])