Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Oct 21, 2020
01:31 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Oct 21, 2020
01:31 AM

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

2.Data Input (below function)

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Oct 21, 2020
06:34 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Oct 21, 2020
06:34 AM

4 REPLIES 4

Oct 21, 2020
06:09 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Oct 21, 2020
06:09 AM

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:

I hope that answer corresponds to your expectations.

Success!

Luc

Oct 21, 2020
06:13 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Oct 21, 2020
06:13 AM

yes Meekes correct answer ,

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

Oct 21, 2020
06:34 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Oct 21, 2020
06:34 AM

Would turning the solve block into a function help?

Oct 21, 2020
06:39 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Oct 21, 2020
06:39 AM

Great Werner_E