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
|