excel

Copper Contributor

I am working on a spreadsheet. My assignment is to: combine the IF and Rand functions into formulas in cells H3:H27 that display True if the value is less than 0.3 and false. I have been struggling and struggling with this.  I put the formula in H3 cell and tried to bring it down and it come up with other things.  I have tried different things but I am unsuccessful. =RandIF(H3:h23,"<0.3")  ????

Can someone help me?

1 Reply

@jangilbert Try this in cell H3:

 

=IF(RAND()<0.3,TRUE)

 

...then drag/copy down to cell H27.