Thanks everyone for your help, but this one: =if(j4>0,"circulate","") & if(k4>0, "drill","") is still defaulting it to "drill" even though other the criteria required is not met.