![]() Formula syntax is easy, it has a bottom and top range numbers. To get a random non-decimal number between the top and bottom numbers we can use RANDBETWEEN function. Use RANDBETWEEN Function to Get Random Non-Decimal Number As a result, the final number is a random decimal number between 1 and 10. When RAND function result is 0 formula output is number 1, and when the RAND function result is number 1 formula output is number 10. How to use RAND in Excel to get a random decimal numberīecause we want a decimal number, top number 10 should be subtracted with number 1 and multiplied with RAND function result that is always a decimal number between 0 and 1. Copy the formula down by dragging icon “+” of the cell, as explained in the example above.įigure 2. Select the cell D3 and insert the formula: =1+9*RAND(). In our example, we want to get a random decimal number between 1 and 10. Logic is the same if we want to RANDBETWEEN decimal numbers in Excel that are in the other number range than 0 and 1. To prevent this we can copy random numbers between decimals with Ctrl+C and paste them as values (right mouse click and Paste Options: Values ). Note that this function is volatile, and whenever we click on another cell random numbers will change.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |