Just replace the last 0 in the formula with a null ( "" ).

=IF(OR(A1={"RED","BLUE","GREEN","BLACK","ORANGE"}) ,1,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"kevin" wrote in message
...
One more complication, when using this formula in say cell d1, and if there
is no value in a1 it returns a 0 in d1, is there a way to include an
(ifblank
, return a blank,) statement in the formula so that nothing appears in the
cell until an entry is made in the input cell. Just so that there is not a
long string of 0's.

Thanks Kevin

"RagDyer" wrote:

Try this:

=IF(OR(A1={"RED","BLUE","GREEN","BLACK","ORANGE"}) ,1,0)

I'm sure you're talking Text here, and *not* the actual colors of the
cell.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"kevin" wrote in message
...
Once again thanks for your help folks. Could someone show me how to write
the
following if statement. =IF(A1=RED OR BLUE OR GREEN OR BLACK OR
ORANGE,1,0)
I know these would all need to be in "" but I am not sure what separator
to
use.
--
Thanks Kevin