Goal Seek error?? 2007

L

LewCousineau

Put 35000 in cell A1. Put 50000 in cell A2. In A3 put =A1/A2. It
should equal .7. Now do a goal seek and set cell A3 = to .35. Cell
A2 should go to 100,000. It doesn't . It equals 99956.92994 and the
goal cell equals .35015


Am I doing something wrong or is this an error in Excel 2007. It
seems to do it with other goal values as well (.38, or . 40)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help understanding Goal Seek Calculation 3
Goal Seek with Complex Numbers 2
Goal Seek Advice 2
Button to do goal seek 4
Goal Seek 4
Goal Seek 0
vba goal seek in 07 envoking sumcolor UDF 0
Goal Seek using Time 2

Top