» Adjusting Values Returned by the RAND Function
Retrieving two random numbers between 0 and 30, ensuring that the first number (Num1) is always greater than the second one (Num2).
To retrieve Num1, use the INT and RAND functions in the following formula in cell A2:
This ensures an upper limit of 30 for the number generated.
To retrieve Num2, use the INT and RAND functions in the following formula in cell B2:
This ensures the number generated is smaller than Num1.