You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tracey" wrote in message
...
Thank you!

:)

"Ashish Mathur" wrote:

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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