Formula Error

[alaomair]

mod(12,2.4) will not return a zero value

 

[Gary''s Student]

This is simple roundoff error. If it is not acceptable then use:

=12-2.4*(INT(12/2.4))

 

[Bernard Liengme]

Try =ROUND(mod(12,2.4),10) or nay number of decimals less than 15