software

Hello -

Is it possible to write a formula that includes the option for multiple true
statements?

Here my formula that works for one true statement:

=(IF(K16=quot;1 of 4quot;,IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot;1quot;,quot;2quot;) ))),0))

the formula considers the true statment and then refers to another cell's
information to determine the value to include. In this case quot;1 of 4quot; is the
true statement. I want to include two other possible true statments that
follow the same formula quot;5 of 20quot; and quot;25%quot;

How can i do this?

Thank you!


Brad Larsen Wrote:
gt; Hello -
gt;
gt; Is it possible to write a formula that includes the option for multiple
gt; true
gt; statements?
gt;
gt; Here my formula that works for one true statement:
gt;
gt; =(IF(K16=quot;1 of
gt; 4quot;,IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot;1quot;,quot;2quot;) ))),0))
gt;
gt; the formula considers the true statment and then refers to another
gt; cell's
gt; information to determine the value to include. In this case quot;1 of 4quot;
gt; is the
gt; true statement. I want to include two other possible true statments
gt; that
gt; follow the same formula quot;5 of 20quot; and quot;25%quot;
gt;
gt; How can i do this?
gt;
gt; Thank you!

Your formula might look something like this ...

=IF(AND(CONDITION1,CONDITION2,CONDITION3,CONDITION 4),2,0)

Hope this helps you ...

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=515960Hi Brad

Try =IF(OR(K16=quot;1 of 4quot;,quot;5 of
20quot;,0.25),IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot; 1quot;,quot;2quot;)))),0))

quot;Brad Larsenquot; wrote:

gt; Hello -
gt;
gt; Is it possible to write a formula that includes the option for multiple true
gt; statements?
gt;
gt; Here my formula that works for one true statement:
gt;
gt; =(IF(K16=quot;1 of 4quot;,IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot;1quot;,quot;2quot;) ))),0))
gt;
gt; the formula considers the true statment and then refers to another cell's
gt; information to determine the value to include. In this case quot;1 of 4quot; is the
gt; true statement. I want to include two other possible true statments that
gt; follow the same formula quot;5 of 20quot; and quot;25%quot;
gt;
gt; How can i do this?
gt;
gt; Thank you!

Thank you - but that's not going to work - i've tried different combinations
of that with no luck so far.

quot;Kassiequot; wrote:

gt; Hi Brad
gt;
gt; Try =IF(OR(K16=quot;1 of 4quot;,quot;5 of
gt; 20quot;,0.25),IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot; 1quot;,quot;2quot;)))),0))
gt;
gt; quot;Brad Larsenquot; wrote:
gt;
gt; gt; Hello -
gt; gt;
gt; gt; Is it possible to write a formula that includes the option for multiple true
gt; gt; statements?
gt; gt;
gt; gt; Here my formula that works for one true statement:
gt; gt;
gt; gt; =(IF(K16=quot;1 of 4quot;,IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot;1quot;,quot;2quot;) ))),0))
gt; gt;
gt; gt; the formula considers the true statment and then refers to another cell's
gt; gt; information to determine the value to include. In this case quot;1 of 4quot; is the
gt; gt; true statement. I want to include two other possible true statments that
gt; gt; follow the same formula quot;5 of 20quot; and quot;25%quot;
gt; gt;
gt; gt; How can i do this?
gt; gt;
gt; gt; Thank you!

Hi Brad,
Sorry for the typo! I omitted the cell addressfor the additional
conditions. It should read =IF((OR(K16=quot;1 of 4quot;,K16=quot;5 of 20quot;,K16=0.25)

quot;Brad Larsenquot; wrote:

gt; Thank you - but that's not going to work - i've tried different combinations
gt; of that with no luck so far.
gt;
gt; quot;Kassiequot; wrote:
gt;
gt; gt; Hi Brad
gt; gt;
gt; gt; Try =IF(OR(K16=quot;1 of 4quot;,quot;5 of
gt; gt; 20quot;,0.25),IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot; 1quot;,quot;2quot;)))),0))
gt; gt;
gt; gt; quot;Brad Larsenquot; wrote:
gt; gt;
gt; gt; gt; Hello -
gt; gt; gt;
gt; gt; gt; Is it possible to write a formula that includes the option for multiple true
gt; gt; gt; statements?
gt; gt; gt;
gt; gt; gt; Here my formula that works for one true statement:
gt; gt; gt;
gt; gt; gt; =(IF(K16=quot;1 of 4quot;,IF(I16gt;60,quot;0quot;,(IF(I16lt;11,quot;2quot;,IF(I16gt;10,quot;1quot;,quot;2quot;) ))),0))
gt; gt; gt;
gt; gt; gt; the formula considers the true statment and then refers to another cell's
gt; gt; gt; information to determine the value to include. In this case quot;1 of 4quot; is the
gt; gt; gt; true statement. I want to include two other possible true statments that
gt; gt; gt; follow the same formula quot;5 of 20quot; and quot;25%quot;
gt; gt; gt;
gt; gt; gt; How can i do this?
gt; gt; gt;
gt; gt; gt; Thank you!