Forum Discussion
IF FALSE THEN BLANK
jamesvinicombe wrote: ``I have tried adding ,"" at the end and it does not work.``
Perhaps if you showed us what you typed (copy-and-paste from the Formula Bar), we could explain what you did wrong.
The following should work (copy-and-paste):
=IF(F2="x",INDEX(M12:M14,RANDBETWEEN(1,ROWS(M12:M14)),1) , "" )
(Works for me.)
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.
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.