Dynamic Range

D

Dave

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.
 
B

BoniM

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning " 3
Excel formula / IF function 5
SUMIF "value if false" not working 2
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
Conditional formula 3
Adding Cells, Get Error. 2
IF Date range formula 4

Top