Forum Discussion

jawick's avatar
jawick
Copper Contributor
Jul 01, 2019

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 don't want Excel to add the other numbers and ignore the word false in one of the cells.

Formulas and Functions

5 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 01, 2019

    jawick 

    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

    • jawick's avatar
      jawick
      Copper Contributor
      Jul 01, 2019

      SergeiBaklan 

      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

Resources