Excel 2003 using the OR formula

  • Thread starter Thread starter MS Forum Newsgroup User
  • Start date Start date
M

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.
 
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?
 
Dave,

My bad I was including another cell which should not have been part of the
validation - thanks for the heads up!
 
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.
Click to expand...

Did you read the help text within Excel?

=OR(CW2, CZ2, AB2)
 
Back
Top