[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

IMPRODUCT

Syntax:

IMPRODUCT ( argument-list )

Description: Multiplies the values of its complex number arguments.

Mathematical Formula:

Arguments:

Name

Type

Description

argument-list

text

Each argument in argument-list is a complex number string in x + yi or x + yj text format.

 

Return Type and Value: text – A string containing the product of the values of its arguments, in x+yi or x+yj text format.

However, if any argument in argument-list is ill-formed, #NUM! is returned.

[Example:

IMPRODUCT("13+4i") results in 13+4i
IMPRODUCT("-3-3.5i","5+3i") results in -4.5-26.5i
IMPRODUCT("1.3-2j","-3.4+3j","2.3-6j") results in 67.834+15.13j

end example]