Reset Cells Value
 

There are formulas in 4 cells to choose a number randomly for each one.
I wrote an IF formula to check them if they are not equal then shows "PLAY".
But I don't know the function to reset (Referesh) cells when they are equal.
Please advise.

Reset Cells Value
 

press F9 to recalculate

"Arfa" wrote:

There are formulas in 4 cells to choose a number randomly for each one.
I wrote an IF formula to check them if they are not equal then shows "PLAY".
But I don't know the function to reset (Referesh) cells when they are equal.
Please advise.

Reset Cells Value
 

Dear cm,

Many thanks for your reply.

Please let me know if there is a function or formula to press F9
automatically.
Please advise.


"cm" wrote:


press F9 to recalculate

"Arfa" wrote:

There are formulas in 4 cells to choose a number randomly for each one.
I wrote an IF formula to check them if they are not equal then shows "PLAY".
But I don't know the function to reset (Referesh) cells when they are equal.
Please advise.