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.

Attached Files

DrudeModel.xlsx (48.0 KB, 12 views)

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]

Thanks, but wouldn't it cause the loss of information held in the imaginary part? That is very crucial.

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]

I tried it but could not get it to work, I think this is related with the argument of the substitute function.