» Adjusting Values Returned by the RAND Function
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Retrieving two random numbers between 0 and 30, ensuring that the first number (Num1) is always greater than the second one (Num2).
Solution:
Step 1:
To retrieve Num1, use the INT and RAND functions in the following formula in cell A2:
=INT(RAND()*30)+1
This ensures an upper limit of 30 for the number generated.
Step 2:
To retrieve Num2, use the INT and RAND functions in the following formula in cell B2:
=INT(RAND()*A2)
This ensures the number generated is smaller than Num1.
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Inside Out
- Financial Statement Analysis with S&P insert card
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Analysis of Financial Statements
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
