Thread: [Solved] Complex Number Arithmetics
View Single Post
 
Old 05-13-2013, 04:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The error is due to the fact that COMPLEX returns an imaginary number with (in this case) an 'i' suffix. In other words, it's a text string, not a number. You could try changing the formula to something that gets rid of the 'i'. For example:
=E4-G4/((E4*10^12*C4)*((10^12*C4)+SUBSTITUTE(COMPLEX(0,I4 ),"i","")))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote