| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISBLANK FUNCTION
I am using ISBLANK in a formula and it keeps returning "false" when it should
be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
If you have a formula in CD15 then it is not blank and Excel will return
FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
How do I find out if I have invisible characters?
"Peo Sjoblom" wrote: If you have a formula in CD15 then it is not blank and Excel will return FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
Hi Bill
Try =LEN(CD15) If it is 0, then there is nothing in the cell. If greater than 0, then there is something there. If you use =CODE(CD15) then if it contains a space it will return 32, or the ascii code for the character that is there. It will return #VALUE if the cell is empty. -- Regards Roger Govier "Bill R" wrote in message ... How do I find out if I have invisible characters? "Peo Sjoblom" wrote: If you have a formula in CD15 then it is not blank and Excel will return FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
Just 2 cents. If A1 just has an apostrophe '
=ISBLANK(A1) returns False, but =LEN(A1) returns 0. -- Dana DeLouis Windows XP & Office 2007 "Roger Govier" wrote in message ... Hi Bill Try =LEN(CD15) If it is 0, then there is nothing in the cell. If greater than 0, then there is something there. If you use =CODE(CD15) then if it contains a space it will return 32, or the ascii code for the character that is there. It will return #VALUE if the cell is empty. -- Regards Roger Govier "Bill R" wrote in message ... How do I find out if I have invisible characters? "Peo Sjoblom" wrote: If you have a formula in CD15 then it is not blank and Excel will return FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
Hi Dana
Thanks for drawing my attention to that. I had not realised it returned 0 length. Equally, =CODE(A1) returns #VALUE. -- Regards Roger Govier "Dana DeLouis" wrote in message ... Just 2 cents. If A1 just has an apostrophe ' =ISBLANK(A1) returns False, but =LEN(A1) returns 0. -- Dana DeLouis Windows XP & Office 2007 "Roger Govier" wrote in message ... Hi Bill Try =LEN(CD15) If it is 0, then there is nothing in the cell. If greater than 0, then there is something there. If you use =CODE(CD15) then if it contains a space it will return 32, or the ascii code for the character that is there. It will return #VALUE if the cell is empty. -- Regards Roger Govier "Bill R" wrote in message ... How do I find out if I have invisible characters? "Peo Sjoblom" wrote: If you have a formula in CD15 then it is not blank and Excel will return FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
Hi Roger. Another interesting variation is that both return True below if
A1 just has an apostrophe ' Sub Demo() Debug.Print [A1] = "" Debug.Print [A1].PrefixCharacter < "" End Sub Returns: True True -- Dana DeLouis "Roger Govier" wrote in message ... Hi Dana Thanks for drawing my attention to that. I had not realised it returned 0 length. Equally, =CODE(A1) returns #VALUE. -- Regards Roger Govier "Dana DeLouis" wrote in message ... Just 2 cents. If A1 just has an apostrophe ' =ISBLANK(A1) returns False, but =LEN(A1) returns 0. -- Dana DeLouis Windows XP & Office 2007 "Roger Govier" wrote in message ... Hi Bill Try =LEN(CD15) If it is 0, then there is nothing in the cell. If greater than 0, then there is something there. If you use =CODE(CD15) then if it contains a space it will return 32, or the ascii code for the character that is there. It will return #VALUE if the cell is empty. -- Regards Roger Govier "Bill R" wrote in message ... How do I find out if I have invisible characters? "Peo Sjoblom" wrote: If you have a formula in CD15 then it is not blank and Excel will return FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISBLANK FUNCTION
Hi Dana
From XL2007 VBA Help If the TransitionNavigKeys property is False, this prefix character will be ' for a text label, or blank. Since the leading apostrophe sets the cell to Text format, then the second True in your code is to be expected. -- Regards Roger Govier "Dana DeLouis" wrote in message ... Hi Roger. Another interesting variation is that both return True below if A1 just has an apostrophe ' Sub Demo() Debug.Print [A1] = "" Debug.Print [A1].PrefixCharacter < "" End Sub Returns: True True -- Dana DeLouis "Roger Govier" wrote in message ... Hi Dana Thanks for drawing my attention to that. I had not realised it returned 0 length. Equally, =CODE(A1) returns #VALUE. -- Regards Roger Govier "Dana DeLouis" wrote in message ... Just 2 cents. If A1 just has an apostrophe ' =ISBLANK(A1) returns False, but =LEN(A1) returns 0. -- Dana DeLouis Windows XP & Office 2007 "Roger Govier" wrote in message ... Hi Bill Try =LEN(CD15) If it is 0, then there is nothing in the cell. If greater than 0, then there is something there. If you use =CODE(CD15) then if it contains a space it will return 32, or the ascii code for the character that is there. It will return #VALUE if the cell is empty. -- Regards Roger Govier "Bill R" wrote in message ... How do I find out if I have invisible characters? "Peo Sjoblom" wrote: If you have a formula in CD15 then it is not blank and Excel will return FALSE Try this instead =IF(Sheet1!CD15="","",Sheet1!BU6) If you don't have a formula in CD15 then you must have invisible characters in the cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bill R" wrote in message ... I am using ISBLANK in a formula and it keeps returning "false" when it should be returning "true", because (SHEET1!CD15) is blank. What could be causing this problem? This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6) Thanks, Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function??? | Excel Worksheet Functions | |||
| ISBLANK() function | New Users to Excel | |||
| isblank function | Excel Worksheet Functions | |||
| Is there a function for "not isblank" (find a cell that has a val. | Excel Worksheet Functions | |||
| ISBLANK | Excel Worksheet Functions | |||
Linear Mode
