Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple formulas at one time | Excel Worksheet Functions | |||
Multiple "if" formulas | New Users to Excel | |||
Formulas for Multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |