MROUND Formula for Ordering System

Good morning everyone,

I have ran into a bit of a conundrum and was hoping that you guys and gals could help me out.

I am using the following formula on an excel sheet I use for an ordering system at my workplace:

=IF((G2360-E2360)>0,MROUND((G2360-E2360),25),IF((G2360-E2360)<0,0)) (Simply using the IF function to work around the fact that MROUND doesn't like negative results)

In this example, if G = 900 and E = 899 I would like the result to become 25, because I need to order 25 pcs of this part once I get below my order point.

However, what will happen is if E =< 888 the result is 0, and if E => 887 the result is 25. (Basically, a difference of 12.5 or higher will round to 25, and a difference less than 12.5 will give me 0)

Is there anyway that I can work around this problem while still maintaining the G2360-E2360 format?

Any help would be greatly appreciated!

This ???

=IF((G20-E20)>0,MAX(MROUND((G20-E20),25),25),IF((G20-E20)<0,0))

Try


=IF((G20-E20)>0,(INT((G20-E20-1)/25)+1)*25,IF((G20-E20)<0,0,""))