#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 247
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to identify duplicate entries in a Table bman342 Excel Worksheet Functions 6 July 6th 06 09:33 AM
writing macros in excel sheet Richard Buttrey Excel Worksheet Functions 7 May 10th 06 01:04 AM
Need Help w/ VLookup Formatting Mike Lindsay Excel Worksheet Functions 10 May 5th 06 02:03 AM
Is there a function to consolidate multiple records into one recor Richmond Excel Worksheet Functions 4 October 10th 05 07:13 PM
graph dates revert to 1900 Richard Goh Charts and Charting in Excel 10 February 16th 05 02:39 PM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"