Results 1 to 6 of 6

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

Threaded View

  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

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. [SOLVED] 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. [SOLVED] Automatically solving for X or Y intercept on a log or exponential graph.
    By jed.needle@gmail.com in forum Excel Programming / VBA / Macros
    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