If cell contains -0 then return blank cell
 

Hi everyone,

I have written the following formula

=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 currently have 'if K11 is less than 0 return "Passed Live Date"

What I do require is

if K11 is 0 to -30(minus 30) return "Passed Live Date"
and
if K11 is -31 to -999 return " "

I have tried to write the above but I can't get it to work, I guess
this is something to do with the number being minus

Hope I have provided enough info

If cell contains -0 then return blank cell
 

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


--
---
HTH

Bob

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



"Angela1979" wrote in message
ps.com...
Hi everyone,

I have written the following formula

=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 currently have 'if K11 is less than 0 return "Passed Live Date"

What I do require is

if K11 is 0 to -30(minus 30) return "Passed Live Date"
and
if K11 is -31 to -999 return " "

I have tried to write the above but I can't get it to work, I guess
this is something to do with the number being minus

Hope I have provided enough info

If cell contains -0 then return blank cell
 

On Feb 28, 11:47 am, "Bob Phillips" wrote:
=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","")))))

--
---
HTH

Bob

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

"Angela1979" wrote in message

ps.com...



Hi everyone,

I have written the following formula

=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 currently have 'if K11 is less than 0 return "Passed Live Date"

What I do require is

if K11 is 0 to -30(minus 30) return "Passed Live Date"
and
if K11 is -31 to -999 return " "

I have tried to write the above but I can't get it to work, I guess
this is something to do with the number being minus

Hope I have provided enough info- Hide quoted text -

- Show quoted text -







Thanks very much Bob
Works just as I need it to.
:-)

If cell contains -0 then return blank cell
 

On Feb 28, 11:36 am, "Angela1979" wrote:
Hi everyone,

I have written the following formula

=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 currently have 'if K11 is less than 0 return "Passed Live Date"

What I do require is

if K11 is 0 to -30(minus 30) return "Passed Live Date"
and
if K11 is -31 to -999 return " "

I have tried to write the above but I can't get it to work, I guess
this is something to do with the number being minus

Hope I have provided enough info

////////////////////////////////////////////////////////////////


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

If cell contains -0 then return blank cell
 

Angela,

You shouldn't, I don't. I put a catchall at the end that will return "" for
any condition other than those specifically tested for.

--
---
HTH

Bob

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



"Angela1979" wrote in message
oups.com...
On Feb 28, 11:36 am, "Angela1979" wrote:
Hi everyone,

I have written the following formula

=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 currently have 'if K11 is less than 0 return "Passed Live Date"

What I do require is

if K11 is 0 to -30(minus 30) return "Passed Live Date"
and
if K11 is -31 to -999 return " "

I have tried to write the above but I can't get it to work, I guess
this is something to do with the number being minus

Hope I have provided enough info

////////////////////////////////////////////////////////////////


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

If cell contains -0 then return blank cell
 

=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