Try...

=IF(COUNTIF(E200:E250,"P"),"B","")

Replace commas with semi-colons if your version of Excel uses the
semi-colon as a list separator.

Hope this helps!

In article ,
OBIPEDA wrote:

Hello!
I got a small question, which should not be any problem for a Excel
specialist.

I want to search through a part of a column (i.e. "E200:E250") for a
specific text (i.e. "P"), and if in one cell of the specified range
exactly this text is found, I want to set a seperate text (i.e. "B") in
another cell (i.e. "E255).

Has anyone of you some idea for me?

I tried like =if(E200:E250="P"; "B"; ""), but is not working!

Best regards,
Peter