2.1.1025 Part 1 Section 18.17.7.263, PV
a. 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.
b. The standard states that the argument type is truncated to an integer.
-
Office does not truncate the argument type to an integer.
c. The standard states that if the argument type is any number other than 0 or 1, #NUM! is returned.
-
Office allows the value for argument type to be omitted or nonzero.