That is what I thought, and why I don't understand the follow-up posting(s).

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Toppers" wrote in message
...
Bob,
Your original was(is) OK but when I first tested it, it didn't
appear to work so I guess it was down to my finger trouble!

"Bob Phillips" wrote:

Angela,

As I said in the other thread, I get "" when K11 is blank. I have a
catchall
at the end for any other value, which would include "".

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Angela1979" wrote in message
oups.com...
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