NEED HELP ASAP

[adurham22926192]

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

 

[Eric W]

See if this works for you:

Book1
	A	B	C	D	E
3	Max	Random		Adding 1/3	Adding 2/3
4	30	26		6	16
Sheet7

Cell Formulas
Range	Formula
B4	B4	=RANDBETWEEN(1,A4)
D4	D4	=MOD(INT(B4+A4/3)-1,A4)+1
E4	E4	=MOD(INT(B4+2*A4/3)-1,A4)+1