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

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

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