random decimal

  • Thread starter Thread starter j_cotter
  • Start date Start date
J

j_cotter

I would like to add random decimals to one column in excel.
for example: 5.0 into 5.3, 10.0 into 10.1 and so on. Is this
possible?
Thank you for any info you may have.
 
In the column next to your existing coulmn add
=TRUNC(RAND(),1)+{your column with data}, say B1 etc
 
Do you already have 5.0 and 10.0 entered in some cells?

If so, here's one way...

Enter this formula in some cell, assume X1:

=ROUND(RAND(),1)

Assume the numbers you want to change are in the range A1:A5

Select cell X1
Goto Edit>Copy
Select the range A1:A5
Goto Edit>Paste Special>Add>OK
With A1:A5 still selected
Goto Edit>Copy
Then Edit>Paste Special>Values>OK

Delete cell X1
 
Do you already have 5.0 and 10.0 entered in some cells?

If so, here's one way...

Enter this formula in some cell, assume X1:

=ROUND(RAND(),1)

Assume the numbers you want to change are in the range A1:A5

Select cell X1
Goto Edit>Copy
Select the range A1:A5
Goto Edit>Paste Special>Add>OK
With A1:A5 still selected
Goto Edit>Copy
Then Edit>Paste Special>Values>OK

Delete cell X1

--
Biff
Microsoft Excel MVP






- Show quoted text -
Click to expand...

The column that I am trying to add the random decimals to is filled
with data. The data ranges from 3.0 to 40.0 I want to add the
decimals to this column so that each number has one decimal palce,
from 0 to 9. ex: 3.2 or 40.7
The first suggested formula i was given filled the cell with #######.
The second suggested formula just made a Zero.
I am not fluent in excel so if there is a part of the formula that you
do not show because it is obvious to most, please show.
Thank-you for your help
JC
 
Alright, let's try a different approach.

Assume your numbers are in the range A1:A5
Enter this formula in B1:

=A1+ROUND(RAND(),1)

Copy down to B5
Select the range B1:B5
Goto Edit>Copy
Then, Edit>Paste Special>Values>OK

Now, you can replace the original data, A1:A5, with the new modified data in
B1:B5.


--
Biff
Microsoft Excel MVP


Do you already have 5.0 and 10.0 entered in some cells?

If so, here's one way...

Enter this formula in some cell, assume X1:

=ROUND(RAND(),1)

Assume the numbers you want to change are in the range A1:A5

Select cell X1
Goto Edit>Copy
Select the range A1:A5
Goto Edit>Paste Special>Add>OK
With A1:A5 still selected
Goto Edit>Copy
Then Edit>Paste Special>Values>OK

Delete cell X1

--
Biff
Microsoft Excel MVP






- Show quoted text -
Click to expand...

The column that I am trying to add the random decimals to is filled
with data. The data ranges from 3.0 to 40.0 I want to add the
decimals to this column so that each number has one decimal palce,
from 0 to 9. ex: 3.2 or 40.7
The first suggested formula i was given filled the cell with #######.
The second suggested formula just made a Zero.
I am not fluent in excel so if there is a part of the formula that you
do not show because it is obvious to most, please show.
Thank-you for your help
JC
 
Hi,

I think that this is what you want, suppose your numbers are in the range
A1:A100 then

1. enter this formula in an empty column, say B1:

=RANDBETWEEN(1,9)*0.1

2. Copy this formula down to B100
3. Select all the formulas and choose Copy
4. Select the range A1:A100 and choose Edit, Paste Special and turn on
Values and turn on Add, then click OK.
5. Get rid of the formulas in column B

If this helps, please click the Yes button.
 
Back
Top