# Generating a random number

1. ## Generating a random number

I need to generate a list of random numbers that are between 1 and 2, to 2 decimal places.

How can I use RANDBETWEEN to do this please?

2. ## Re: Generating a random number

Try this:

=RANDBETWEEN(100,200)/100

Hope this helps.

Pete

3. ## Re: Generating a random number

Like this:

=RANDBETWEEN(100,200)/100

Make sure the cell formatting is set to two decimal places.

Excel 2016 (Windows) 32 bit
A
1
1.38
2
1.16
3
1.49
4
1.71
5
1.01
6
1.24
7
1.70
8
1.38
9
1.44
 Sheet: Sheet2

4. ## Re: Generating a random number

I think
Formula:
`Please Login or Register  to view this content.`

should works.

5. ## Re: Generating a random number

... and then three come along all at once ...

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1