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...
Youre a star! It worked, I was missing a space after the apostrophies at the end!
Now I have an issue whereby the formula below does not work...
=IF(M11="3","x","")
M11 is a cell with a SUM in it.
And the cell that I put the formula in is blank at the moment, any ideas what to do?
Thanks for your help!
Now I have an issue whereby the formula below does not work...
=IF(M11="3","x","")
M11 is a cell with a SUM in it.
And the cell that I put the formula in is blank at the moment, any ideas what to do?
Thanks for your help!
jamesvinicombe wrote: ``It worked, I was missing a space after the apostrophies at the end!``
Those are double-quotes. And the spaces should not matter. I typed it that way just to improve readability. Please try again, copy-and-pasting the following:
=IF(F2="x",INDEX(M12:M14,RANDBETWEEN(1,ROWS(M12:M14)),1),"")
-----
jamesvinicombe wrote: ``=IF(M11="3","x","")``
[.... removed .... Looks like this was ask-and-answered in separate thead. Please do not that. Or if you do, please come back and update this thread. Otherwise, it wastes people's time.]
PS.... On second thought, maybe I misunderstood your first comment above re ``I was missing a space``. Obviously, you do not have (unnecessary) spaces in your M11=3 formula. So you "must" understand that they are optional.