manual calculatin of the RAND function

Originally Posted by jrtaylor

...Is there a way ...

Not using worksheet functions. Your best bet is a macro (which you can assign to a button). If possible, upload a copy of your workbook.
Remove any sensitive or extraneous info, mainly just show us the formulas that use the RAND() function and the cells that contain them.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now just Browse for your file, then click Upload. Simple!