I. Intro
The IMPRODUCT function returns the product of two or more complex numbers.
II. About the function
- Formula: =IMPRODUCT(multiplier1,[multiplier2,...])
- Parameters:
- multiplier1 (required): The first complex number or range to be multiplied.
- multiplier2 (optional): Another complex number or range used to be multiplied.
- Example: =IMPRODUCT(A2:A100,"4+3i")
- Note: The mathematical formula for multiplying complex numbers is (a+bi) (c+di) = (ac-bd) +(ad+bc)i. IMPRODUCT can be used to automatically calculate the result of this function in a table.
III. Steps
Use the IMPRODUCT function
- Select a cell and click Formulas on the toolbar, then select Engineering > IMPRODUCT. You can also directly enter =IMPRODUCT in a cell.
- Enter the parameters in the cell. For example: =IMPRODUCT(A2:A8).
- Press Enter to get the result, which is -1508-48256i in this example.
250px|700px|reset
Delete the IMPRODUCT function
Select the cell with the IMPRODUCT function and press Delete.