=IF(C1="black",1,IF(C1="red",1,0))


"cyrock1" wrote:

I'm trying to figure out a function for a column. I want column M to look at
column C and IF the word in column C is "black" or "red" i want column M to
show a value of "1"