IF function (?)

[Bal_Ocado]

G1
G2
G3
G4	NO
G5

<tbody>
</tbody>

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.