Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

The Goal Seek part was painful to watch. Why would rounding completely break that? And why would it end up at 9 billion?


like 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: