Nested If Statement

[guilbj2]

Hi All,

I'm relatively advanced in Excel but hoping some bigger brains can help me with syntax on this one. I'm positive it's possible, I just don't know how to type it out. I basically want an IF formula that requires 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. To 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 any of the 3 are not.

[Ardus Petus]

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

HTH
--
AP

"guilbj2" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> Hi All,
>
> I'm relatively advanced in Excel but hoping some bigger brains can help
> me with syntax on this one. I'm positive it's possible, I just don't
> know how to type it out. I basically want an IF formula that requires
> 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. To
> 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 any
> of the 3 are not.
>
>
> --
> guilbj2
> ------------------------------------------------------------------------
> guilbj2's Profile:
http://www.excelforum.com/member.php...fo&userid=6043
> View this thread: http://www.excelforum.com/showthread...hreadid=516887
>

[Niek Otten]

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

--
Kind regards,

Niek Otten



"guilbj2" <[email protected]> wrote in
message news:[email protected]...
>
> Hi All,
>
> I'm relatively advanced in Excel but hoping some bigger brains can help
> me with syntax on this one. I'm positive it's possible, I just don't
> know how to type it out. I basically want an IF formula that requires
> 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. To
> 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 any
> of the 3 are not.
>
>
> --
> guilbj2
> ------------------------------------------------------------------------
> guilbj2's Profile:
> http://www.excelforum.com/member.php...fo&userid=6043
> View this thread: http://www.excelforum.com/showthread...hreadid=516887
>

[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

"guilbj2" wrote:

>
> Hi All,
>
> I'm relatively advanced in Excel but hoping some bigger brains can help
> me with syntax on this one. I'm positive it's possible, I just don't
> know how to type it out. I basically want an IF formula that requires
> 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. To
> 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 any
> of the 3 are not.
>
>
> --
> guilbj2
> ------------------------------------------------------------------------
> guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
> View this thread: http://www.excelforum.com/showthread...hreadid=516887
>
>

[Sloth]

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

or

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

"guilbj2" wrote:

>
> Hi All,
>
> I'm relatively advanced in Excel but hoping some bigger brains can help
> me with syntax on this one. I'm positive it's possible, I just don't
> know how to type it out. I basically want an IF formula that requires
> 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. To
> 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 any
> of the 3 are not.
>
>
> --
> guilbj2
> ------------------------------------------------------------------------
> guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
> View this thread: http://www.excelforum.com/showthread...hreadid=516887
>
>