TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA
 

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

TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA
 

=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

TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA
 

"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"))

TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA
 

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"))