Cell is Blank/Null yet IF(Cell ="" , "" , "Do Something") Always Renders "Do Something"

Shiseiji

Board Regular
Joined
Oct 23, 2009
Messages
132
I'm working on a file to pass to others to fill out. There is a hidden worksheet that references filled out worksheet. I'm using OFFSET to try and minimize errors if entries are moved around the visible worksheet. I need to append text to one cell, but because the worksheet will be uploaded to an application, the rows not used must not have data, formulas are fine. I've tried everything below, and they all return "TEXT". The cell is formatted General, and I've used [Delete] and copied in a known null cell to ensure the reference cell is blank. Here is what I've tried, obviously I'm missing something.

Code:
Testing the cell
=LEN(OFFSET(LOGON,2,0,1,1)) ="0"
=COUNTBLANK(OFFSET(LOGON,2,0,1,1)) ="1"

=IF(OFFSET(LOGON,2,0,1,1)="", "", OFFSET(LOGON,2,0,1,1)) &"TEXT"
=IF(ISBLANK(OFFSET(LOGON,2,0,1,1)),"",OFFSET(LOGON,2,0,1,1)) &"TEXT"
=IF(LEN(OFFSET(LOGON,2,0,1,1))<=2, "", OFFSET(LOGON,2,0,1,1)) &"TEXT" 
=IF(COUNTBLANK(OFFSET(LOGON,2,0,1,1))=1,"",OFFSET(LOGON,2,0,1,1)) &"TEXT"
TIA, Ron
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,646
Office Version
365
Platform
Windows
I'm not certain that I am following but it looks to like you have misplaced the &"TEXT" in your formulas and that should be inside the last parenthesis. That is ..

=IF(OFFSET(LOGON,2,0,1,1)="", "", OFFSET(LOGON,2,0,1,1)&"TEXT")
=IF(ISBLANK(OFFSET(LOGON,2,0,1,1)),"",OFFSET(LOGON,2,0,1,1)&"TEXT")
etc
 

Shiseiji

Board Regular
Joined
Oct 23, 2009
Messages
132
Thank you Peter, you caught it! (y) Bank Holiday (Labor Day, where we pretend that we honor the hard won rights of our forerunners as the legislature reverses those gains. And I've been labor and management) here in the US, please pardon the delayed Thanks!!!! When the day comes that you decide you must pack it in, you will be sorely missed!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,646
Office Version
365
Platform
Windows
You're welcome. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,755
Members
406,497
Latest member
Bryanlim

This Week's Hot Topics

Top