IF Statement - AND, OR

Hi,

I have a formula as follows:

=IF((AND(D5>$100,000,E5>10%)),"yes","no")

I want to add another condition as follows:

=IF((AND(D5<-$100,000,E5<-10%)),"yes","no")

....and I can't get it to work.

Any assistance would be appreciated.

James

try something like (untested)
=IF(or(AND(D5>$100,000,E5>10%),AND(D5<-$100,000,E5<-10%)),"yes","no")



--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"James Hamilton" <mailforme@optusnet.com.au> wrote in message
news:FB0E1558-4B29-4CC9-8D78-725E25948E89@microsoft.com...
> Hi,
>
> I have a formula as follows:
>
> =IF((AND(D5>$100,000,E5>10%)),"yes","no")
>
> I want to add another condition as follows:
>
> =IF((AND(D5<-$100,000,E5<-10%)),"yes","no")
>
> ...and I can't get it to work.
>
> Any assistance would be appreciated.
>
> James
>
>

Try a: OR(AND(cond1),AND(Cond2)) construct .., viz.:
=IF(OR(AND(D5>100000,0,E5>10%),AND(D5<-100000,0,E5<-10%)),"yes","no")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"James Hamilton" wrote:
> Hi,
>
> I have a formula as follows:
>
> =IF((AND(D5>$100,000,E5>10%)),"yes","no")
>
> I want to add another condition as follows:
>
> =IF((AND(D5<-$100,000,E5<-10%)),"yes","no")
>
> ...and I can't get it to work.
>
> Any assistance would be appreciated.
>
> James
>
>

Great - thanks guys

"James Hamilton" wrote:

> Hi,
>
> I have a formula as follows:
>
> =IF((AND(D5>$100,000,E5>10%)),"yes","no")
>
> I want to add another condition as follows:
>
> =IF((AND(D5<-$100,000,E5<-10%)),"yes","no")
>
> ...and I can't get it to work.
>
> Any assistance would be appreciated.
>
> James
>
>

"James Hamilton" wrote:
> Great - thanks guys

You're welcome !
Thanks for feeding back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

glad to help

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"James Hamilton" <mailforme@optusnet.com.au> wrote in message
news:1B6CC0DD-4E57-4857-9890-AB515DFC4C74@microsoft.com...
> Great - thanks guys
>
> "James Hamilton" wrote:
>
>> Hi,
>>
>> I have a formula as follows:
>>
>> =IF((AND(D5>$100,000,E5>10%)),"yes","no")
>>
>> I want to add another condition as follows:
>>
>> =IF((AND(D5<-$100,000,E5<-10%)),"yes","no")
>>
>> ...and I can't get it to work.
>>
>> Any assistance would be appreciated.
>>
>> James
>>
>>