Solve Equation with Solver Function

%3CLINGO-SUB%20id%3D%22lingo-sub-3343420%22%20slang%3D%22en-US%22%3ESolve%20Equation%20with%20Solver%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3343420%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20want%20to%20add%20cell%20which%20have%20a%20formula%20as%20a%20contsraint%20in%20Solver%20Function%2Ftool.%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EWhen%20i%20select%20cell%20as%20a%20constraint%20and%20proceed%20further%20steps%20for%20calculate%20equation%20it%20take%20it%20cell%20value%20and%20give%20answer%20but%20when%20i%20select%20cell%20have%20an%20formula%20value%20at%20that%20time%20excel%20not%20calculate%20equation.%20So%2C%20i%20think%20it%20is%20a%20problem.(may%20be)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EExample%3A%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EWhen%20i%20select%20E4%20cell%20and%20write%20value%20suppose%202%20and%20i%20take%20E4%20cell%20as%20a%20constraint.%20Now%20excel%20calculate%20equation%20by%20take%202%20as%20a%20constraint%20and%20give%20eigen%20value%20answer.%3C%2FP%3E%3CP%3EBut%2C%20If%20i%20write%20in%20E4%20%3CSTRONG%3E%22%3DB2%2B2%22%20%3C%2FSTRONG%3EFormula%20and%20take%20E4%20cell%20as%20a%20constraint%20at%20that%20time%20excel%20not%20calulate%20equation.%3C%2FP%3E%3CP%3ESo%2C%20Please%20give%20me%20the%20solution%20for%20my%20Query.%26nbsp%3B%20Thank%20You.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370187i76255F0667C6DD9C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.png%22%20alt%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222.png%22%20style%3D%22width%3A%20562px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370186iEB41319C7834D1F8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222.png%22%20alt%3D%222.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3343420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.1.png2.png

0 Replies