Find if a value is in a range

[sadsfan]

Hello.
I have a range of cells (e.g. A1:U1), these have numbers in them and I need a formula to check if there is the number 1 in any of the cells, if there is I need to return a value of "Y" and if there isn't a value of "N".

Can anyone help?

 

[Fluff]

How about
=IF(COUNTIF(A1:U1,1)>0,"Y","N")

 

[sadsfan]

Thank you very much! I had to do a slight tweak because I made a mistake in my original post! But after that it worked perfectly.

=IF(COUNTIF(A1:U1,1)=0,"Y","N")​

 

[Fluff]

Glad to help & thanks for the feedback

 

[Rick Rothstein]

Thank you very much! I had to do a slight tweak because I made a mistake in my original post! But after that it worked perfectly.

=IF(COUNTIF(A1:U1,1)=0,"Y","N")​

You can simplify that formula slightly...

=IF(COUNTIF(A1:U1,1),"N","Y")

 

[sadsfan]

Thanks.