2.1.1047 Part 4 Section 3.17.7.253, PPMT
a. The standard states that the type argument is truncated to an integer.
-
Office does not truncate the type argument to an integer.
b. The standard does not specify a default for the optional argument type.
-
In Office, if the value for type is omitted it defaults to value of 0.
c. The standard states that the argument type can only be 0 or 1.
-
Office allows the value for argument type to be omitted or nonzero.
d. The standard does not place any restrictions on the per argument.
-
In Excel, if the per argument is less than 1 or greater than the nper argument, #NUM! is returned.