Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Im trying to create a formula that combines and evaluates two sub-formulas
and returns a different result depending on which of the two evaluates to true. Here is a description of the two conditions and the formulas that work correctly for each condition: 1. If B1 is ET or IT, YES is returned in A1 (otherwise NO) =IF(OR(B1="ET",B1="IT"), "YES","NO") 2. If B1 is blank, then - (that is just a dash) is returned in A1. =IF((ISBLANK(B1)),"-") What I cannot figure out is how to combine the two into one larger formula. The combination needs to be some kind of OR formula since one or the other of the two needs to calculate. Thanks for your assistance. -- William |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=IF(ISBLANK(B1),"-",IF(OR(B1="ET",B1="IT"), "YES","NO"))
"William" wrote: Im trying to create a formula that combines and evaluates two sub-formulas and returns a different result depending on which of the two evaluates to true. Here is a description of the two conditions and the formulas that work correctly for each condition: 1. If B1 is ET or IT, YES is returned in A1 (otherwise NO) =IF(OR(B1="ET",B1="IT"), "YES","NO") 2. If B1 is blank, then - (that is just a dash) is returned in A1. =IF((ISBLANK(B1)),"-") What I cannot figure out is how to combine the two into one larger formula. The combination needs to be some kind of OR formula since one or the other of the two needs to calculate. Thanks for your assistance. -- William |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"William" wrote in message
... I'm trying to create a formula that combines and evaluates two sub-formulas and returns a different result depending on which of the two evaluates to true. Here is a description of the two conditions and the formulas that work correctly for each condition: 1. If B1 is "ET" or "IT", "YES" is returned in A1 (otherwise "NO") =IF(OR(B1="ET",B1="IT"), "YES","NO") 2. If B1 is blank, then "-" (that is just a dash) is returned in A1. =IF((ISBLANK(B1)),"-") What I cannot figure out is how to combine the two into one larger formula. The combination needs to be some kind of OR formula since one or the other of the two needs to calculate. Thanks for your assistance. =IF(ISBLANK(B1),"-",IF(OR(B1="ET",B1="IT"), "YES","NO")) |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you both very much!!
-- William "Lorne" wrote: "William" wrote in message ... I'm trying to create a formula that combines and evaluates two sub-formulas and returns a different result depending on which of the two evaluates to true. Here is a description of the two conditions and the formulas that work correctly for each condition: 1. If B1 is "ET" or "IT", "YES" is returned in A1 (otherwise "NO") =IF(OR(B1="ET",B1="IT"), "YES","NO") 2. If B1 is blank, then "-" (that is just a dash) is returned in A1. =IF((ISBLANK(B1)),"-") What I cannot figure out is how to combine the two into one larger formula. The combination needs to be some kind of OR formula since one or the other of the two needs to calculate. Thanks for your assistance. =IF(ISBLANK(B1),"-",IF(OR(B1="ET",B1="IT"), "YES","NO")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
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 |