View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Improduct function

When I try to multiply the complex number by a fixed number the result comes
out to be

4.69452551984877E-002+0.121677051039698j
The formula looks like

=IMPRODUCT(Data!D13,(Data!D5/Data!D8)^2)

where Data!d3 is a complex number and Data!D5 and Data!D8 are numbers .

however so many ddecimal igits are not desired. Can we restrict the decimal
digits from the formula say 4 to 5.