ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scenario returns wrong values (https://www.excelbanter.com/excel-discussion-misc-queries/163162-scenario-returns-wrong-values.html)

Maurice

Scenario returns wrong values
 
Hi,

specs: Office 2003 & WinXP

When I choose [Solver] to calculate some values within the sheet all works
well. When I save the values within a scenario the scenario returns wrong
values when displayed. Example:

Originally found values: 66,666667
Scenario returns : 66.666.667

I know there's a bug bugging me but what could be a workaround for this
problem? Is this regional dependent? (Using dutch version which uses Euro so
you would write: 1.000,00 for one thousand an 9,00 for nine euros).

any help appreciated

p.s. also posted in dutch NG
--
Maurice Ausum


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com