I am making an excel sheet for process efficiency.
how can I generate random numbers between the value of 1% to 3% for the sheet.
the value would affect only one cell (G6), but other cells are dependant on the value this cell assumes.
I have tried to use the rand function but it generates very different values , I just want between 1 to 3 % for the cell number G6
2006-09-14 14:26:43 · 3 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Rand() will give you a number between 0 and 1. You just need to scale it and offset it to fall within your selected range. Your cell code for that is =RAND()*0.02+0.01. .02 is the range of the values, and since you want to start at 1%, you add .01. Format as a percentage and there you are.
This will generate a random value between 1% and 3% whenever you open the file or recalc (F9) the sheet.
2006-09-14 14:33:28 · answer #1 · answered by injanier 7 · 3⤊ 0⤋
It is RAND, do not search more
The only trick is to get a number between your limits instead of 0 and 1
So, it should be something like this
=(RAND()*3+1)/100
XLMan
2006-09-14 23:45:01 · answer #2 · answered by Anonymous · 0⤊ 1⤋
If you load the Analysis ToolPak add-in, you can use:
=RANDBETWEEN(1,3) * 0.01
-Tools | Add-ins...
-Check Analysis ToolPak
-Click OK
2006-09-14 15:54:55 · answer #3 · answered by O Caçador 6 · 1⤊ 0⤋