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
>
>