+ Reply to Thread
Results 1 to 6 of 6

Solving Complex formula w/ Exponential & Exponential w/ Imaginary number

  1. #1
    Registered User
    Join Date
    07-03-2020
    Location
    NC
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Thumbs up Solving Complex formula w/ Exponential & Exponential w/ Imaginary number

    Can someone help me setup the attached formula in excel, I have attached the spreadsheet? I have Microsoft office 365. I can easily solve the equation in MathCad, but it's difficult to setup in Excel. The equation is unit-less since the units cancel one-another.

    alpha =sqrt(R/S)*exp(-Beta*Omega*S/Vs)*imexp(-i*omega*S/Vs)

    for S = 8
    answer is -0.2369 + 0.1721i

    for S = 10
    answer is 0.2498i

    Thanks
    Last edited by x5bulldog; 07-04-2020 at 08:32 AM. Reason: SOLVED

  2. #2
    Valued Forum Contributor Hydraulics's Avatar
    Join Date
    07-15-2018
    Location
    Udine - Italy
    MS-Off Ver
    Office 365
    Posts
    369

    Re: Solving Complex formula w/ Exponential & Exponential w/ Imaginary number

    Complex numbers can be tricky, there are specific functions for algebraic operations with them.
    First you must enable Analysis toolpack under Add-ins.

    Then in C17 and C19 you can use the following

    =IMDIV(IMPRODUCT(C10,C8,COMPLEX(0,-1)),C11)

    =IMPRODUCT(C15,EXP(C16),IMEXP(C17))

    HTH,

    Francesco
    Last edited by Hydraulics; 07-03-2020 at 06:41 PM.
    Aim high or don't even try.
    ---------------------------------
    If your question has been answered, don't forget to mark the thread as SOLVED.
    If you find an answer helpful, click on the star icon at the bottom of the post.

  3. #3
    Registered User
    Join Date
    07-03-2020
    Location
    NC
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Solving Complex formula w/ Exponential & Exponential w/ Imaginary number

    Thanks Hydraulics! Works well. Quick question, how can I round the real and imaginary part to show 4 decimal places ,each? I have inserted the round function in several locations within the equation, but I keep receiving the #VALUE! Error.

  4. #4
    Registered User
    Join Date
    07-03-2020
    Location
    NC
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Solving Complex formula w/ Exponential & Exponential w/ Imaginary number

    Hydraulic, Thanks! See my additional question down below. I was able to round the 4 decimals, but I had to break the results with:

    =IMREAL(C19)
    =IMAGINARY(C19)

    =COMPLEX(ROUND(C21,4),ROUND(C22,4))

    I want to round in cell C19 and minimize breaking into parts.

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Solving Complex formula w/ Exponential & Exponential w/ Imaginary number

    Excel cell's can contain either text or double -- they cannot recognize a "complex number" data type. In these complex number formulas, the complex number is input/output as a text string, so Excel cannot apply number formatting to it. At some level, what you are doing (break the complex number up into real and imaginary parts -> format/round those numbers -> recombine into a complex number text string) is the only way to do it (at least that I am aware of).

    If you don't like spreading that out over several cells, then it should be possible to combine/nest formulas into a single cell (probably with duplicated effort, but I would not expect these calculations to be slow so the duplicated effort should not impair performance too much).

    I would ask at this point -- what is your concern with breaking the number up, formatting, and recombining that you are currently doing?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Registered User
    Join Date
    07-03-2020
    Location
    NC
    MS-Off Ver
    Microsoft 365
    Posts
    4
    Thanks a bunch!. I'll tag it solved.

    I was hesitant to split the parts and recombine the complex equation , because this is the 1st step to build several matrices. However, it should be no big deal.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formatting an Exponential Number
    By bryanr72 in forum Excel General
    Replies: 3
    Last Post: 07-15-2015, 11:52 AM
  2. Solving for an exponential variable (x) of e
    By seanvalenzuela in forum Excel General
    Replies: 3
    Last Post: 03-23-2012, 02:10 PM
  3. Solving exponential
    By DRFLETT in forum Excel General
    Replies: 4
    Last Post: 11-17-2011, 12:36 AM
  4. Exponential Number to Text
    By RichHartmann in forum Excel General
    Replies: 1
    Last Post: 11-08-2006, 05:38 PM
  5. alpha field getting turned into an exponential number
    By dkellison in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2006, 03:10 AM
  6. [SOLVED] alpha field getting turned into an exponential number
    By dkellison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2006, 01:30 PM
  7. Replies: 0
    Last Post: 06-20-2006, 03:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1