Hi!
I´m doing a personal project, where it runs a randbetween values and print if it's >= 95%.
Here's an example
I have an Item. That has alues that can go min-max and an item that can change those values.
What i want is, for the excel to loop untill it hits a % of 93 or more and print how many times it used the item to calculate.
I've been using a code but it loops forever and don't print anything.
Cells
A1 A2 A4 A5 A7
<tbody>
</tbody>
Looking forward for your help!
I´m doing a personal project, where it runs a randbetween values and print if it's >= 95%.
Here's an example
I have an Item. That has alues that can go min-max and an item that can change those values.
What i want is, for the excel to loop untill it hits a % of 93 or more and print how many times it used the item to calculate.
I've been using a code but it loops forever and don't print anything.
Cells
A1 A2 A4 A5 A7
Min | Max | Rand | % | Nº uses | ||
300 | 400 | =randbetween(300;400) | calcs the % based in the max value( 400) | x total | ||
130 | 150 | =randbetween(130;150) | calcs the % based in the max value( 150) | |||
90 | 100 | =randbetween(90;100) | calcs the % based in the max value( 100) | |||
10 | 15 | =randbetween(10;15) | calcs the % based in the max value( 15) |
<tbody>
</tbody>
Looking forward for your help!