Are "Blue" and "Dark-Blue" part of a larger string? If not, and the colors are the precise value of a string, then you shouldn't use Contains(). Instead, you'd simply want:
IF [Color] = "Blue" then 1
elseif [Color] = "Dark-Blue" then 0
If these values are part of a larger String, then Johan's method should work. If you still need help, post a packaged workbook, along with a description of what you are trying to accomplish.
Yes, it is part of a larger string with other color values.
Ok - so I finally have a formula that will work - thought I would post it here in case anyone else gets stumped on this.
IF Contains ([Color], "Blue")
AND Contains ([Color], "Dark")=False then 1
Thanks for the suggestions everyone!!
So I spoke too quickly - here is the formula that did finally work:
IF Contains([Color], “Red”) then 0
ELSEIF Contains([Color], “Green”) then 0
ELSEIF Contains ([Color],”Dark”) then 0
Thanks again for the suggestions, and I will mark this as correct now