Skip to main content
15-Moonstone
October 21, 2020
Solved

Solve Function

  • October 21, 2020
  • 2 replies
  • 2850 views

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

 

 

Best answer by Werner_E

Would turning the solve block into a function help?

Werner_E_0-1603276444318.png

 

2 replies

23-Emerald IV
October 21, 2020

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

15-Moonstone
October 21, 2020

yes Meekes correct answer ,

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

Werner_E25-Diamond IAnswer
25-Diamond I
October 21, 2020

Would turning the solve block into a function help?

Werner_E_0-1603276444318.png

 

15-Moonstone
October 21, 2020

Great Werner_E