Great - thanks guys

"James Hamilton" wrote:

Hi,

I have a formula as follows:

=IF((AND(D5$100,000,E510%)),"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