+ Reply to Thread
Results 1 to 4 of 4

Help with math equation in Excell

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help with math equation in Excell

    Hi guys i'm a newcomer to the forum. Really usefull information. I hit a roadblock trying to solve a math equation in Excell. Can you please help me solve it. Thank you beforehand. The equation is :

    3x + ln^3x
    _________
    4+3√x^5

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Help with math equation in Excell

    assuming In^3x is the inverse natural log of 3x,


    something like:

    if a1 = x

    in b1 enter the following formula

    =(a1*3 + exp(3*a1)) / (4 + 3 * sqrt(a1^5))

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Help with math equation in Excell

    Hi,

    Excel has a Ln Function. That means the Natural Log. Or instead of Log with base of 10 it is the Log with base of e. I think you need to change your equation from:'
    =(a1*3 + exp(3*a1)) / (4 + 3 * sqrt(a1^5)) to
    =(a1*3 + Ln(3*a1)) / (4 + 3 * sqrt(a1^5))

    Also - Solving as you requested needs an equal sign somewhere in the question. Do you want to find roots of your equation or just simplify it? Roots would be setting it to a variable of Y and graphing it. Where the graph crossed the x axis would be the root(s), if any.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Help with math equation in Excell

    Hi,

    If you want VBA:

    y=3*x+exp(3*x)/(4+3*Sqr(x^5))
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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