Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Dear All
I am stuck here. I can not find any method to solve the solution of function like below, help me.
The goal of this sheet to find solution X and we have function and many variable. And variable will input below.
If you have any methods to solve this problem please.
Big thank.
1.Function
2.Data Input (below function)
Solved! Go to Solution.
Prime complains in the solve block, because x is undefined. That is correct. It is only defined after the solve block, not before. Note that Prime reads left to right, and top to bottom. And for a numeric solve block, ALL used variables MUST be defined beforehand.
The solution is simple. Move the solve block (out of the area) to a location below the definition of x (and all other variables). Then you get:
I hope that answer corresponds to your expectations.
Success!
Luc
yes Meekes correct answer ,
but I need it as function also because in the future I need include/link to another file
Would turning the solve block into a function help?
Great Werner_E