Multiple True's in IF Formula's
 

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="1 of 4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0))

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

How can i do this?

Thank you!

Multiple True's in IF Formula's
 

Brad Larsen Wrote:
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="1 of
4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0))

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

How can i do this?

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: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=515960

Multiple True's in IF Formula's
 

Hi Brad

Try =IF(OR(K16="1 of 4","5 of
20",0.25),IF(I1660,"0",(IF(I16<11,"2",IF(I1610," 1","2")))),0))

"Brad Larsen" wrote:

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="1 of 4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0))

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

How can i do this?

Thank you!

Multiple True's in IF Formula's
 

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

"Kassie" wrote:

Hi Brad

Try =IF(OR(K16="1 of 4","5 of
20",0.25),IF(I1660,"0",(IF(I16<11,"2",IF(I1610," 1","2")))),0))

"Brad Larsen" wrote:

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="1 of 4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0))

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

How can i do this?

Thank you!

Multiple True's in IF Formula's
 

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

"Brad Larsen" wrote:

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

"Kassie" wrote:

Hi Brad

Try =IF(OR(K16="1 of 4","5 of
20",0.25),IF(I1660,"0",(IF(I16<11,"2",IF(I1610," 1","2")))),0))

"Brad Larsen" wrote:

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="1 of 4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0))

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

How can i do this?

Thank you!