Syntax:
MODP(x, y)
Description:
Returns the remainder of the division of x by y, using the "PlanMaker method" (see annotation below).
Example:
MODP(5, 3) returns 2
MODP(5, 0) returns a #DIV/0! error value
MODP(5, -3) returns 2 (see below)
Annotation:
Microsoft Excel returns wrong results when you use the MOD function with a negative numerator or denominator.
If you want to get correct results, you should use the RESTP function described here instead of REST.
The following table shows the differences between MOD and MODP (the results highlighted in green color are wrong):
Compatibility notes:
Note: The MODP function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.
See also: