=IF(or(K11<-30,k11=""),"",IF(K11<0,"Passed Live
Date",IF(AND(K11<=7,K11=1),"Within One Week",
IF(AND(K11<=14,K11=8),"Within Two Weeks",IF(K11=15,"Over Two
Weeks","")))))

Hi Bob,

Sorry one more thing, I am now getting "Value" if the cell (cell that
contains the number) is blank.
I need =if(k11="","")

Many Thanks