Menu
EXCEL IMPRODUCT FUNCTION
Excel IMPRODUCT Function Introduction
The Improduct function in Excel computes the product of two or more complicated integers.
Description of Excel IMPRODUCT Function
Syntax :
=IMPRODUCT( inumber1, inumber2, … )
Parameters :
- The inumber arguments are Complex Numbers ranging from 2 to 255 that you wish to calculate the product of.
Step By Step Guide of IMPRODUCT Function
Example :
The spreadsheets below demonstrate three uses of the Excel Improduct function:
The complex number 2+0i is identical to the integer 2 in cell B2; the example in cell B3 utilises the Excel Complex Function to generate the complex numbers 5+2i and i.
Key Points
- #NUM! – This error occurs if any of the given inumber parameters are not complex numbers.
- #VALUE! – Occurs if any of the inumber arguments given are logical values.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
