Help with formula related to IF function

[Samuel14]

I am trying to display a value in a cell based on the contents of a range of cells and I need some help. I am essentially trying to get a cell to display a "P" if any single cell in a range of cells contains the word "Orange".

I have tried using the IF function via the following formula:

=IF($G22:$I22="Orange","P")

This does work to a point. The cell that the formula is in displays a "P" if there is a cell that contains "Orange". However, it also generates a cell next to it that says "False" for every cell in that range that does not contain "Orange". I only want the cell to display a single "P" if one or more of the cells in the search range say "Orange" and nothing else.

Any help is much appreciated!

 

[dreid1011]

Maybe something like this:

=IF(COUNTIF($G22:$I22,"Orange"),"P","")

 

[Samuel14]

Maybe something like this:

=IF(COUNTIF($G22:$I22,"Orange"),"P","")

Yes! That works! Thank you!

 

[dreid1011]

Yes! That works! Thank you!

You're welcome, and happy to help.