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.
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.