OR() Function

[mmartin]

Hi,
can the OR() Function be used over cell ranges?

I'm trying the following :

=OR((Z3:BZ3="F"))

. . . and the result is :

#VALUE!

Cheers

 

[Andrew Poulsom]

Yes, but you must press Ctrl+Shift Enter, rather than just Enter. If correctly entered Excel will surround the array formula with curly braces {}.

An alternative normal formula:

=COUNTIF(Z3:BZ3,"F")>0

 

[njimack]

Are you trying to count the number of cells in the range that equal F, or are you testing that ANY of the cells in the range equal F?

To count the no. of cells which equal F: =COUNTIF(Z3:BZ3,"F")
To count the no. of cells which CONTAIN F: =COUNTIF(Z3:BZ3,"*F*")
To test whether ANY of the cells equal F:=COUNTIF(Z3:BZ3,"F")>0 (returns TRUE/FALSE)

 

[Jonmo1]

For What Purpose ?

Exactly as you wrote it, no it can't be used that way..

Are you trying to See if F exists in the range Z3:BZ3 ?

=COUNTIF(Z3:BZ3,"F")>0

Will return TRUE if F exists anywhere in the range
remove the >0 to get the count of HOW MANY Fs are in the range...

Hope this helps..

 

[mmartin]

Hi All,
apologies - I should have been clearer - I was indeed trying to test for the presence of F in the range.

Your suggestions worked perfectly. Many Thanks
Cheers!