# Random number generator

Status
Not open for further replies.

##### New Member
Hi everyone. So I am trying to create a random number generator. Sheet 1 has the cell b4 (which has the formula to generate random number) but on sheet 2 in cell a2, I need a formula that will add 1/3 of the highest number is generating between (so say if my generator was calculating a random number between 1 and 15, sheet two would add 1/3 of 15 (5) onto the random number that was generated. In cell a4 I need a formula to add another 1/3 onto the cell value in a2. I would like all of the numbers to be whole numbers (no decimals) as well and I need the numbers that have added 1/3 onto them to not go above the highest number is generating. Thank you

example if confused

Sheet 1 generates a number between 1 and 30
it generates 26
sheet 2 (A2) adds 1/3 of 30 (10)
because the highest numbers it’s generating between is 30 and the number generated was 26
26+10 = 36 which is OVER 30
so I want it to do 26+10 but when it gets to 30 it goes back to 1 and starts adding the remaining from there

I know this is really complicated but I need someone to help me out please
Thank you

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### Fluff

##### MrExcel MVP, Moderator
Duplicate NEED HELP ASAP

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Status
Not open for further replies.

Replies
1
Views
107
Replies
22
Views
192
Replies
14
Views
221
Replies
7
Views
100
Replies
11
Views
209