adurham22926192
New Member
- Joined
- Dec 17, 2019
- Messages
- 49
- Office Version
- 2019
- Platform
- 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
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