Export (0) Print
Expand All
Expand Minimize

2.1.959 Part 1 Section 18.17.7.156, IMLN

a. The standard does not specify what happens if complex-number is zero.

Office returns #NUM! if complex-number is zero.

b. The standard does not fully specify how the angle θ is calculated.

Excel calculates imln using the following mathematical formula:

Ff533816.a7d9cc51-62ab-4853-9575-dea5ecc086ea(en-us,office.12).jpg

where:

θ = ATAN2(x,y) calculated according to the formula in ATAN2 ("[ISO/IEC-29500-1] §18.17.7.15; ATAN2")Ff533816.89ae1999-05aa-4dcc-95e7-23852dd57192(en-us,office.12).jpg

Show:
© 2014 Microsoft