You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Adding up booleans.
- Thread starter Grigoriy
- Start date
Thanks for the help.Use If function :
=IF(logical_test,1,0)
=IF(TRUE+TRUE+FALSE,1,0)
=1
But not that easy: imagine an array to process (i.e. with SUMPRODUCT function) with multiple TRUES and FALSES.
Only 1 and 0s are acceptable, 2s, 3s etc. aren't.
Thanks for the help.
But not that easy: imagine an array to process (i.e. with SUMPRODUCT function) with multiple TRUES and FALSES.
Only 1 and 0s are acceptable, 2s, 3s etc. aren't.
Please give more information and show example of your array.
Peter Bartholomew
Well-Known Member
Since you are dealing with Booleans, I would name the array 'Booleans' (I'm creative like that!)
If you use logic operations, the formula would be
= OR(Booleans)
= OR(X, Y, Z)
There are a number of ways of converting the TRUE to 1, including
= SIGN(OR(Booleans))
= SIGN( OR(X, Y, Z) )
If you prefer to stick with arithmetic operators, you could turn to de'Morgan's laws to reformulate the formula
= 1 - PRODUCT(1 - Booleans)
= 1 - (1-X)*(1-Y)*(1-Z)
[equivalent to
= NOT(AND(NOT(Booleans)))
= NOT( AND(NOT(X), NOT(Y), NOT(Z)) ) ]
If you use logic operations, the formula would be
= OR(Booleans)
= OR(X, Y, Z)
There are a number of ways of converting the TRUE to 1, including
= SIGN(OR(Booleans))
= SIGN( OR(X, Y, Z) )
If you prefer to stick with arithmetic operators, you could turn to de'Morgan's laws to reformulate the formula
= 1 - PRODUCT(1 - Booleans)
= 1 - (1-X)*(1-Y)*(1-Z)
[equivalent to
= NOT(AND(NOT(Booleans)))
= NOT( AND(NOT(X), NOT(Y), NOT(Z)) ) ]
Last edited:
Here is the file ↓Please give more information and show example of your array.
Attachments
Does this work in your array ?The array is within YELLOW square.
There are 2 (two) 2s in it. They need to become ONES.
In C53, copied across and down :
=0+((C$25=$M$4)+(C$25=$N$4)+($B53=$L$4)>0)