ExcelBanter - Excel Solver: How do I limit the contents of a cell to 1=True or 0

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel Solver: How do I limit the contents of a cell to 1=True or 0 (https://www.excelbanter.com/new-users-excel/12093-excel-solver-how-do-i-limit-contents-cell-1%3Dtrue-0-a.html)

Brian Patrick Gilbert

Excel Solver: How do I limit the contents of a cell to 1=True or 0

I want solver to indicate that something should be allocated by putting True
or False in a Cell but it is sometimes putting extremely small number there.

All times are GMT +1. The time now is 03:27 PM.