Home > Net >  Having trouble with IF NOT statments work in Sheets
Having trouble with IF NOT statments work in Sheets

Time:10-21

this might be an easy fix but I just can't figure it out. I'm trying to get this IF statement, if the cell is not FALSE to return value, else to return a certain string. I've tried a couple of ways but I can't make the right combination. And I have a similar issue with excluding the FALSE value from a UNIQUE search statement. This is the enter image description here


Regarding filtering your data without FALSE:

=filter(A2:A,A2:A <> FALSE)

What it does?

  • Using enter image description here

    Note:

    You can also use UNIQUE() once you filter your data

    =unique(filter(A2:A,A2:A <> FALSE))
    
  • Related