4 ms·
The Goal Seek part was painful to watch. Why would rounding completely break that? And why would it end up at 9 billion?
by mooneater 10y ago
The Goal Seek part was painful to watch. Why would rounding completely break that? And why would it end up at 9 billion?
- princeb 10y agolike he said the rounding made 975000 an impossible result. if you have rounding or some kind of non-continuous function the right feature to use is actually Solver (which is an included add in you have to enable in Excel options) which provides you with an fmin function (or several) as opposed to goal seek's fzero.