you could use QUOTIENT to discard the remainder after division.

To perform divisionwitha remainder, use thedivision operator"/".

To return only the remainder, use theMOD function.

Excel MOD function

QUOTIENT function takes two arguments,numeratoranddenominator.Numeratoris the number that should be divided, anddenominatoris the number to dividenumeratorby.

For example, MOD(10,3) = 1.

The result of MOD carries the same sign as the divisor.