Forum Discussion

jangilbert's avatar
jangilbert
Copper Contributor
Dec 07, 2023

excel

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

Resources