| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a value to a cell that is blank | Excel Discussion (Misc queries) | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
| return a blank cell | Excel Worksheet Functions | |||
| use IF to return a truly blank cell | Excel Discussion (Misc queries) | |||
| return zero from a blank cell | Excel Worksheet Functions | |||
Linear Mode
