Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To INt Mod Richard
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) -- paul remove nospam for email addy! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to identify duplicate entries in a Table | Excel Worksheet Functions | |||
writing macros in excel sheet | Excel Worksheet Functions | |||
Need Help w/ VLookup Formatting | Excel Worksheet Functions | |||
Is there a function to consolidate multiple records into one recor | Excel Worksheet Functions | |||
graph dates revert to 1900 | Charts and Charting in Excel |