Random Decimal Numbers

[ThomasTrain]

All:
How can I generate a random decimal number (2 decimal accuracy) between 1.4 and 2.5?

Thanks in advance

[MrShorty]

From Excel's help file for the RAND() function (https://support.microsoft.com/en-us/...0-021ea9f5be73 ):

To generate a random real number between a and b, use:
=RAND()*(b-a)+a

. Nest that inside of a ROUND() function to round to the desired number of decimal places, or use number formatting to display to the desired number of decimal places (depending on exactly what you need the cell's value to be).

[Fluff13]

How about

Please Login or Register  to view this content.