Jifunze jinsi ya kutumia RANDBETWEEN() kwenye Excel kuunda nambari za random kati ya minimum na maximum. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”
1. RANDBETWEEN() Function
RANDBETWEEN() inarudisha nambari ya random kati ya minimum na maximum uliyochagua. Ni muhimu kwa simulation, testing, na data generation.
Syntax:
RANDBETWEEN(bottom, top)
bottom = nambari ndogo zaidi unayotaka
top = nambari kubwa zaidi unayotaka
Kila refresh ya worksheet inazalisha nambari mpya ya random
2. Mfano Rahisi
Mfano 1: Nambari random kati ya 1 na 10
Formula:
=RANDBETWEEN(1,10)
Result:
7 (mfano tu, nambari hubadilika kila refresh)
Kila mara unapo-update worksheet, RANDBETWEEN() inatoa nambari mpya kati ya 1 na 10.
3. RANDBETWEEN() Pamoja na SEQUENCE()
Unaweza kuunda list ya random numbers kiotomatiki.
Mfano: List ya 5 random numbers kati ya 50 na 100
=RANDBETWEEN(50,100)
Kopisha formula chini kwa cells 5, utapata 5 random numbers tofauti kila refresh.
Kutaka numbers static, copy → Paste Values.
4. RANDBETWEEN() kwa Decimal Numbers
RANDBETWEEN() inatoa integers tu. Kwa decimal, tumia formula ya scaling:
Mfano: Random decimal kati ya 1.0 na 5.0
=RAND()*(5-1)+1
Hii inazalisha random numbers kama decimal, tofauti na RANDBETWEEN() ambayo ni integers tu.
5. RANDBETWEEN() Pamoja na Conditional Logic
Unaweza kutumia IF() au FILTER() kuunda random sampling kulingana na criteria.
Mfano: Random number kati ya 1–100 ikiwa status = “Available”
=IF(B2="Available", RANDBETWEEN(1,100), "")
Hii inazalisha nambari tu kwa rows zinazokidhi criteria.
6. Tips Muhimu
RANDBETWEEN() hubadilika kila mara worksheet inapopangwa, hivyo copy → Paste Values ili numbers ziwe static.
Inaweza kuunganishwa na SEQUENCE(), SORT(), FILTER(), UNIQUE() kwa dynamic random tables.
Inarahisisha simulation, random sampling, testing, na data generation.
Links Muhimu
Tazama tutorials zaidi za Excel: https://www.faulink.com
Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php
Msaada wa WhatsApp: https://wa.me/255693118509