Been too many years since algebra...

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,030
OK, I'm stumped... :banghead:

If I have:

m = ba<SUP>ec</SUP> + d


and I need to solve for e then I do:
  • m - d = ba<SUP>ec</SUP>
  • (m-d)/b = a<SUP>ec</SUP>
  • log<SUB>a</SUB>((m-d)/b) = ec
  • (log<SUB>a</SUB>((m-d)/b))/c = e
But what if I have:

k = e × m

where m is as above? i.e.

k = e × (ba<SUP>ec</SUP> + d)

Now how the dickens can I solve for e, i.e. figure out the value of e if all the other variables' values are known?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Hi Greg

Unless I'm mistaken, can't you start with :

k / e = (ba<SUP>ec</SUP> + d)

and then proceed as you did before?

i.e.
(k / e) - d = ba<SUP>ec </SUP>etc.

Andrew
 
Andrew that wouldn't leave e on it's own Greg needs e=..
Greg be careful with the notation your using log base e times e = 1. but I don't think the e your using is e.

For the answer I'm not sure either but i'm sure there is some wizz out there who can help.
 
Sorry - my bad. I didn't see the e repeated......
 
k = e × (ba<SUP>ec</SUP> + d)


is the "x" which is after the "e" a multiplication sign, or is it another variable?
 
k = me

where e = ((loga((m-d)/b))/c)

so you end up with the two following:

k/m = ((loga((m-d)/b))/c)
m = baec + d

=

k/baec + d = ((loga((m-d)/b))/c)

and solve it out from there
 
Andrew, yes it's the repetion both as a coeffient and as an exponent that's got me tripped up.

Ross, perhaps I'm missing your point? I know the values of k, a, b, c & d But I don't know e or m. I tried going down that path already and if there's a way through, I don't see it.

Nichclark - my bad, even though my original formulae have that variable as e, I should have forseen someone confusing it with e as in e=2.718282... or ln(e) = 1.

Testpoint, yes it's multiplication's × not a variable x; again my apology for the lack of clarity.

Let me re-type this using the classic x for the unknown and dot multiplier.

How does one solve the following for x?

  • k = x · (ba<SUP>xc</SUP> + d)
where k, a, b, c & d are known values?
 
I got as far as
  • (m-d)/(ba<sup>c</sup>)=ea<sup>e</sup>

And from what I can get out of the log laws, I don't think you can get the e by itself from here...
 
It's with good reason that you're struggling with this, Greg.... I don't think it can be done.

Consider that x + ln(x) = y cannot be solved for x, save for iterative processes for a known y.

This is what Goal Seek is for :-)
 
hatman, oaktree,

Thanks to both of you for taking a look and at least making this old boy feel a bit better about his quite rusty algebra skills.

...This is what Goal Seek is for...

Yeah, that was Plan B. I just wanted to make sure that there wasn't a direct route.

Thanks a bunch to everyone that spent a moment of his time on this one.
 

Forum statistics

Threads
1,222,684
Messages
6,167,628
Members
452,124
Latest member
lozdemr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top