Excel 2003 using the OR formula

[MS Forum Newsgroup User]

Hi,

I have several cells CW2, CZ2, AB2 etc I would like to test if any of these
cells values are True,

I thought that I could use OR(CW2 = True, CZ2 = True, AB2=True)

But these did not work, an help is appreciated.

 

[Dave Peterson]

That expression worked ok for me.

How did it not work for you?

And are you sure you have the boolean value TRUE in the cell? Could you have a
plain old string "True" in the cell instead?

 

[MS Forum Newsgroup User]

Dave,

My bad I was including another cell which should not have been part of the
validation - thanks for the heads up!

 

[Stan Brown]

Hi,

I have several cells CW2, CZ2, AB2 etc I would like to test if any of these
cells values are True,

I thought that I could use OR(CW2 = True, CZ2 = True, AB2=True)

But these did not work, an help is appreciated.

Did you read the help text within Excel?

=OR(CW2, CZ2, AB2)