brain freeze on simple formula, help!

[t0aster_uk]

Hi,

I am sure there is a simple way to do this but i cannot think of it, or find it using a search

basically i have a load of columns whose cells contain one of two values either true or false. I need to come up with a formula that will check an entire column
and if any of the cells contain "true" then return true, or if none of the columns contain "true" then return False. this is for working with intollerance data...

I tried using if with an array but it doesnt seem to work as planned:

{=IF(R7:R30="TRUE","TRUE","FALSE")}

Thanks

T0aster_uk

 

[jindon]

Hi

try

=If(Countif(R7:R30,"True")>0,"True","False")

rds,

jindon

 

[t0aster_uk]

cheers that worked a treat!

 

[howzat]

Hi there,

A vlookup or match formula including an =ISNA() evaluation would also do the trick.

Here's another approach:

=NOT(PRODUCT(--NOT(R7:R30)))

Array entered

 

[fairwinds]

Would not

=OR(R7:R30)

do?

 

[jindon]

Hi fairwinds

Perfect & I like it!

jindon