Problem with Goal Seek
For some reason, this feature has become unreliable recently (in the
last 3 to 4 days). When I use it I often get very large negative
numbers. I went back to old spreadsheets that I know worked at one
time and they don't work any more either. My associate thinks it's
because the value I'm trying to find is used within a rounding
function. While this may be a factor, I know I've used it successfully
in the past with the same equation. Any ideas out there? I know there
was an automatic MS update push in the last week but I haven't been
able to find out what was in it (wouldn't you think there will be an
automatically maintained log of updates? is there?).
Thanks.
|