On Wed, 12 Nov 2008 02:30:05 -0800, Tracey
wrote:

Hello,

I have successfully created the IF / AND function on the following formula:

=IF(AND(A1="Feb 08",B1="Persons Name"),"Clear","Not Clear")

however, when I want to ad another condition to the "AND" part (as below),
the formula stops.

=IF(AND(A1="Jan 08",A1="Feb 08",B1="Persons Name"),"Clear","Not Clear")

do i need to ad an "OR" if I do, where in the formula do I ad it?

Many thanks
Tracey


What do you mean by "the formula stops" ?

What, exactly, are you trying to do?

In words, your AND function requires that

A1 = "Jan 08" AND A1 = "Feb 08"

Since A1 cannot be equal to two things at the same time, this must always
evaluate to FALSE.

If you want the condition to be TRUE if A1 equals "Jan 08" OR if A1 equals "Feb
08", then you need to state that.

You will find it helpful to write out exactly what you want in words.

You might wind up with:

AND(OR(a1="Jan 08",a1="Feb 08"),B1="Persons Name")

--ron