| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reset a range of cells to zero | Excel Discussion (Misc queries) | |||
| reset certain cells to a default value | Excel Worksheet Functions | |||
| reset cells to 0 all at once | New Users to Excel | |||
| reset cells | Excel Discussion (Misc queries) | |||
| reset values in select cells | Excel Discussion (Misc queries) | |||
Linear Mode
