View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tony
 
Posts: n/a
Default Boolean 0/1 instead of True/False

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