A to Z of Excel Functions: the IMLOG10 Function
12 October 2020
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the IMLOG10 function.
The IMLOG10 function
An imaginary number is a complex number that can be written as a real number multiplied by the imaginary unit i (sometimes denoted j) which is defined by its property i2 = −1. In general, the square of an imaginary number bi is −b2. For example, 9i is an imaginary number, and its square is −81. Zero is considered to be both real and imaginary.
An imaginary number bi can be added to a real number a to form a complex number of the form a + bi, where the real numbers a and b are called, respectively, the real part and the imaginary part of the complex number.
Sometimes you might wish to calculate the common logarithm of a complex number in base 10. The common logarithm (base 10) of a complex number may be calculated from the natural logarithm:
IMLOG10 returns the common logarithm (base 10) of a complex number that is in the x + yi or x + yj text format. The function employs the following syntax to operate:
The IMLOG10 function has the following argument:
- inumber: this is required and represents the complex number for which you wish to calculate the common logarithm (base 10).
It should be further noted that:
- you should use COMPLEX to convert real and imaginary coefficients into a complex number
- IMLOG10 recognises either the i or j notation
- if inumber is a value that is not in the x + yi or x + yj text format, IMLOG10 returns the #NUM! error value
- if inumber is a logical value, IMLOG10 returns the #VALUE! error value
- if the complex number ends in +i or -i (or j), i.e. there is no coefficient between the operator and the imaginary unit, there must be no space, otherwise IMLOG10 will return an #NUM! error.
Please see my example below: