Forum Discussion
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...
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.