IF Statement - AND, OR
 

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

IF Statement - AND, OR
 

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



--
Don Guillett
SalesAid Software

"James Hamilton" wrote in message
...
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

IF Statement - AND, OR
 

Try a: OR(AND(cond1),AND(Cond2)) construct .., viz.:
=IF(OR(AND(D5100000,0,E510%),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,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

IF Statement - AND, OR
 

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

IF Statement - AND, OR
 

"James Hamilton" wrote:
Great - thanks guys

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

IF Statement - AND, OR
 

glad to help

--
Don Guillett
SalesAid Software

"James Hamilton" wrote in message
...
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