Autofill Mathematics Algorithm??

[Regal24]

Hi all

I am trying to find out whether it is capable in MS Excel to write an algorithm or some sort of VBA code whereby excel will fill in the "blanks" of a formula to give pre-determined results. Let me try to explain myself more clearly.

Say for example I had 2 equations.

Equation #1: (a + b)*c = d

Equation #2: (w - x)/y = z

Both answers must be above a certain value. This value will be pre-determined, so for this example lets say that value is 100.

Is there anyway of getting excel to fill in the "blanks" (in this example, a,b and c; and w, x and y) of the equations to make each answer above that of the pre-determined value (100 for example)?

Quite complex (to me anyway!) and hopefully I have explained as fully as possible.

Thanks for any help

Sam

 

[Joe4]

I don't know. The problem, as I see it, if you are not trying to solve for a single value. You have multiple unknowns, and your formulas aren't related to one another.
So the number of answers that will work are infinite. Not sure how you expect Excel to return an infinite number of solutions...

 

[Joe4]

There is a tool that Excel has called "Solver" that may be something like what you are looking for, but I think your problem still might be too general for it (too many unknowns?).
I can't say for sure, because I have never used it myself.

Here are a few links on it. There are others, if you do a Google search on "Excel Solver":
Introduction to optimization with the Excel Solver tool - Excel - Office.com
About Solver - Excel - Office.com

 

[hurgadion]

Hi,
describe, please, Your problem more precisely... Give us an extended example and a desired result... Best regards.

 

[shg]

For any pair of numbers {a,b}, a <> -b, there is a number c that satisfies (a+b)*c = 100, i.e., c=100/(a+b). So you could enter random values for a and b and solve for c. All values of c greater than that (in absolute value) fulfill the inequality. Similarly, you could choose random values for a and c or b and c and solve for the remaining variable.

Ditto, with a change of signs, for the second equations.