Hi!

Try this:

=OR(EXACT(A1,{"YES","YEs","Yes","yes"}))

Biff

"jeffP" wrote in message
...
All I'm trying to do is check a cell for a text answer:

If ActiveCell.Text = "Yes" Then

but I need to test for YES,YEs,Yes,and yes

Do I really need to nest four If statements to do that?

Thanks for any and all help