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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Jorge E. Jaramillo" <(E-Mail Removed)> wrote in
message news:1CFEE737-EE6B-4D04-AA69-(E-Mail Removed)...
> 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

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

"Jorge E. Jaramillo" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in
message news:1CFEE737-EE6B-4D04-AA69-(E-Mail Removed)...
> 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

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

"Jorge E. Jaramillo" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in
message news:EB67D4FF-1C18-47FF-9C5F-(E-Mail Removed)...
> 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

Awesome!

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

"JoeU2004" wrote:

> "Jorge E. Jaramillo" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in
> message news:EB67D4FF-1C18-47FF-9C5F-(E-Mail Removed)...
> > 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
>
> .
>