I. Intro
The IMLOG2 function returns the logarithm (base 2) of an imaginary coefficient.
II. About the function
- Formula: =IMLOG2(value)
- Parameters:
- Value (required): The complex number for which the logarithm (base 2) is applied.
- Example: =IMLOG2("100+10i")
III. Steps
Use the IMLOG2 function
- Select a cell and click Formulas on the toolbar, then select Engineering > IMLOG2. You can also directly enter =IMLOG2 in a cell.
- Enter the parameters in the cell. For example: =IMLOG2(A2).
- Press Enter to display the result. In this example, the result is 1.850219859070546+0.8483084401678749i.
- Drag the + icon in the lower-right corner of the cell to apply the formula to more cells as necessary.
250px|700px|reset
Delete the IMLOG2 function
Select the cell with the IMLOG2 function and press Delete.