calc: test a text cell for any occurrence of a specified letter

[Bandersnoot]

I have a Calc spreadsheet in which the cells in one column contain up to four letters (or none at all). I need to be able to test each cell in the column to see whether it contains the letter C.

I built the formula below, but it returns only “Err:510”

IFS(MID(N133,1,1),=“C”,MID(N133,2,1),=“C”,MID(N133,3,1),=“C”,MID(N133,4,1),=“C”)

There ought to be a way to accomplish this but apparently I’m too thick to see it. Any help greatly appreciated!

[mikekaganski]

IFS tests that all conditions are true simultaneously, not that any of them is satisfied. Another way would be using OR:

=OR(MID(N133;1;1)="C";MID(N133;2;1)="C";MID(N133;3;1)="C";MID(N133;4;1)="C")

[Bandersnoot]

Thanks, Mike!

I knew there was a way to do it, but for some reason (my stupidity, I suppose) I was so concentrated on making IFS work that I clean forgot about OR (slaps self in forehead).

[mikekaganski]

=ISNUMBER(FIND("C";N133))