Nested If Statement

G

guilbj2

Hi All,

I'm relatively advanced in Excel but hoping some bigger brains can hel
me with syntax on this one. I'm positive it's possible, I just don'
know how to type it out. I basically want an IF formula that require
multiple conditions rather than just one... kind of like this.

=IF(C5>=5 *AND* F5>=5 *AND* G5=1,"Positive","Negative")

I know that *AND* won't work, but there has to be a way to do this. T
sum up, I want to create an =IF that requires that 3 conditions are met
will provide a certain value if all of them are met and another if an
of the 3 are not
 
J

JudithJubilee

Hello guilbj2

You need a nested AND and IF statement:

=IF(C5>=5 *AND* F5>=5 *AND* G5=1,"Positive","Negative")

=IF(AND(C5>5,F5>=5,G5=1),"Positive","Negative")

The AND statement means that all criteria must be met.

Hope this helps

Judith
 
S

Sloth

=IF(AND(C5>=5,F5>=5,G5=1),"Positive","Negative")

or

=IF((C5>=5)*(F5>=5)*(G5=1),"Positive","Negative")
 
Top