[milis-belajar-excel] random angka dengan jumlah ditentukan

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] random angka dengan jumlah ditentukan

Praztmath
Dear member milis belajar excel..
Mohon bantuannya, bagaimana formula / rumus membuat angka random dengan jumlah yang ditentukan ( kolom jumlah pada file lampiran )
Terimakasih

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/d5b11428-2d51-4066-9e4e-cca44ed725c5n%40googlegroups.com.

angka random.xlsx (12K) Download Attachment
PRAZTMATH ™
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] random angka dengan jumlah ditentukan

Praztmath
Semoga ada yang berkenan menyentuhnya  D:)

Pada tanggal Rab, 7 Apr 2021 13.58, praztmath <[hidden email]> menulis:
Dear member milis belajar excel..
Mohon bantuannya, bagaimana formula / rumus membuat angka random dengan jumlah yang ditentukan ( kolom jumlah pada file lampiran )
Terimakasih

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/d5b11428-2d51-4066-9e4e-cca44ed725c5n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOFNi%2BDe_R6HcRmfAAJwTC14Kje7oLK_Zh_05xjYnuSHNuvV-g%40mail.gmail.com.
PRAZTMATH ™
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] random angka dengan jumlah ditentukan

Kid
Administrator
In reply to this post by Praztmath

Random bisa dengan :
1. RandBetween (hasilnya bilangan bulat) -> random 1 nilai yang ada di rentang nilai a dan b, 
     misal =RandBetween( 10 , 40 ), hasilnya 1 angka random seperti 31 atau lainnya (yang ada di rentang 10 s.d. 40)
2. Rand (hasilnya bilangan desimal [ada angka di belakang koma]) -> random 1 nilai yang ada di rentang nilai 0 dan 1
    jika ingin hasil random di rentang a dan b (seperti nomor 1), dengan Rand() * (b-a) + a

Kasus ini :
misal angka 150 ingin dipecah jadi 5 bijik angka random, maka :
hitung dulu reratanya, misal 150/5 = 30, berarti random disekitar angka 30, misal di rentang 25 s.d. 30, artinya
angka random ke-1 : =randbetween( 25,30 )   atau   =rand()*( 30-25) + 25
lalu hitung sisanya = 150-angka random ke-1, misal sisa 118/4
sisa slot random ada 4 bijik, rerata di 4 slot ini = 118/4
angka random ke-2 : =randbetween( 118/4 - 5 , 118/4 )     atau   rand()*5+118/4
dst sampai didapat angka random ke-4 (sampai bersisa 1 slot terakhir)
slot terakhir =150-sum( semua angka random yang sudah didapat)

sila dibuat sendiri formulanya di cells.

Regards,
Kid












On Wed, Apr 7, 2021 at 1:58 PM praztmath <[hidden email]> wrote:
Dear member milis belajar excel..
Mohon bantuannya, bagaimana formula / rumus membuat angka random dengan jumlah yang ditentukan ( kolom jumlah pada file lampiran )
Terimakasih

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/d5b11428-2d51-4066-9e4e-cca44ed725c5n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPssF0jtE8RW1RGD1oU9Rjv_hU70qdYO%3D5siTifiB8sk2A%40mail.gmail.com.