IF function (?)

[Bal_Ocado]

[TABLE="width: 500"]
<tbody>[TR]
[TD]G1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G4
[/TD]
[TD]NO
[/TD]
[/TR]
[TR]
[TD]G5
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi Guys,

I have an IF function similar to the above which states wether a product is within a pricing corridor (in another column, but not important).

I want to, in another sheet, state an IF function to say that if anything in column B comes back with a 'NO', show "X", otherwise show " ".

Isit possible to have an IF function over a range, rather than a specific cell?

Thanks

 

[VoG]

Try

=IF(ISNUMBER(MATCH("NO",B:B,0)),"X","")

 

[slinky]

=if(match("no",b1:b20,0)>0,"x"," ")

 

[Peter_SSs]

.. or something like

=IF(COUNTIF(B1:B100,"No"),"X","")

 

[Bal_Ocado]

Thanks guys, second one worked. Something was off with the top one!

 

[Peter_SSs]

Thanks guys, second one worked. Something was off with the top one!

Are you sure about the second one? Have a look what happens when there are not any "No" values in the range.