In cell B2 I have the formula:
Using a script, is there any way I can copy the current results of this RAND function into another cell on the sheet? I want to copy the absolute value, not just mirror the current value.
All attempts I've come up with cause the function to generate a new random number, store that value, then generate yet another random value in cell B2 due to the page being updated.
Ultimately I'd like to click a button that runs a script to store the current value of B2 into another cell.