Forum Discussion

jamesvinicombe's avatar
jamesvinicombe
Copper Contributor
Jul 15, 2022

IF FALSE THEN BLANK

Hello, Im hoping someone could please help me with this formula...   =IF(F2="x",INDEX(M12:M14,RANDBETWEEN(1,ROWS(M12:M14)),1))   If F2 is X, then this cell will select the contents of a random ce...
excel
Formulas and Functions
ImmortalCrabman's avatar
ImmortalCrabman
Copper Contributor
Mar 25, 2024

JoeUser2004 

But the cell isn't truly blank when you do that.  I like the OP, am trying to get the cell to be truly empty.  If you check the cell with the IF formula with a "" in it with ISBLANK it will report false.

 

JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Mar 31, 2024

ImmortalCrabman  wrote:  "I like the OP, am trying to get the cell to be truly empty"

 

A corollary to the adage "people who don't know history are condemned to repeat it"....  Your issue has been thoroughly addressed in the previous responses in this thread.  Read them.

 

Hint:  In my response dated Jul 15 2022 05:36 PM, what did I say about the behavior of Excel ISBLANK and the Excel definition of "empty" cell?

 

But don't take my word for it.  Do a google search for "return empty cell in Excel".

 

PS....  Apparently I was wrong when I speculated that Google Sheets or Open Office has a function that would cause the cell to behave as if it were truly empty.  By that, I mean:  ISBLANK(A1) and A1=0 would return TRUE, and 1*A1 would not return a #VALUE error.

 

Resources