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