| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Range
Hi,
Cell A1=7 Cell B1=IF(A1=7,"","Not 7") Under these conditions, Cell B1 is blank. But apparently it's not really blank. If I make C1= ISBLANK(B1), C1 returns FALSE. If "" doesn't give a real blank cell, what does? Regards - Dave. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic Range
B1 contains a formula... deleting it is the only want to make a real blank
cell. ISBLANK will only return true for an empty cell. Instead of ISBLANK(B1), try =IF(B1="",TRUE, FALSE) "Dave" wrote: Hi, Cell A1=7 Cell B1=IF(A1=7,"","Not 7") Under these conditions, Cell B1 is blank. But apparently it's not really blank. If I make C1= ISBLANK(B1), C1 returns FALSE. If "" doesn't give a real blank cell, what does? Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range | Charts and Charting in Excel | |||
| Dynamic SUM range | Excel Worksheet Functions | |||
| Dynamic range | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| dynamic range | Excel Discussion (Misc queries) | |||
Hybrid Mode
