Forum Discussion
jangilbert
Dec 07, 2023Copper Contributor
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
- djclementsSilver Contributor