Wednesday 26 April 2017

Excel - Microsoft Excel MOD Function

Description

The Excel MOD function returns the remainder of a division between two supplied numbers. 

The format of the function is : 

MOD( number, divisor ) 


where the arguments are as follows: 


These arguments can be supplied to the function either as simple numbers, as references to cells containing numbers, or as values returned from other functions. This is shown in the examples below. 

Excel Mod Function Examples
The following spreadsheets show simple examples of the Excel Mod function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 

No comments:

Post a Comment