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.
2007-12-09
00:45:10
·
2 answers
·
asked by
mambo
2