Export (0) Print
Expand All
Expand Minimize

2.1.1005 Part 4 Section 3.17.7.171, IPMT

a. The standard states that payment type is truncated to integer.

Office does not truncate payment type to integer.

b. The standard states that argument type is either 0 or 1.

In Office, any nonzero value of argument type is equivalent to 1.

c. The standard states that if argument type is not 0 or 1, #NUM! is returned.

In Office argument type is a value of any number.

d. The standard states that argument per shall be in the range 1-nper.

In Office argument per shall be in the range 1 ≤ per < nper+1.

e. The standard does not define the error case if argument per is not in the range 1 ≤ per < nper+1.

In Office if argument per is not in the range 1 ≤ per < nper+1, then #NUM! is returned.

f. The standard does not specify the value of argument type if omitted.

In Office if the argument type is omitted the argument type has a value of 0.

Show:
© 2014 Microsoft