Jifunze Excel RANDBETWEEN(): Unda Nambari za Random Kati ya Zile Uliyochagua

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