The IF(K11="","") should work. did you try this

=IF(K11="","",if(K11<-30,"",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",""))))))

"Angela1979" wrote:

Hi Everyone

I have the following formula, Bob on here kindly help me to write

=IF(K11<-30,"",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","")))))

I now required a formula to say if the cells is blank return blank, i
have tried writting this as IF(K11="","") but it won't work.


Thanks