2.1.967 Part 1 Section 18.17.7.156, IMLN

  • Article

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:

Formula for imln: natural log open parentheses x + yi closed parentheses = natural log open parentheses square root x squared + y squared closed parentheses plus i theta

where:

θ = ATAN2(x,y) calculated according to the formula in ATAN2 ("[ISO/IEC-29500-1] §18.17.7.15; ATAN2")Formula for ATAN2: theta contains open parentheses minus pie; pie closed bracket