Excel Tip: Generate a random value between two limits in Microsoft Excel / Microsoft Excel Tips / ExcelTip.com

Tip Printed from ExcelTip.com

Generate a random value between two limits in Microsoft Excel

Enter the following values in cell A1 and A2: 65, 84 (these values will act as the lower and upper bound limits)

Enter the following formula in cell B1: =RANDBETWEEN(A1,A2)

A random number between 65 and 84 will be generated