Posted to microsoft.public.excel.worksheet.functions
|
|
IF, AND, OR Function
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
|