| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solver bug - Won't return Integer
Does anyone know if there is a bug in the English Version of Excel
2002. no matter what I do, I can't get calculation to an integer using solver. I've got the constraints set for it, but it just won't do it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Solver bug - Won't return Integer
Visit www.solver.com for an excellent tutorial
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "GeoJack" wrote in message ups.com... Does anyone know if there is a bug in the English Version of Excel 2002. no matter what I do, I can't get calculation to an integer using solver. I've got the constraints set for it, but it just won't do it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Solver bug - Won't return Integer
Thanx Bernard But that doesn't answer the question. And Solver.com doesn't either. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Solver bug - Won't return Integer
Ron
The cells that are required to be an Integer are set with the =int constraint. Instead of getting an integer, I get answers like 5.0237 etc Microsoft have an article (and fix) in their knowledge base on this issue with the German & Polish versions, but I can't find info ANYWHERE on the English version having this problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| Visual Basic macro run time error(13) type mismatch | Excel Discussion (Misc queries) | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Using Solver with VBA | Excel Discussion (Misc queries) | |||
| Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
Linear Mode
