Forum Discussion
Returning FALSE when adding up a series of cells in which one of the cells has a false
Hello, I am trying to do something fairly simple. I want to add a number of cells that have numbers in them but if one of the cells has a false in it then I want a FALSE returned. In other words I d...
That worked! Thank you much Sergei, by the way is there a way to incorporate ISLOGICAL into an IF, AND formula? For instance if A42="a" and a series of cells are logical then out-put the addition or multiplication of a series of cells? I am guessing here but something like this: IF(AND(A42="a", ISLOGICAL(A56)*ISLOGICAL(A62)*ISLOGICAL(A70),FALSE,A56*A62*A70)
TIA
With this formula
=IF((A42="a")*ISLOGICAL(A56)*ISLOGICAL(A62)*ISLOGICAL(A70),FALSE,A56*A62*A70)
you have FALSE if A42 is "a" and each of the cells is TRUE or FALSE. If you have at least one numeric equivalent of TRUE or FALSE in these cells (i.e. non-zero number or zero) formula returns 0 instead of FALSE.