Ungadala kanjani i-Random Number Generator ku-Excel

Sebenzisa umsebenzi we-RANDBETWEEN ukuze wenze izinombolo ezingahleliwe

Umsebenzi we-RANDBETWEEN ungasetshenziselwa ukukhiqiza izinamba ezingahleliwe (izinombolo eziphelele kuphela) phakathi kobubanzi bezintengo ku-Excel sheet sheet. Ububanzi bezinombolo ezingahleliwe bubekiwe ngokusebenzisa izimpendulo zomsebenzi.

Nakuba umsebenzi we-RAND ovame ukusetshenziswa kakhulu uzobuyisela inani eliyisimanje phakathi kuka-0 no-1, i-RANDBETWEEN ingaveza inamba phakathi kwamaphi amanani ahlongozwayo - afana no-0 no-10 noma u-1 no-100.

Ukusetshenziswa kwe-RANDBETWEEN kufaka ukudala amafomula akhethekile njengendlela yokukhishwa kwemali esetshenziselwa umugqa wesi-4 esithombeni ngenhla kanye nokulinganisa kwama-dice .

Qaphela: Uma udinga ukukhiqiza izinombolo ezingahleliwe, kufaka phakathi amanani wezimali, sebenzisa umsebenzi we- RAND we-Excel .

I-syntax ye-Function kanye nama-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.

I-syntax yomsebenzi we-RANDBETWEEN yilezi:

= KULUNGILE (Ngezansi, Phezulu)

• Ngezansi: (Okudingekayo) Inani eliphansi kunazo zonke lo msebenzi ukubuyisela njengomphumela. I-integer yangempela ingangenwa kule mpikiswano noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela.
• Okuphezulu: (Okudingekayo) Inombolo ephezulu kunazo zonke umsebenzi ukubuyela njengomphumela. I-integer yangempela ingangenwa kule mpikiswano noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela.
• #NUM! iphutha : Uma ingxabano engezansi inomboro enkulu kunengxabano ephezulu , umsebenzi we-RANDBETWEEN uzobuyisela i- #NUM! inani lephutha esitokisini lapho umsebenzi ukhona njengoba kuboniswe emgqeni 5 esithombeni ngenhla.

Ukusebenzisa umsebenzi we-Excel RANDBETWEEN

Izinyathelo ezibalulwe ngezansi zihlanganisa indlela yokuthola umsebenzi we-RANDBETWEEN ukubuyisela inani elingenangqondo phakathi kweyodwa no-100 njengoba kuboniswe kumugqa wesi-3 esithombeni ngenhla.

Ukufaka i-RANDBETWEEN Function

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele njengo: = RANDBETWEEN (1,100) noma = RANDBETWEEN (A3, A3) esitokisini somsebenzi;
2. Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi .

Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lebhokisi njengoba kuqapha ukungena kwe-syntax yomsebenzi - njengabakaki kanye nabahlukanisi be-comma phakathi kwama-arguments.

Ukuvula ibhokisi lokuxoxa

Ukuvula ibhokisi lengxoxo ye-RANDBETWEEN:

1. Chofoza kuseli C3 ukuze wenze iseli elisebenzayo - indawo lapho umsebenzi we-RANDBETWEEN uzobe khona.
2. Chofoza kuthebhu yefomathi yebhande .
3. Chofoza ku- Math & Trig icon ukuze uvule uhlu lwehla lokusebenza.
4. Chofoza ku- RANDBETWEEN ohlwini ukuze uvule ibhokisi lengxoxo lomsebenzi.

Idatha ezofakwa emigqeni engenalutho ebhokisini lebhokisi izokwenza izingqinamba zomsebenzi.

Ukufaka ama-Arguments e-RANDBETWEEN Function

1. Chofoza ngezansi kwebhokisi lebhokisi.
2. Chofoza ku-cell A3 kushidi lokusebenzela ukuze ufake leli referensi yeseli ebhokisini lengxoxo.
3. Chofoza ku- Top line yebhokisi lebhokisi.
4. Chofoza kuseli B3 kusikripthi sokusebenza ukuze ufaka ireferensi yeselula yesibili.
5. Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela.
6. Inombolo engahleliwe ephakathi kuka-1 no-100 kufanele ivele kuseli C3.
7. Ukukhiqiza enye inombolo engahleliwe, cindezela ukhiye we- F9 ekhibhodi okubangela ukuba ishidi lomsebenzi libuyele kabusha.
8. Uma uchofoza ku-cell C3 umsebenzi ophelele = I-RANDBETWEEN (A3, A3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

Umsebenzi we-RANDBETWEEN and Volatility

Njengomsebenzi we-RAND, i-RANDBETWEEN ingenye yemisebenzi ejwayelekile ye-Excel. Lokho kusho lokhu:

• Umsebenzi uqeda kabusha - ukhiqiza inamba entsha engahleliwe njalo uma ishidi lokushintsha lishintsha, futhi lokhu kuhlanganisa izenzo ezifana nokwengeza idatha entsha noma amafomula.
• Noma iyiphi ifomula exhomekile - ngokuqondile noma ngokungaqondile - esitokisini equkethe umsebenzi ongeyena ozophinde ibuyele kabusha njalo uma ushintsho kushidi lokusebenza lwenzeka.
• Emakhasini okusebenzela noma amabhuku okusebenza aqukethe idatha enkulu, imisebenzi ephikisayo kufanele isetshenziswe ngokuqapha njengoba inganciphisa isikhathi sempendulo yohlelo ngenxa yemvamisa yokuphindaphinda.

Ukuqapha kabusha

Imisebenzi ephathelene nokungahleliwe izobuyisela inani elihlukile ekuqaliseni kabusha. Lokhu kusho ukuthi ngaso sonke isikhathi lapho umsebenzi uhlolwe esitokisini esithile, izinombolo ezihleliwe zizoshintshwa ngezinombolo ezihleliwe ezihleliwe.

Ngenxa yalesi sizathu, uma isethi ethile yamanani okungahleliwe kufanele afundwe kamuva, kungaba ngcono ukukopisha lezi zindinganiso, bese unamathisela lezi zindinganiso kwenye ingxenye yephepha lokusebenzela.