|
|
#2
05-13-2013, 04:49 PM
|
||||
|
||||
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] 
|
| Tags |
| complex number, excel 2010 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with Complex Table Creation | saquib | Word | 0 | 02-12-2013 06:28 AM |
 I need help for a complex projet at my job
|
Elok | Word | 4 | 01-10-2013 08:28 AM |
|
Help with a complex mail merge
|
bekz | Mail Merge | 6 | 05-06-2012 07:10 PM |
|
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |
|
Complex Find and Replace
|
paulkaye | Word | 1 | 11-13-2011 04:23 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode