Every time any cell is edited or a new formula is created,the value generated by the RAND function will change.

Name: Every time any cell is edited or a new formula is created,the value generated by the RAND function will change.
Brand: Quizplus
Rating: 4.9 (30 reviews)

Question

Quizplus · Accepted Answer

The value generated by the RAND function is based on a random seed value which is recalculated every time a change is made to the worksheet. Thus, any edit or new formula can cause the value to change.

Every Time Any Cell Is Edited or a New Formula