Formula Error

alaomair · Oct 25, 2008

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

Gary''s Student · Oct 25, 2008

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

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

Bernard Liengme · Oct 25, 2008

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

formula error	2	Oct 25, 2008
mod equation	19	Oct 25, 2008
Copy text	1	Nov 15, 2011
An oddity if not a bug	21	Jul 14, 2006
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ?	5	Jul 28, 2014
Excel Repeating a RAND() function under certain conditions	0	Dec 5, 2017
formula and delete sheet	3	Nov 22, 2009
bit-tech Mod of the Year 2017	0	Dec 13, 2017

Ask a Question