IMPRODUCT function for Sheets

1 min read
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
  1. Select a cell and click Formulas on the toolbar, then select Engineering > IMPRODUCT. You can also directly enter =IMPRODUCT in a cell.
  1. Enter the parameters in the cell. For example: =IMPRODUCT(A2:A8).
  1. 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.
Written by: Feishu Help Center
Updated on 2022/10/12
Was this content helpful?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom