Forum Discussion
Keyur_Oza
May 09, 2022Copper Contributor
Solve Equation with Solver Function
Hi, I want to add cell which have a formula as a contsraint in Solver Function/tool.
Problem:
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)
Example:
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.
No RepliesBe the first to reply