Get instant live expert help on rand between excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Want to set up a translations quiz, using rand between and vlookups, all working fine, except when i go to submit an answer the rand between changes value and makes my answer wrong, have tried a nested if, but circular reference, how can I only get the rand between to change when the answer is correct?
Solved by B. F. in 30 mins
I need help using the RAND function and applying specific conditions
Solved by E. J. in 15 mins
Hello I need help with rand() concept. please can you help me with it
Solved by F. Q. in 12 mins
I'm on excel and I've got this sheet. On this sheet I get an output that varies according to the values chosen above, which are constantly changing because of the rand value attached
Solved by T. S. in 27 mins
Not sure what the syntax error is with this formula IF(AND(C11<>"No", D11="Yes") OR(C11="No"),IF(RAND()<1-$B$4,"Yes","No"),"")
Solved by D. S. in 21 mins