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
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
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))
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks