How to solve a complex exponential equation with one unknown???

I need to solve this equation for 'B'. I am having trouble rearranging the equation to achieve a 'B=' answer. Can someone help me rearrange this equation to solve for B?

**0****=((DCR****Mg***) - (DCR**MgAl**)) ***∗ e^(-B∗((ρ****Mg****)+(ρ****Al****)****))+ ***((DCR**MgAl** )- (DCR**Al ***))∗****e^(-2∗B∗(ρ****Mg****))+****((DCR***Al**) - (DCR**Mg**)) ***∗****e^(-B∗****((****ρ****Mg****)****+****(****ρ****MgAl****))****)**

Re: How to solve a complex exponential equation with one unknown???

replacing various constants with single letters, this is

where , , , and .

If we further write that equation reduces to which can be solved for y using the quadratic formula. Once we have , and then .

Re: How to solve a complex exponential equation with one unknown???

Thank you for your help HallsofIvy. Could you possibly re-write the equation as 'B=.......' I am struggling with this....

'

Re: How to solve a complex exponential equation with one unknown???

I have been recently told that this equation must be solved using Excel Solver. I have no idea how to use this program in order to calculate B.

I have created an excel formula relative to the above equation, but I am stuck at this point. Are you able to show me how you would solve the equation for B in Excel Solver?

=(B50-C50)*EXP(-B*($H$44+$I$44))+(C50-D50)*EXP((-2*B($H$44)))+(D50-B50)*EXP((-B($H$44+$J$44)))

Re: How to solve a complex exponential equation with one unknown???

You can use exact solutions given here in your Excel module.

Re: How to solve a complex exponential equation with one unknown???