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
jamesvinicombe's avatar
jamesvinicombe
Copper Contributor
Jul 15, 2022
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!
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Jul 15, 2022

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.

 

Resources