=ISNUMBER(MATCH(A,{"Green","Yellow","Red"},0))+0

Barb Reinhardt wrote:
My formula currently looks like this

=if(or(A=Green,A=Yellow,A=Red),1,0)

unfortunately A is a fairly long formula. Is there a more elegant way to do
this?

Thanks,
Barb Reinhardt