Random number generator

Status
Not open for further replies.

adurham22926192

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

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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).
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top