If cell blank return a blank
 

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

If cell blank return a blank
 

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

"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

If cell blank return a blank
 

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

If cell blank return a blank
 

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

If cell blank return a blank
 

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

Bob



"Toppers" wrote in message
...
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

"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

If cell blank return a blank
 

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

If cell blank return a blank
 

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



--
*****
birds of the same feather flock together..



"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

If cell blank return a blank
 

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

If cell blank return a blank
 

On Feb 28, 11:37 pm, "Bob Phillips" wrote:
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
groups.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- Hide quoted text -

- 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