Complicated MOD function that possibly might just be algebra..

Something like this? If so, formulas are:

If we want to use INT (which effectively rounds remedial down):

In C6:

In C7:

In C8:

In C9:

If we want to use ROUNDUP (to round remedial up to the next whole number):

In D6:

In D7:

In D8:

In D9:

Instead of repeating the calculations (from C7 or D7 down), you could reference the already-calculated cells.

/r/excel Thread