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