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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Min[/TD]
[TD]Max[/TD]
[TD][/TD]
[TD]Rand[/TD]
[TD]%[/TD]
[TD][/TD]
[TD]Nº uses[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]400[/TD]
[TD][/TD]
[TD]=randbetween(300;400)[/TD]
[TD]calcs the % based in the max value( 400)[/TD]
[TD][/TD]
[TD]x total[/TD]
[/TR]
[TR]
[TD]130[/TD]
[TD]150[/TD]
[TD][/TD]
[TD]=randbetween(130;150)[/TD]
[TD]calcs the % based in the max value( 150)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]90[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]=randbetween(90;100)[/TD]
[TD]calcs the % based in the max value( 100)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]15[/TD]
[TD][/TD]
[TD]=randbetween(10;15)[/TD]
[TD]calcs the % based in the max value( 15)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Min[/TD]
[TD]Max[/TD]
[TD][/TD]
[TD]Rand[/TD]
[TD]%[/TD]
[TD][/TD]
[TD]Nº uses[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]400[/TD]
[TD][/TD]
[TD]=randbetween(300;400)[/TD]
[TD]calcs the % based in the max value( 400)[/TD]
[TD][/TD]
[TD]x total[/TD]
[/TR]
[TR]
[TD]130[/TD]
[TD]150[/TD]
[TD][/TD]
[TD]=randbetween(130;150)[/TD]
[TD]calcs the % based in the max value( 150)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]90[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]=randbetween(90;100)[/TD]
[TD]calcs the % based in the max value( 100)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]15[/TD]
[TD][/TD]
[TD]=randbetween(10;15)[/TD]
[TD]calcs the % based in the max value( 15)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Looking forward for your help!