The INT() function truncates a decimal number down to it's integer part (i.e.
=INT(9.9 will return 9)
This doesn't sound like the function you want to use if you're looking for
remainders. Try using MOD()
--
Regards,
Dave
"Dan (WA)" wrote:
I need the remainder results of a multiplication formula. The Function INT
should provide this results -- Excel Function Help for INT provide the
formula =A2-INT . I have tried this sever times but the results is alway the
same #Name... Is excel broken or what am i missing?
|