Can AND and OR be on the same formula?
 

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

Can AND and OR be on the same formula?
 

Sure. Example.
=IF(AND(1=1,2=2),1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Can AND and OR be on the same formula?
 

The short answer is yes you can use both and and or. Post your existing
formula along with a bit of sample data. Let us know what new logic needs to
be implimented and we can give you a hand.
--
HTH...

Jim Thomlinson


"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

Can AND and OR be on the same formula?
 

"Jorge E. Jaramillo" wrote:
Is there a way I can mix AND and then OR functions in the same formula?

Sure.

i haven't been able to find the propoer sintax to do it.

Since you neglected to post your formula (klunk!) and most of us are not
clairvoyant, we cannot show you the proper syntax either.

But perhaps the following will help you.

If you currently have:

=IF(AND(A1=1,B1=2), C1, D1)

change that to:

=IF(OR(E1=3,AND(A1=1,B1=2)), C1, D1)

A note on "overriding" conditions: normally, all function parameters are
evaluated before evaluating the function. (Noted exception: IF function.)
So it might be necessary to split "or" tests into two IF parameters. For
example:

=IF(E1=3, C1, IF(AND(A1=1,B1=2), C1, D1))

The devil is in the details. If you need further assistance, you will need
to post those details.


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

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

Can AND and OR be on the same formula?
 

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

Can AND and OR be on the same formula?
 

"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

Can AND and OR be on the same formula?
 

Awesome!

Thanks a lot (I clicked on Yes at the question regarding the usefulness of
your answer)

"JoeU2004" wrote:

"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

.