Solver could not find a feasible solution when solution exists

[MrFuz]

I have 2 sets of simultaneous equations to solve using solver. When I try to get values of X and Y it says that there is no feasible solution when actual values of X and Y exist. Can someone help me use solver to find the values? I may have done something wrong.

2 Equations:
10^12 = x^2 * Y
2 = (3*Y)/X

I set 2 cells as variable cells (C8 for X, and C9 for Y) and used these cells for equations. =C8^2 * C9 and = 3*C9/C8. Then I set objective as the first equation (=C8^2*C9) and set value of 10^12. I then added a constraint which was the second equation (=3*C9/C8) and set that equal to 2. Then I pressed solve and excel says there are no feasible solutions

 

[SanjayGMusafir]

I may have done something wrong.

Solver can only solve for 1 variable.

So use substitution method for one variable and make a fresh equation to solve.

Let me see if I can demonstrate it for you using XL2BB

 

[SanjayGMusafir]

Check as below and revert -

Book1
	A	B	C	D	E
1	10^12 = x^2 * Y		X =	0
2	2 = (3*Y)/X		Y=2X/3	0
3	This implies
4	2X=3Y
5	Y=2X/3
6	Now,
7	10^12 = x^2 * Y
8	10^12 = x^2 * (2X/3)
9	0	1E+12
10	Find Value of Cell A9 using Goal seek by Changing Cell D1
11	Since I use Excel 2021 cant find value of 10^12
12	But it is possible in Excel 365
Sheet1

Cell Formulas
Range	Formula
D2	D2	=2*D1/3
A9	A9	=D1^2*(2*D1/3)
B9	B9	=10^12

 

[MrFuz]

Check as below and revert -

View attachment 102489

Book1
	A	B	C	D	E
1	10^12 = x^2 * Y		X =	0
2	2 = (3*Y)/X		Y=2X/3	0
3	This implies
4	2X=3Y
5	Y=2X/3
6	Now,
7	10^12 = x^2 * Y
8	10^12 = x^2 * (2X/3)
9	0	1E+12
10	Find Value of Cell A9 using Goal seek by Changing Cell D1
11	Since I use Excel 2021 cant find value of 10^12
12	But it is possible in Excel 365
Sheet1

Cell Formulas
Range	Formula
D2	D2	=2*D1/3
A9	A9	=D1^2*(2*D1/3)
B9	B9	=10^12

Thanks for the response, but I need to use the solver add-in not goal seek. solver can solve for 2 variables as I have done it before with different equations but for some reason with thsee equation it doesn’t work.

 

[SanjayGMusafir]

I need to use the solver add-in

Still you can only find value of 1 variable at a time...

Hope someone better than me is able to help you out.

 

[MrFuz]

Still you can only find value of 1 variable at a time...

Hope someone better than me is able to help you out.

Maybe I am misunderstanding you. What do you mean by it can only find the value of 1 variable.

 

[Fluff]

Duplicate to: Solver could not find a feasible solution

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.