Indlela Yokukhiqiza Izinombolo Ezingahleliwe Nge-RAND Umsebenzi we-Excel

01 ka 01

Ukukhiqiza okungahleliwe okuphakathi kuka-0 no-1 nge-RAND Umsebenzi

Enye indlela yokwenza izinombolo ezingahleliwe ku-Excel inomsebenzi we-RAND.

Ngokwayo, lo msebenzi udala uhla olunqunyelwe lwezinombolo ezingahleliwe, kodwa ngokusebenzisa i-RAND ngamafomula neminye imisebenzi, ububanzi bamanani, njengoba kuboniswe esithombeni ngenhla, kungandiswa kalula ukuze:

• Ngokucacisa amanani aphakeme aphansi ebangeni , i-RAND ingenziwa ukubuyisela izinombolo ezihleliwe ngaphakathi kwebanga elibekiwe - njenge-1 no-10 noma i-1 ne-100
• Ukukhishwa komsebenzi nakho kunganciphisa ukuhlanganiswa ngokuhlanganisa umsebenzi nomsebenzi we-TRUNC , oguqula noma osusa zonke izindawo zesimanje kusuka kwinombolo.

Qaphela : Ngokusho kwefayela le-Excel, umsebenzi we-RAND ubuyisela inombolo ehambisa ngokulinganayo enkulu noma elingana no-0 nangaphansi kuka-1 .

Lokho kusho ukuthi kuyilapho kuvamile ukuchaza ububanzi bamanani abukethwe umsebenzi njengokuthi kusuka ku-0 kuya ku-1, eqinisweni, kubaluleke nakakhulu ukuthi uhla luphakathi kuka-0 no-0.99999999 ....

Ngendlela efanayo, ifomu elibuyisela inombolo engahleliwe phakathi kuka-1 no-10 empeleni kubuyisa inani eliphakathi kuka-0 no-9.999999 ....

I-syntax ye-RAND Umsebenzi

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

I-syntax yomsebenzi we-RAND yile:

= RAND ()

Ngokungafani nomsebenzi we-RANDBETWEEN , okudinga ukuphikisana okuphezulu nokuphansi, umsebenzi we-RAND awutholi ukuphikisana.

I-RAND Umsebenzi Wezibonelo

Ngezansi kubalwa izinyathelo ezidingekayo ukuze zizalise izibonelo eziboniswe esithombeni ngenhla.

1. Owokuqala ungena umsebenzi we-RAND ngokwawo;
2. Isibonelo sesibili sakha ifomula edala inombolo engahleliwe phakathi kuka-1 no-10 noma 1 no-100;
3. Isibonelo sesithathu sikhiqiza inamba engahleliwe phakathi kuka-1 no-10 usebenzisa umsebenzi we-TRUNC;
4. Isibonelo sokugcina sisebenzisa umsebenzi we-ROUND ukunciphisa inani lezindawo zamadesimali ngezinombolo ezingahleliwe.

Isibonelo 1: Ukufaka umsebenzi we-RAND

Njengoba umsebenzi we-RAND ungenayo izimpikiswano, ungangena kalula kunoma yiluphi ucingo lweshidi lokusebenza ngokuchofoza eseliweni nokuthayipha:

= RAND ()

bese ucindezela ukhiye wokungena kwikhibhodi. Umphumela uzoba inombolo ehleliwe phakathi kuka-0 no-1 esitokisini.

Isibonelo sesi-2: Ukudala Amanani Angahleliwe phakathi kuka-1 no-10 noma 1 no-100

Ifomu elijwayelekile le-equation elisetshenziselwa ukudala inombolo engahleliwe ngaphakathi kwebanga elicacisiwe yilona:

= I-RAND () * (Ephezulu-Ephansi) + Ephansi

lapho High and Low ibonisa imingcele engenhla nephansi yezinombolo ezifunwayo zezinombolo.

Ukwenza inombolo engahleliwe phakathi kuka-1 no-10 faka ifomula elandelayo kwiseli lokusebenzela:

= RAND () * (10 - 1) + 1

Ukwenza inombolo engahleliwe phakathi kuka-1 no-100 faka ifomu elilandelayo kwiseli lokusebenzela:

= RAND () * (100 - 1) + 1

Isibonelo sesi-3: Ukwenza ama-Integers angahleliwe phakathi kuka-1 no-10

Ukubuyisela inamba - inombolo yonke engenayo ingxenye yedesimali - ifomu jikelele le-equation yilo:

= TRUNC (RAND () * (High-Low) + Ephansi)

Ukwenza inamba engahleliwe phakathi kuka-1 no-10 faka ifomula elandelayo kwiseli lokusebenzela:

= TRUNC (RAND () * (10 - 1) + 1)

I-RAND ne-ROUND: Nciphisa izindawo ezidumile

Esikhundleni sokususa zonke izindawo zesimanje ngezinhlelo ze-TRUNC, isibonelo sokugcina ngenhla sisebenzisa umsebenzi olandelayo we-ROUND ngokubambisana ne-RAND ukunciphisa inani lezindawo zamadesimali enombolweni engahleliwe kuya kokubili.

= ROUND (RAND () * (100-1) +2,2)

Umsebenzi we-RAND nokuzithoba

Umsebenzi we-RAND ungenye yezinto ezithandekayo ze-Excel. Lokho kusho lokhu:

• Umsebenzi uqeda kabusha - ukhiqiza inombolo entsha engahleliwe - njalo uma ishidi lokushintsha lishintsha, futhi lokhu kuhlanganisa izenzo ezifana nokwengeza idatha entsha.
• 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.

Qala no-Stop Random Number Generation nge-F9

Ukuphoqelela umsebenzi we-RAND ukukhiqiza izinombolo ezintsha ezingahleliwe ngaphandle kokwenza ezinye izinguquko kushidi lokusebenzela nakho kungenziwa ngokucindezela ukhiye we- F9 ekhibhodi. Lokhu kwenza wonke iphepha lokusebenzela livuselele kabusha - kuhlanganise nanoma yimaphi amangqamuzana aqukethe umsebenzi we-RAND.

Ikhi ye- F9 ingasetshenziswa futhi ukuvimbela inombolo engahleliwe ekushintsheni njalo lapho ushintsho lwenziwa kwiphepha lokusebenzela, usebenzisa izinyathelo ezilandelayo:

1. Chofoza kuseli lokusebenzela, lapho inombolo ehleliwe izohlala khona
2. Thayipha umsebenzi = RAND () ku- bar yefomula ngaphezulu kwephepha lokusebenzela
3. Cindezela ukhiye we- F9 ukuze ushintshe umsebenzi we-RAND ngenombolo ehleliwe ehleliwe
4. Cindezela ukhiye wokungena kwikhibhodi ukufaka inombolo ehleliwe esitokisini esikhethiwe
5. Ukucindezela i- F9 futhi ngeke kube nomthelela kunombolo engahleliwe

Ibhokisi le-RAND Function Dialog

Cishe yonke imisebenzi ku-Excel ingangenwa ngokusebenzisa ibhokisi lezingxoxo kunokuba lifake ngesandla. Ukwenza kanjalo ukuze umsebenzi we-RAND usebenzise lezi zinyathelo:

1. Chofoza esitokisini kwiphepha lokusebenzela lapho imiphumela yomsebenzi kufanele iboniswe khona;
2. Chofoza kuthebhu yefomu yebhebhoni ;
3. Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi;
4. Chofoza ku- RAND ohlwini;
5. Ibhokisi lengxoxo lomsebenzi liqukethe ulwazi ukuthi lo msebenzi awuthathi izingxabano;
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela;
7. Inombolo engahleliwe ephakathi kuka-0 no-1 kufanele ivele esitokisini samanje;
8. Ukwenza enye, cindezela ikhi F9 ekhibhodi;
9. Uma uchofoza ku-cell E1, umsebenzi ophelele = RAND () uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.

Umsebenzi we-RAND ku-Microsoft Word ne-PowerPoint

Umsebenzi we-RAND ungasetshenziswa nakweminye izinhlelo ze-Microsoft Office, njenge-Word and PowerPoint, ukufaka izigaba zedatha okungahleliwe kumqulu noma isethulo. Ukusetshenziswa okungenzeka kwalesi sici kufana nokuqukethwe kokugcwalisa kuzifanekiso.

Ukuze usebenzise lesi sici, faka umsebenzi ngendlela efanayo kulezi ezinye izinhlelo njengase-Excel:

1. Chofoza ngegundane endaweni lapho umbhalo ozofakwa khona;
2. Thayipha = RAND ();
3. Cindezela ukhiye wokungena kwikhibhodi.

Inombolo yezigaba zombhalo ongahleliwe ziyahlukahluka kuye ngokuthi inguqulo yesistimu isetshenzisiwe. Isibonelo, i-Word 2013 ikhiqiza izigaba eziyisihlanu zombhalo ngokuzenzakalelayo, kuyilapho iZwi 2010 lidala kuphela ezintathu.

Ukuze ulawule inani lemibhalo ekhiqizwa, faka inombolo yezigaba ezifunayo njengengxabano phakathi kwabakaki abangenalutho.

Ngokwesibonelo,

= RAND (7)

izokhiqiza izigaba eziyisikhombisa zombhalo endaweni ekhethiwe.