Forum Discussion
Returning FALSE when adding up a series of cells in which one of the cells has a false
For that sample, if that's sum (on the left)
when
=IF(SUMPRODUCT(ISLOGICAL($B$2:$B$8)*1),FALSE,SUM(B2:B8))
if running total (on the right)
=G2+F3*(1-SUMPRODUCT(ISLOGICAL($F$2:$F3)*1))
I assume there is no TRUE, it'll be the same trigger
Thank you. From your example, if all cells from B2 to B8 are numbers then I would like the sum of those numbers displayed. If there is a FALSE in anyone of the cells from B2 to B8 then I would like the word FALSE displayed. I don't know if your formula encapsulates what I need, partly because the cells that I would like to reference are not consecutive, i.e. A47+A87+A93+A99+A105+A111.
TIA
When like
=IF(ISLOGICAL(A47)+ISLOGICAL(A87)+ISLOGICAL(A93)+ISLOGICAL(A99)+ISLOGICAL(A105)+ISLOGICAL(A111),FALSE,A47+A87+A93+A99+A105+A111)
Sheet2 attached
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
