LinkBack URL
About LinkBacks
Does anyone know how make a formula, like =isblank, read blank cells as blank even though there is a formula inside the cell?
Does anyone know how make a formula, like =isblank, read blank cells as blank even though there is a formula inside the cell?
Nope.
If a cell contains a formula, it is NOT considered blank. Period.
instead of using ISBLANK, it's generally best to use ="" or LEN()=0 to test if a cell is blank.
=IF(A1="","it's blank","it's not blank")
=IF(LEN(A1)=0,"it's blank","it's not blank")
These will work when A1 is populated by a formula that returns ""
Instead of ISBLANK use
=A1=""
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks you!
You're Welcomes
Another way to do this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks