Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is this possible to do? I know how to do an If with AND:
IF(AND(criteria1,criteria2),True,False) and I can do an OR: IF(OR(criteria1,criteria2),True,False) but can I do both? Thanks for any help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=IF(AND(criterion1,OR(criterion2,criterion3)),valu e_if_true,value_if_false)
or =IF(OR(criterion1,AND(criterion2,criterion3)),valu e_if_true,value_if_false) or nest the functions to suit your requirements. -- David Biddulph "Andy" wrote in message ... Is this possible to do? I know how to do an If with AND: IF(AND(criteria1,criteria2),True,False) and I can do an OR: IF(OR(criteria1,criteria2),True,False) but can I do both? Thanks for any help. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can have multiple ANDs and ORs in a logic equation. But doing an OR will
include theh AND condition AND Table B False True A False False False True False True OR Table B False True A False False True True True True The condition A = True and B = True is True in both tables above. "Andy" wrote: Is this possible to do? I know how to do an If with AND: IF(AND(criteria1,criteria2),True,False) and I can do an OR: IF(OR(criteria1,criteria2),True,False) but can I do both? Thanks for any help. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Say you have a situation where you have multiple criteria, and you want a
true to return with the All of the following criteria: 1: Criteria1 OR Criteria 2 2: Criteria3 4: Criteria4 & Criteria5 or Criteria6 =IF(AND(OR(crit1,crit2),crit3,OR(AND(crit4,crit5), crit6)),TRUE,FALSE) -- ** John C ** "Andy" wrote: Is this possible to do? I know how to do an If with AND: IF(AND(criteria1,criteria2),True,False) and I can do an OR: IF(OR(criteria1,criteria2),True,False) but can I do both? Thanks for any help. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=if(and(a1=5,b1=3,or(c1=5,c1=17)),"a1=5 AND b1=3 And c1=(5or17)","one not true")
Andy wrote: Is this possible to do? I know how to do an If with AND: IF(AND(criteria1,criteria2),True,False) and I can do an OR: IF(OR(criteria1,criteria2),True,False) but can I do both? Thanks for any help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |