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

[Shiseiji]

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.

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

 

[Peter_SSs]

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]

Thank you Peter, you caught it! 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]

You're welcome.