IF, AND, OR Function
The way you have written this you want A1 to be both Jan 08 and Feb 08
- clearly it can't be both at the same time. Try it this way:
=IF(AND(OR(A1="Jan 08",A1="Feb 08"),B1="Persons Name"),"Clear","Not
Clear")
Hope this helps.
Pete
On Nov 12, 10:30*am, 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
|