I'm not sure if I'm approaching this problem wrong, but there's got to be an easy way to do this.

I simply want to see if Certain text is listed above that cell. If it's not, Put that text. If it is put blank.

This is what I have:

=if(F4:F5="TEST","","TEST")

This gives it an array formula error so I created this:

=arrayformula(if(F4:F5="TEST","","TEST"))

But I don't need two results... just a yes/no statement. If the cells in this range contain "TEST" leave blank, if it does not contain "TEST" display the word "TEST".

What am I doing wrong?

CodePudding user response：

If the cells in this range contain "TEST" leave blank, if it does not contain "TEST" display the word "TEST".

Use COUNTIF()

=if(countif(range,"TEST"),,"TEST")