AND(A1="Jan 08",A1="Feb 08",...) would always be false, as A1 cannot be
equal to both values.
I assume that you probably mean =IF(AND(OR(A1="Jan 08",A1="Feb
08"),B1="Persons Name"),"Clear","Not Clear")
--
David Biddulph


"Tracey" wrote in message
...
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