HELP! Adding numbers from 7000 - 60,000 Automatically

I need to create a log that will generate a number between 7000 to 60,000 in two columns and it will add random number between 15 - 60 on each row to that value

For example:

A1 | B1
___________
7000 | 7015
7015 | 7030
7030 | 7045

This will add value of 15.


So, is it possible to do this? if so, I will like to start A1 with 7000 and add a random value between 15-60 to B1 and continue down till it reaches 60,000. Help Please I've been doing this manually with the =A1+15 or =A2+20 or =A3+30 or =A4+40 function on each row and its taking me forever and don't know of any other way. Any help will be greatly appreciated.

Thanks so much but I want the value to go from A1 to B1 and then continue on A2 to B2 like in the example.

It's not working out for me

Thank You Soooo much Ace_XL you're awesome

Originally Posted by Ace_XL

See attached...

Sorry but I just notice that the numbers on A2 doesn't follow the continuance from B1 which tells me that is not possible or is it? like from A1-B1 7000 - 7015 then from A2 it should continue from B1 so it would be 7015. In other words I want the number that generates in B1 to carry over to the next row which in this case would be A2.

A1 | B1
__________
7000 - 7015
A2 | B2
__________
7015 - (random number) <------ so this random number will carry to A3 column and so on

I'm really sorry for the confusion

Sorry but I just notice that the numbers on A2 doesn't follow the continuance from B1 which tells me that is not possible or is it? like from A1-B1 7000 - 7015 then from A2 it should continue from B1 so it would be 7015. In other words I want the number that generates in B1 to carry over to the next row which in this case would be A2.

A1 | B1
__________
7000 - 7015
A2 | B2
__________
7015 - (random number) <------ so this random number will carry to A3 column and so on

I'm really sorry for the confusion

That didn't work the numbers on A column are still random and don't follow from B column

Originally Posted by ChemistB

A2 copied down column A would be
=IF(ISNUMBER(B1),B1,"")

From your example, it looks like once the random number is generated in B1 (adding between 15 to 60 to A1), you continue to use that number all the way down. Is that correct?
If so,
in B2 copied down
=IF(A2+($B$1-$A$1)>60000, "", A2+$B$1-$A$1)
does that work for you?

This worked but all the random values are the same (it doesn't generate a random value between 15-60)

If you want column A to reflect the random number generated in B1, then use =B1 in cell A2 and fill down.

Terry

see attached piclog_.jpg

Originally Posted by ChemistB

See the attachment

All the random numbers are all the same value is it possible to change those values to different numbers for each row? Thanks in advance

Originally Posted by puchimo

All the random numbers are all the same value is it possible to change those values to different numbers for each row? Thanks in advance

All the values are 39 and it doesn't generate randomly

Originally Posted by martindwilson

try this then,please take time to read all replies not just the ones you think may work!

Thanks this one worked!

Originally Posted by martindwilson

see post #16

I try that but the random number its all the same for all the rows. I like to have different numbers generate and not the same on all rows.

How can I stop the values in the formula from changing every time I add content to the table? Whenever I add a row or column the value changes randomly, I want to stay at a value and not change at all.