Numerical value of logicals
Thanks to all of you. The solutions you presented worked!
"hmm" wrote:
As I understand it, when logicals are used in a formula, TRUE=1 and FALSE=0.
If this is so, then why is Excel evaluating the formula below as 0 instead of
1?
=SUMPRODUCT({FALSE,TRUE,FALSE},{TRUE,TRUE,FALSE})
|