software

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(C5gt;=5 *AND* F5gt;=5 *AND* G5=1,quot;Positivequot;,quot;Negativequot;)

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: www.excelforum.com/member.php...foamp;userid=6043
View this thread: www.excelforum.com/showthread...hreadid=516887=IF(AND(C5gt;=5; F5gt;=5;G5=1),quot;Positivequot;,quot;Negativequot;)

HTH
--
AP

quot;guilbj2quot; gt; a écrit
dans le message de
...
gt;
gt; Hi All,
gt;
gt; I'm relatively advanced in Excel but hoping some bigger brains can help
gt; me with syntax on this one. I'm positive it's possible, I just don't
gt; know how to type it out. I basically want an IF formula that requires
gt; multiple conditions rather than just one... kind of like this.
gt;
gt; =IF(C5gt;=5 *AND* F5gt;=5 *AND* G5=1,quot;Positivequot;,quot;Negativequot;)
gt;
gt; I know that *AND* won't work, but there has to be a way to do this. To
gt; sum up, I want to create an =IF that requires that 3 conditions are met,
gt; will provide a certain value if all of them are met and another if any
gt; of the 3 are not.
gt;
gt;
gt; --
gt; guilbj2
gt; ------------------------------------------------------------------------
gt; guilbj2's Profile:
www.excelforum.com/member.php...foamp;userid=6043
gt; View this thread: www.excelforum.com/showthread...hreadid=516887
gt;
=IF(AND(C5gt;=5,F5gt;=5,G5gt;=5),quot;Positivequot;,quot;Negativequot;)

--
Kind regards,

Niek Otten
quot;guilbj2quot; gt; wrote in
message ...
gt;
gt; Hi All,
gt;
gt; I'm relatively advanced in Excel but hoping some bigger brains can help
gt; me with syntax on this one. I'm positive it's possible, I just don't
gt; know how to type it out. I basically want an IF formula that requires
gt; multiple conditions rather than just one... kind of like this.
gt;
gt; =IF(C5gt;=5 *AND* F5gt;=5 *AND* G5=1,quot;Positivequot;,quot;Negativequot;)
gt;
gt; I know that *AND* won't work, but there has to be a way to do this. To
gt; sum up, I want to create an =IF that requires that 3 conditions are met,
gt; will provide a certain value if all of them are met and another if any
gt; of the 3 are not.
gt;
gt;
gt; --
gt; guilbj2
gt; ------------------------------------------------------------------------
gt; guilbj2's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6043
gt; View this thread: www.excelforum.com/showthread...hreadid=516887
gt;
Hello guilbj2

You need a nested AND and IF statement:

=IF(C5gt;=5 *AND* F5gt;=5 *AND* G5=1,quot;Positivequot;,quot;Negativequot;)

=IF(AND(C5gt;5,F5gt;=5,G5=1),quot;Positivequot;,quot;Negativequot;)

The AND statement means that all criteria must be met.

Hope this helps

Judith

quot;guilbj2quot; wrote:

gt;
gt; Hi All,
gt;
gt; I'm relatively advanced in Excel but hoping some bigger brains can help
gt; me with syntax on this one. I'm positive it's possible, I just don't
gt; know how to type it out. I basically want an IF formula that requires
gt; multiple conditions rather than just one... kind of like this.
gt;
gt; =IF(C5gt;=5 *AND* F5gt;=5 *AND* G5=1,quot;Positivequot;,quot;Negativequot;)
gt;
gt; I know that *AND* won't work, but there has to be a way to do this. To
gt; sum up, I want to create an =IF that requires that 3 conditions are met,
gt; will provide a certain value if all of them are met and another if any
gt; of the 3 are not.
gt;
gt;
gt; --
gt; guilbj2
gt; ------------------------------------------------------------------------
gt; guilbj2's Profile: www.excelforum.com/member.php...foamp;userid=6043
gt; View this thread: www.excelforum.com/showthread...hreadid=516887
gt;
gt;

=IF(AND(C5gt;=5,F5gt;=5,G5=1),quot;Positivequot;,quot;Negativequot;)

or

=IF((C5gt;=5)*(F5gt;=5)*(G5=1),quot;Positivequot;,quot;Negativequot;)

quot;guilbj2quot; wrote:

gt;
gt; Hi All,
gt;
gt; I'm relatively advanced in Excel but hoping some bigger brains can help
gt; me with syntax on this one. I'm positive it's possible, I just don't
gt; know how to type it out. I basically want an IF formula that requires
gt; multiple conditions rather than just one... kind of like this.
gt;
gt; =IF(C5gt;=5 *AND* F5gt;=5 *AND* G5=1,quot;Positivequot;,quot;Negativequot;)
gt;
gt; I know that *AND* won't work, but there has to be a way to do this. To
gt; sum up, I want to create an =IF that requires that 3 conditions are met,
gt; will provide a certain value if all of them are met and another if any
gt; of the 3 are not.
gt;
gt;
gt; --
gt; guilbj2
gt; ------------------------------------------------------------------------
gt; guilbj2's Profile: www.excelforum.com/member.php...foamp;userid=6043
gt; View this thread: www.excelforum.com/showthread...hreadid=516887
gt;
gt;