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

Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.

Solve Function

SPRstructur
15-Moonstone

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

Would turning the solve block into a function help?

Werner_E_0-1603276444318.png

 

View solution in original post

4 REPLIES 4
LucMeekes
23-Emerald III
(To:SPRstructur)

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

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?

Werner_E_0-1603276444318.png

 

SPRstructur
15-Moonstone
(To:Werner_E)

Great Werner_E

Top Tags