2.1.1046 Part 4 Section, 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.