"Jorge E. Jaramillo" wrote:
so I use the formula in column C: =AND(A2="Rabbit",B2="Blue")
[....]
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

=OR(A2="hare", AND(A2="rabbit",B2="blue"))


----- original message -----

"Jorge E. Jaramillo" wrote in
message ...
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