Excel: Goalseek in macro?

Question

i using Goalseek function in macro, it give me 'wrong' answer on what i supposed to get. sometimes it work OK, but sometime NOT. i notice this problem was effected by the Goal's value, as the closer the Goal's value i put, the best the answer i will get.
for example: in cell A1 i have a value = 10, in cell B1 formulae = A1/2, cell C1 formulae = 3*B1/4, I would like to seek C1 = 10, by changing A1 value, in my case i will get different answer in C1, which i supposed to get '10'. (note: this is only an example to express my problem, I having bite complicated formulae in cell B1 and C1).
does anyone has the same problem as mine? please advice.

Answer 1

According to the values you entered, you should get a value of 26.666...7 for A1 if you use the Goal Seek function. I worked out the formulas and came up with the same value as Goal Seek did for A1.

Go to Tools > Goal Seek...

Here's what you should the values to on the Goal Seek window that pops up:

Set cell: $C$1
To value: 10
By changing cell: $A$1

Then click OK.

If you are writing macro code, I can't really tell you what you are doing wrong without seeing an example of the macro code. The Goal Seek function worked perfectly fine for me.

Here's how it works out algebraically:

If you let A1 = x, then B1 = x/2, Then C1 = 3*(x/2)/4 = 3x/8 = 0.375x

If C1 = y = 3x/8 Then A1 = x = 8y/3

So if C1 = y = 10 Then A1 = 8 * 10 / 3 = 20.6667

Answer 2

Hit your interior of sight public library and check out an Excel learn handbook. on condition that probably you realize the form you would be expected to apply Excel interior the interest, concentration on those helpful components the place you're vulnerable - writing complicated formulation, linking worksheets or documents, writing macros... The library is the terrific for this manner of component with the aid of fact the internet provides you with a pair of million 0.5-@ss effects that isn't possibly teach you for loose.