IF a range of cells contain a number greater than

[James8761]

Hi All,

Hopefully a quick one. I have a list of numbers in Cells CB2:CU2. Some cells are blank, the others contain a number between 1 and 100.

In Cell BN2, I would like to put in a formula that says if any of the Cells in CB2:CU2 contain a number greater than 75, then enter a Y, if not then enter a N.

I can do it individually by looking at CB2, CC2 etc but not sure how to do it on a range.

Thanks for any help.
James

 

[shaowu459]

try this:
BN2=if(countif(CB2:CU2,">75"),"Y"m,"N")

 

[James8761]

try this:
BN2=if(countif(CB2:CU2,">75"),"Y"m,"N")

Thank you very much......does exactly what I want it to

 

[shaowu459]

You are welcom and thanks you feedback

 

[rizzstang]

Hi Thank you for this. I am trying to solve something similar. Sorry for the question but was the "m" after the "Y" intentional? It's giving my formula an error.

 

[dreid1011]

Hi Thank you for this. I am trying to solve something similar. Sorry for the question but was the "m" after the "Y" intentional? It's giving my formula an error.

I would vote unintentional.