If cell blank return a blank

[Angela1979]

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

 

[Toppers]

Try:

=IF(ISBLANK(K11),"",IF(K11<-30,"",IF(K11<0,"Passed
LiveDate",IF(AND(K11<=7,K11>=1),"Within
OneWeek",IF(AND(K11<=14,K11>=8),"Within Two Weeks",IF(K11>=15,"Over
TwoWeeks",""))))))

HTH

 

[Bob Phillips]

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)

 

[Joel]

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",""))))))

 

[Bob Phillips]

Did you try my original, I don't see the problem?

Bob

 

[Toppers]

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!

 

[driller]

Hi angela1979,

if k11 is blank, the if formula will read k11 as 0.

maybe something like this
=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","")))))

what if K11 = 0, what result do you need?
it seems you have numbers ranging from -30 upto +15 or more...
hence i assume that if k11 =-30 up to 0, <integers> you may need a result
="Passed Live Date"

just guessing
regards

 

[Bob Phillips]

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)

 

[Angela1979]

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)







- Show quoted text -

Sorry all
I did reply to this and my update doesn't seem to be here
Sorry Bob, the details you gave me the first time round did worked,
was my error.
Thanks for your help