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...
JoeUser2004 I am having the same issue with the below formula, showing FALSE when I just want it blank
=IF(OR(B250="T2R",B250="T1R"),IF(AND(O250>=24),O250-24,0))
And the root cause is the same: you are lacking a value-if-false part.
Perhaps you simply want:
=IF(OR(B250="T2R",B250="T1R"),IF(AND(O250>=24),O250-24,0) , "" )
or simply:
=IF(OR(B250="T2R",B250="T1R"), MAX( O250-24, 0 ) , "" )