How to Keep Random Numbers from Changing in Excel

How to Fix Random Numbers in Excel: Stop Changing RAND and RANDBETWEEN Results
Excel's "RAND" and "RANDBETWEEN" functions are incredibly useful for generating random numbers. However, one of their inherent characteristics is that they recalculate and produce new random numbers every time the worksheet recalculates. This can be problematic when you must keep the random numbers static after they are generated. In this intermediate Excel tutorial, we will explore how to fix the results of these functions by converting the formula results into values.

Understanding RAND and RANDBETWEEN Functions
RAND Function: This function generates a random decimal number between 0 and 1.
=RAND()
RANDBETWEEN Function: It generates an integer number between the two specified numbers (inclusive) randomly.
=RANDBETWEEN(bottom, top)

Problem with Dynamic Recalculation
Every time you make a change in the worksheet or press F9 (to recalculate), the numbers generated by the "RAND" and "RANDBETWEEN" functions will change. To prevent this, you can convert the formula results to static values.

Converting Formula Results to Values
Here's a step-by-step guide to convert the random numbers into static values:

Step 1: Generate Random Numbers
First, generate your random numbers using the "RAND" or "RANDBETWEEN" function.

Example with RAND:
1. In cell A1, enter the formula “=RAND()”.
2. Use the autofill feature to fill more cells with random numbers as needed. You can do that by dragging the fill handle.

Example with RANDBETWEEN:
1. In cell A1, enter the formula “=RANDBETWEEN(1, 100)”.
2. Use the autofill feature to fill more cells with random numbers as needed. You can do that by dragging the fill handle.

Step 2: Select the Generated Numbers
Once you have your random numbers, select the cells containing the numbers you want to keep static.

*Step 3: Copy the Selected Cells
With the cells selected, right-click on it. The context menu will open and now click on Copy , or you can press "Ctrl + C".

Step 4: Paste as Values
Now, you need to paste the copied numbers as static values:
1. Right-click on the first cell of the range where you want to paste the values.
2. From the context menu, choose *Paste Special*.
3. Select Values in the Paste Special dialog box.
4. Click *OK*.
There are more ways to do this and here is how:    • 6 Ways To Convert Formula to Values i...  
By converting the results of the "RAND" and "RANDBETWEEN" functions into static values, you can ensure that your random numbers remain constant, avoiding unwanted changes due to worksheet recalculations. This simple process of copying and pasting as values can help maintain the integrity of your data and make your Excel workbooks more reliable.
#Freeze #RandomNumber #ExcelTutorial


Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:

Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Intermediate Excel Tutorial: https://tinyurl.com/59a837py
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial