>You can do something like that:
 >
 >=If(OR(C4="";C4="end");"off";IF(OR(C4="start";C4="work");"work";"off"))
 >Put that in cell C5 (that's where I started) and copy it wherever you 
 >need it
 >
 >It will fill out all cells with "off" if the cell above is anything 
 >but "start"
 >or "work", and anything after "end" is "off" again.
 >

Similar effect would be with this formula in the cell C5:
   =if((C4<>"---start")*(C4<>"work");"off";"work")
or, if the list separator is not";" but "," :
   =if((C4<>"---start")*(C4<>"work"),"off","work")

Post a reply to this message