| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BLANK as a Formula result.
Does Excel have a way to produce a cell that it recognizes
as BLANK as a result of a formula? ="" works to clear the display, but it reads FALSE on an ISBLANK() test. For example... in cell A1: =IF(TRUE,"",1) in cell A2: =ISBLANK(A1) Cell A2 will return FALSE in this example. Is there any way to change the "" in cell A1 so that cell A2 will return TRUE? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BLANK as a Formula result.
I can't think of one, but you could use:
=IF(A1="",TRUE,FALSE) Rather than =ISBLANK(A1) -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BLANK as a Formula result.
In A2:
=A1="" Cheers, Dave -----Original Message----- Does Excel have a way to produce a cell that it recognizes as BLANK as a result of a formula? ="" works to clear the display, but it reads FALSE on an ISBLANK() test. For example... in cell A1: =IF(TRUE,"",1) in cell A2: =ISBLANK(A1) Cell A2 will return FALSE in this example. Is there any way to change the "" in cell A1 so that cell A2 will return TRUE? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Differenec formula: Dnt need '0' as a result;Rather have a blank c | Excel Worksheet Functions | |||
| I need a gap when the result of a formula is blank or zero | Charts and Charting in Excel | |||
| formula result blank | Excel Worksheet Functions | |||
| Pasteing formula gives blank result | Excel Worksheet Functions | |||
| How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
Linear Mode
