![]() |
#1
|
|||
|
|||
![]()
Greetings,
I need to manipulate complex numbers for my physical modelling but I get the error value when I try the calculation. I have attached my workbook for clarity. |
#2
|
||||
|
||||
![]()
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] |
#3
|
|||
|
|||
![]()
Thanks, but wouldn't it cause the loss of information held in the imaginary part? That is very crucial.
|
#4
|
||||
|
||||
![]()
All the change I made does is to eliminate the 'i' so the imaginary number can be used as a number. Nothing except the 'i' is 'lost' - and you could add that back to the result if that's what you want, either via a custom number format or by adding &"i" to the formula.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
I tried it but could not get it to work, I think this is related with the argument of the substitute function.
|
![]() |
Tags |
complex number, excel 2010 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with Complex Table Creation | saquib | Word | 0 | 02-12-2013 06:28 AM |
![]() |
Elok | Word | 4 | 01-10-2013 08:28 AM |
![]() |
bekz | Mail Merge | 6 | 05-06-2012 07:10 PM |
![]() |
andrei | Excel | 9 | 02-03-2012 03:40 AM |
![]() |
paulkaye | Word | 1 | 11-13-2011 04:23 AM |