To INt Mod Richard

P

paul

Your question leaves a little to be desired
We arent mind readers
INT
Rounds a number down to the nearest integer.
Syntax
INT(number)
Number is the real number you want to round down to an integer
MOD
Returns the remainder after number is divided by divisor. The result has the
same sign as divisor.
Syntax
MOD(number,divisor)
Number is the number for which you want to find the remainder.
Divisor is the number by which you want to divide number.
Remarks
If divisor is 0, MOD returns the #DIV/0! error value.
The MOD function can be expressed in terms of the INT function:
MOD(n, d) = n - d*INT(n/d)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MOD Function: MOD(7.0,1) = 1 Why? and how to work around it. 15
AddPicturesToShapes 0
INT and MOD 9
Nested Formula Giving Incorrect Answer 4
Mod Function 7
Windows startup 3
INT function 13
Mod function 7

Top