Sunday, 18 November 2012

Microsoft Excel MOD Function

MS Excel MOD Function:
MOD Function Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
Syntax:
MOD(Number, Divisor)

Example:

NUMBER
Divisor
MOD Function
Result
100
30
 =MOD(A2,B2)
10
100
11
 =MOD(A3,B3)
1
272
30
 =MOD(A4,B4)
2

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts