Boolean 0/1 instead of True/False

Giganews Newsgroups
Subject: Boolean 0/1 instead of True/False
Posted by:  Tony
Date: Sun, 28 May 2006

I am using Solver which requires expresions to be linear. In other words
Excel Solver does not allow any IF, COUNTIF or other nonlinear functions. I
want to build a model which includes logical expresions (True/False) results,
and be able to sum the true values. So I want (1/0) instead of (True/False).

So my question is how can I set a cell to be boolean 1/0 ?
Thanks

Replies