Skip to main content
S
SPRstructur15-Moonstone
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

L
LucMeekes23-Emerald IV
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

    S
    SPRstructur15-MoonstoneAuthor
    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

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

    Would turning the solve block into a function help?

    Werner_E_0-1603276444318.png

     

      S
      SPRstructur15-MoonstoneAuthor
      15-Moonstone
      October 21, 2020

      Great Werner_E

      Terms & ConditionsAccessibility statement