Random number generator

Status
Not open for further replies.

adurham22926192

New Member
Joined
Dec 17, 2019
Messages
25
Office Version
  1. 2019
Platform
  1. Windows
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
 

Some videos you may like

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
Joined
Jun 12, 2014
Messages
47,960
Office Version
  1. 365
Platform
  1. Windows
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.

Watch MrExcel Video

Forum statistics

Threads
1,113,747
Messages
5,543,974
Members
410,587
Latest member
kaloybulan
Top