This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. For example, if you want to generate a random number between 100 and 110, you must type "=rand()*10+100". 10 is the difference between 110 and 100 and 100 is the lower limit. You can generate new numbers by pressing the F9 button.
- Hot
- Latest
-
How To: Find a P-Value with Excel
-
How To: Create a Basic Attendance Sheet in Excel
-
How To: Enter formulas in Excel with a macro
-
How To: Create a pass-fail grade formula in Microsoft Excel
-
How To: Create a simple database in Excel with a list or table
-
How To: Calculate income tax payroll deductions in MS Excel
-
How To: Cross tabulate categorical data in Microsoft Excel
-
How To: Graph the probability density function in an Excel file
-
How To: Fix common Excel spreadsheet problems & errors
-
How To: Create a weighted gradebook in Microsoft Excel
-
How To: Make a checklist form in MS Word 2007
-
How To: Create an Excel spreadsheet to calculate your GPA
-
How To: Clear data & cell contents in Excel using a macro
-
How To: Extract records that meet certain criteria in Excel
-
How To: Identify the first occurrence of a value in a column in Microsoft Excel
-
How To: Compare two lists and extract the new values in Excel
-
How To: Change Excel options directly in the Registry
-
How To: Calculate proportions and percentages in Excel
-
How To: Remove empty space when converting an Excel file to a PDF document
-
How To: Find a P-Value with Excel
-
How To: Create a Basic Attendance Sheet in Excel
-
How To: Enter formulas in Excel with a macro
-
How To: Create a pass-fail grade formula in Microsoft Excel
-
How To: Create a simple database in Excel with a list or table
-
How To: Calculate income tax payroll deductions in MS Excel
-
How To: Cross tabulate categorical data in Microsoft Excel
-
How To: Graph the probability density function in an Excel file
-
How To: Fix common Excel spreadsheet problems & errors
-
How To: Create a weighted gradebook in Microsoft Excel
-
How To: Make a checklist form in MS Word 2007
-
How To: Create an Excel spreadsheet to calculate your GPA
-
How To: Clear data & cell contents in Excel using a macro
-
How To: Extract records that meet certain criteria in Excel
-
How To: Identify the first occurrence of a value in a column in Microsoft Excel
-
How To: Compare two lists and extract the new values in Excel
-
How To: Change Excel options directly in the Registry
-
How To: Calculate proportions and percentages in Excel
-
How To: Remove empty space when converting an Excel file to a PDF document
2 Comments
Nice work rawhy
My exel data
Share Your Thoughts