cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Solve Function

SOLVED
Highlighted
Aquamarine

Solve Function

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

SPRstructur_0-1603257983839.png

2.Data Input (below function)

SPRstructur_1-1603258026879.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Solve Function

Would turning the solve block into a function help?

Werner_E_0-1603276444318.png

 

View solution in original post

4 REPLIES 4
Highlighted

Re: Solve Function

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:

LucMeekes_0-1603274903174.png

I hope that answer corresponds to your expectations.

 

Success!

Luc

Highlighted

Re: Solve Function

yes Meekes correct answer ,

but I need it as function also because in the future I need include/link to another file

Highlighted

Re: Solve Function

Would turning the solve block into a function help?

Werner_E_0-1603276444318.png

 

View solution in original post

Highlighted

Re: Solve Function

Great Werner_E

Announcements