Hi People thanks for your quick answer and sorry for not having posted my
data I thought I was being clear enough but certainly I was not. So here's my
example. Say I have in columns A and B the following data

Animal Color
Horse Blue
Fish Green
Dog Green
Rabbit Red
Parrot Purple
Rabbit Blue
Hare Magenta

And I need to make a validation of all and only the Rabbits that are blue,
so I use the formula in column C: =AND(A2="Rabbit",B2="Blue") which works
well. The new condition is that when there is a Hare in the Animal colum it
needs to be validated as if it were a Blue Rabbit despite the color this hare
is (and that it is not a rabbit). So where do I need to add A2="Hare" to the
formula to make it work?
Thanks

Jorge E Jaramillo
"Jorge E. Jaramillo" wrote:

Hi

I need to evaluate the conditions of two columns on a spreadsheet and for
that I use the AND function and it works well. Now a new condition that
overrrides the previous ones has arised so now I have to do both, the former
verification (AND function) and a new one to check for a new value in one of
the columns that is enough to classify the whole register as TRUE.

Is there a way I can mix AND and then OR functions in the same formula? I
guess there is but i haven't been able to find the propoer sintax to do it.

Thanks in advance

Jorge E Jaramillo