Indlela yokudala i-Random Number Generator kwi-Excel

Sebenzisa umsebenzi we-RANDBETWEEN ukwenzela ukuba kuvelwe amanani angalindelekanga

UMSEBENZI WENKQUBO ungasetyenziselwa ukuvelisa i-integers engahleliweyo (inani elipheleleyo kuphela) phakathi kweendidi zexabiso kwi-Excel sheet sheet. Uluhlu lweenombolo ezingahleliweyo luboniswe ngokusebenzisa iziphakamiso zomsebenzi .

Nangona umsebenzi weRAND osetyenziswa ngokuqhelekileyo uza kubuyisa ixabiso elidlulileyo phakathi kwe-0 no-1, I-RANDBETWEEN inokuvelisa inani eliphakathi kwamanani amabini achaziweyo-afana ne-0 kunye no-10 okanye i-1 kunye ne-100.

Ukusetyenziswa kweRANDBETWE kuquka ukudala iifomula ezikhethekileyo ezifana nefom yefom yefom eboniswe kumgca 4 kumfanekiso ongentla kunye kunye needayisi zokuqhayisa .

Qaphela: Ukuba ufuna ukuvelisa amanani angalindelekanga, kubandakanya ixabiso lokugqibela, sebenzisa umsebenzi we- RAND we-Excel .

I-Syntax yeeNtsebenzo kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.

I-syntax yomsebenzi we-RANDBETWEEN yile:

= KWI-RANDBETWE (Ngezantsi, Phezulu)

• Ngezantsi: (Okufunekayo) Inani eliphantsi kunako konke umsebenzi ukubuyisela ngenxa yoko. Inombolo epheleleyo ingeniswa kule ngxabano okanye ingaba yereferensi yeseli kwendawo yedata kwiphepha lokusebenzela.
• Phezulu: (Okufunekayo) Inani eliphezulu kunokwenzeka ukuba umsebenzi ubuyele ngenxa yoko. Inombolo epheleleyo ingeniswa kule ngxabano okanye ingaba yereferensi yeseli kwendawo yedata kwiphepha lokusebenzela.
• #NUM! Iphutha : Ukuba ingxabano engaphantsi yinkalo enkulu kunengxabano ephezulu, umsebenzi weRANDBETWEEN uya kubuya #NUM! Ixabiso lesiphene kwiseli apho umsebenzi ukhona njengoko kuboniswe kumgca 5 kumfanekiso ongentla.

Ukusebenzisa i-Excel RANDBETWEEN Function

Amanyathelo alulwe apha ngezantsi afumana indlela yokufumana umsebenzi we-RANDBETWEEN ukubuyisela inani elingenanto phakathi kweyodwa kunye ne-100 njengoko kuboniswe kumgca 3 kumfanekiso ongentla.

Ukufaka umsebenzi weRANDBETWEEN

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi ophelele njenga: = RANDBETWEEN (1,100) okanye = I-RANDBETWEEN (A3, A3) ibe yiseli yomsebenzi;
2. Ukukhetha umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi .

Nangona kunokwenzeka ukuba uthayiphe kuphela umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko njengoko kuthatha ukunakekelwa kokungena kwi-syntax yomsebenzi - njengabakaki kunye nabahluli be-comma phakathi kweengxabano.

Ukuvula Ibhokisi yeDialog

Ukuvula ibhokisi yencoko yencoko ye-RANDBETWEEN:

1. Cofa kwifowuni C3 ukwenzela ukuba yenze iseli esebenzayo -indawo apho umsebenzi we-RANDBETWEEN uya kuba khona.
2. Cofa kwiThebhu yefomula yerbhoni .
3. Cofa kwi- Math & Trig icon ukuvula uluhlu lokuhla kwehla.
4. Cofa kwi- RANDBETWE kuluhlu ukuvula ibhokisi yencoko yencoko yomsebenzi.

Idatha eya kungeniswa kwimigca engenanto kwibhokisi yencoko yababini iya kwenza iziphakamiso zomsebenzi.

Ukungena kwi-Arguments ye-Function RANDBETWEEN

1. Cofa kwizantsi kwebhokisi yencoko.
2. Cofa kwiseli A3 kwiphepha lokusebenzela ukuze ufake le fom yeefayile kwibhokisi yencoko.
3. Cofa kwi- Top line kwibhokisi yencoko.
4. Cofa kwiseli B3 kwiphepha lokusebenzela ukuze ufake isalathisi yesibini yesibini.
5. Cofa Kulungile ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela.
6. Inani elingahleliyo phakathi kwe-1 no-100 kufuneka livele kwiseli C3.
7. Ukuvelisa enye inombolo engahleliweyo, cinezela iqhosha le- F9 kwibhodibhodi ebangela ukuba iphepha lokusebenzela liphinde liphinde libuyele.
8. Xa ucofa kwi-cell C3 umsebenzi opheleleyo = I-RANDBETWEEN (A3, A3) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

UMSEBENZI WENKQUBO YOKUSEBENZA NOKUBHALISA

Njengomsebenzi we-RAND, I-RANDBETWE enye yezinto ezihamba phambili ze-Excel. Oko kuthetha ukuthini:

• Umsebenzi uphinda uqalisa - uvelisa inombolo entsha engalindelekanga rhoqo xa iphepha lokusebenzela liguquka, kwaye oku kubandakanye nezenzo ezifana nokungongeza idatha entsha okanye amafomula.
• Nayiphi na ifom exhomekeke kuyo - ngokuthe ngqo okanye ngokungathanga ngqo - kwiseli equkethe umsebenzi ongeyantlupheko iya kuphinda iphinde iphinde iguquke rhoqo xa utshintsho kwiphepha lokusebenzela lwenzeka.
• Kwiphepha lokusebenzela okanye iincwadi zokusebenzela ezinamanani amaninzi edatha, imisebenzi enokuzenzekelayo kufuneka isebenziswe ngokuqapha njengoko inganciphisa ixesha lokuphendula leprogram ngenxa yobunzima bokuphindaphinda.

Izikhumbuzo zokuQala kwakhona

Imisebenzi ejongene nokungahambi kakuhle iya kubuya ixabiso elithile kwi-recalculation nganye. Oku kuthetha ukuba yonke ixesha apho umsebenzi uvavanywa kwiseli eyahlukileyo, amanani angenanto aya kutshintshwa ngamanani alungelelanisiweyo.

Ngenxa yesi sizathu, ukuba isethi ethile yeenombolo ezingafunekiyo kufuneka ifundwe kamva, kuya kuba luncedo ukukopisha ezi zithethe, uze unamathisele ezi zithethe kwinxalenye yeshidi.