Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2013, 12:45 PM
Vesnog Vesnog is offline Complex Number Arithmetics Windows 7 64bit Complex Number Arithmetics Office 2010 32bit
Novice
Complex Number Arithmetics
 
Join Date: May 2013
Posts: 7
Vesnog is on a distinguished road
Post Complex Number Arithmetics

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
File Type: xlsx DrudeModel.xlsx (48.0 KB, 12 views)
Reply With Quote
  #2  
Old 05-13-2013, 04:49 PM
macropod's Avatar
macropod macropod is offline Complex Number Arithmetics Windows 7 64bit Complex Number Arithmetics Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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
  #3  
Old 05-13-2013, 05:08 PM
Vesnog Vesnog is offline Complex Number Arithmetics Windows 7 64bit Complex Number Arithmetics Office 2010 32bit
Novice
Complex Number Arithmetics
 
Join Date: May 2013
Posts: 7
Vesnog is on a distinguished road
Default

Thanks, but wouldn't it cause the loss of information held in the imaginary part? That is very crucial.
Reply With Quote
  #4  
Old 05-13-2013, 05:12 PM
macropod's Avatar
macropod macropod is offline Complex Number Arithmetics Windows 7 64bit Complex Number Arithmetics Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

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]
Reply With Quote
  #5  
Old 05-13-2013, 05:13 PM
Vesnog Vesnog is offline Complex Number Arithmetics Windows 7 64bit Complex Number Arithmetics Office 2010 32bit
Novice
Complex Number Arithmetics
 
Join Date: May 2013
Posts: 7
Vesnog is on a distinguished road
Default

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

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
Complex Number Arithmetics I need help for a complex projet at my job Elok Word 4 01-10-2013 08:28 AM
Complex Number Arithmetics Help with a complex mail merge bekz Mail Merge 6 05-06-2012 07:10 PM
Complex Number Arithmetics Complex array formula andrei Excel 9 02-03-2012 03:40 AM
Complex Number Arithmetics Complex Find and Replace paulkaye Word 1 11-13-2011 04:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft