MOD function behaving badly

Hi Sixthsense,

Thanks for the lightning fast reply

A test file is attached below. I have included a paste of the values only, just in case the problem is not replicated on your version/platform.

Oh and your initial solution is excellent, I have implemented it already and it works fine, shame it is necessary though...

Cheers,
MZG

MOD failing in many cases in your attached file

This is seems to be better approach...

In A2 Cell

Formula:

=B2-(INT(B2/C2)*C2)

Drag it down...