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,

Didn't I see this before?

Use OR

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

That's if the other two inclusions are in K16

Beege.




"Brad Larsen" wrote in message
...
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
 

Yes - you did see this before - but that hasn't worked for me. Any other
suggestions?

"Beege" wrote:

Brad,

Didn't I see this before?

Use OR

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

That's if the other two inclusions are in K16

Beege.




"Brad Larsen" wrote in message
...
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

Beege's suggestion seems sensible enough to me - you might try
explaining why that doesn't work for you - it may make it easier for
others to understand your aim.

Just looking at your initial formula I think you could tidy it up a
bit, you wouldn't normally use quotes around numbers unless you have a
particular reason to so...

=IF(K16="1 of 4",IF(I16<11,2,IF(I16<61,1,0)))

now, what's the extra bit?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515962