![]() ![]() I then saved this file as an XLS and XLSX for testing under MacOS 10.6.8 running Word Mac 2011. ![]() I can confirm the behaviour described in comment #2. XLS and screenshots showing behaviour under Excel Mac 2011 and LOv4132. > This seems to be about excel but the test file is a ods file? > file is opened in which format with which application. Could you post exact reproduce steps? Which So there is some problem with the convergence algorithm in this case. I made a small test file doing something similar and it ran Goal Seek fine, Macro to do this automatically, which I was intending to move to HoweverĮxcel does not have a problem withe this - In fact the excel file has a LibreOffice (like OpenOffice before it) does not find a solution. To set Formula cell D7, Target value = 0, Variable cell B6. Running goal see (Tools, Goal Seek)one would tell it To do this one runs goal seek (or makes many successiveĬhanges to cell B6). To calculate how much one can draw (cell B6) to reach the target at the Give the same problem when goal seek is run in LibreOffice. I think I initially submitted an xls file (RetirementCalc.xls), but I may > Please explain how to reproduce that problem, so others can easily test it. > What Removed Added Status UNCONFIRMED NEEDINFO Ever confirmed 1 The same spreadsheet loaded into Excel gets an answer no problem (3584) Set Formula Cell to $D$9 (should show that if you are on it)įor target Value set the amount shown in PV Required Balance 200000 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |