goal seek wont calculate an accurate value past 3 decimal places

J

Joe Browning

I have a traditional situation in which to use goal seek. I need the value in
one cell to equal a certain value by changing another cell. But the value I
want it to go to is very small like 0.04459. So when I click calculate goal
seek gets the first 3 decimal places correct, but the remaining ones are off.
So does goal seek not calculate past 3 decimal places or am I doing something
wrong? Any help would be appreciated. Thanks.
Joe
 
M

Michael

Hi Joe
Check column widths for starters and then have a look at cell formatting for
number of decimal places.
Mine works fine, Office 2000

HTH
Michael
 

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

Goal Seek with variable Set Cell 1
Help understanding Goal Seek Calculation 3
Problem with Goalseek Macro 5
Goal seek - column reference 3
Rounded Result with Goal Seek 7
Goal Seek with Complex Numbers 2
How to use goal seek on column 4
Goal Seek using Time 2

Top