Help in Goal Seek

[bines53]

Hello everyone !

How do I build this system of equations in Goal Seek :

x*y=0.0547
ln(x)+ln(y)=-2.9066

Thank you !

 

[Somendra Misra]

Hi,

Well You question is bit confusing to me, and I will explain why?

ln(x)+ln(y) can be written as ln(x*y)
Now, x*y = 0.0547
Substituting this in ln(0.0547) will be equal to -2.905891.

So from this there are two direct solution.
x=1; y=0.0547
x=0.0547; y =1

Now what exactly are you looking at?

Regards,

 

[bines53]

Hi Somendra ,

I need to get the result
X= 0.40639
Y=0.13451

I need to avoid the result of one

Thank you!

 

[Somendra Misra]

@bines53

I am bit confused as both the equation are forming a circular system. And more over you want two unknown's. Goal Seek can be worked on 1 variable. May be you should find some other equation.

Regards,