Solve Equation with Solver Function

Copper Contributor

Hi, I want to add cell which have a formula as a contsraint in Solver Function/tool.


When i select cell as a constraint and proceed further steps for calculate equation it take it cell value and give answer but when i select cell have an formula value at that time excel not calculate equation. So, i think it is a problem.(may be)



When i select E4 cell and write value suppose 2 and i take E4 cell as a constraint. Now excel calculate equation by take 2 as a constraint and give eigen value answer.

But, If i write in E4 "=B2+2" Formula and take E4 cell as a constraint at that time excel not calulate equation.

So, Please give me the solution for my Query.  Thank You.1.png2.png

0 Replies