01 ka 01
Ukukhiqiza okungahleliwe okuphakathi kuka-0 no-1 nge-RAND Umsebenzi
Enye indlela yokwenza izinombolo ezingahleliwe ku-Google Spreadsheets inomsebenzi we-RAND.
Ngokwayo, lo msebenzi udala uhla olulinganiselwe uma kuziwa ekukhiqizeni izinombolo ezingahleliwe, kodwa ngokusebenzisa i-RAND ngamafomula nangokuzihlanganisa neminye imisebenzi, ububanzi bamanani, njengoba kuboniswe esithombeni esingenhla kalula kungandiswa.
- 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-Google Spreadsheets ', i-RAND umsebenzi ibuyisela inombolo engahleliwe phakathi kuka-0 ehlanganisiwe no-1 okukhethekile .
Lokho kusho ukuthi ngenkathi kuvamile ukuchaza ububanzi bezintengo ezikhiqizwa ngumsebenzi njengokuba 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.
Umsebenzi we-RAND nokuzithoba
Umsebenzi we-RAND umsebenzi ongathandeki , okwenza ngokuzenzakalelayo, uguquke noma uvuselele njalo uma ishidi lishintsha, futhi lezi zinguquko zihlanganisa izenzo ezifana nokwengezwa kwedatha entsha.
Ngaphezu kwalokho, noma yiluphi uhlobo oluxhomeke - ngokuqondile noma ngokungaqondile - esitokisini elinomsebenzi ongeyena ozophinde uphinde uvuselele njalo uma ushintsho kuphepha lokusebenzela lwenzeka.
Ngakho-ke, emafishini omsebenzi aqukethe idatha enkulu, imisebenzi ephikisayo kufanele isetshenziswe ngokucophelela njengoba inganciphisa isikhathi sempendulo yohlelo ngenxa yemvamisa yokuphindaphinda.
Ukhiqiza Izinombolo Ezintsha Eziphuthumayo nge-Refresh
Njengoba ama-Google Spreadsheets ayinhlelo le-intanethi, umsebenzi we-RAND ungaphoqeleka ukukhiqiza izinombolo ezintsha ezingahleliwe ngokuqabula isikrini usebenzisa inkinobho yokuvuselela iziphequluli zewebhu. Kuye ngesiphequluli esisetshenzisiwe, inkinobho yokuvuselela ngokuvamile imcibisholo yombuthano eseduze nesikhala sekheli lesiphequluli.
Okukhethwa kukho kokubili ukucindezela ukhiye we- F5 ekhibhodi okuvuselela iwindi lesiphequluli samanje:
Ukushintsha i-RAND's Refresh Frequency
Ku-Google Spreadsheets, imvamisa lapho i-RAND kanye neminye imisebenzi eguquguqukayo yokuvuselela ingashintshwa kusuka kokuzenzakalelayo ekushintsheni ku:
- ekushintsheni naseminithini yonke;
- ekushintsheni nakuwo wonke amahora.
Izinyathelo zokushintsha izinga lokuvuselela ziyi:
- Chofoza kwimenyu yefayela ukuze uvule uhlu lwemenyu lwezinketho
- Chofoza kuzilungiselelo ze-Spreadsheet kuhlu ukuze uvule ibhokisi lokubhalwa kwezilungiselelo zeSpredishithi
- Ngaphansi kwesigaba sokuQala kabusha sebhokisi lebhokisi, chofoza esimweni samanje - njengokushintshwa ukubonisa uhlu oluphelele lokukhethwa kabusha
- Chofoza ku-option oyifunayo yokulungisa kabusha ohlwini
- Chofoza inkinobho Yokulondoloza Izilungiselelo ukuze ulondoloze ushintsho bese ubuyela ekhasini lokusebenzela
I-RAND Umsebenzi Wezibonelo
Ngezansi kubalwa izinyathelo ezidingekayo ukuze zizalise izibonelo eziboniswe esithombeni ngenhla.
- Owokuqala ungena umsebenzi we-RAND ngokwawo;
- Isibonelo sesibili sakha ifomula edala inombolo engahleliwe phakathi kuka-1 no-10 noma 1 no-100;
- Isibonelo sesithathu sikhiqiza inamba engahleliwe phakathi kuka-1 no-10 usebenzisa umsebenzi we-TRUNC.
Isibonelo 1: Ukufaka umsebenzi we-RAND
Njengoba umsebenzi we-RAND ungathathi izingxabano, ungangena kalula kunoma yisiphi iseli leshidi lomsebenzi ngokuthayipha:
= RAND ()
Ngaphandle kwalokho, lo msebenzi ungangena futhi usebenzisa ibhokisi le-Google Spreadsheets 'eliphakamisa ngokuzenzakalelayo elivama njengoba igama lomsebenzi lifakwe esitokisini. Izinyathelo ziyi:
- Chofoza kuseli kwiphepha lokusebenzela lapho imiphumela yomsebenzi kufanele iboniswe khona
- Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi we- rand
- Njengoba uthayipha, ibhokisi lokusikisela ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngencwadi R
- Uma igama elithi RAND livela ebhokisini, chofoza igama nge-pointer yegundane ukufaka igama lomsebenzi kanye nebhasi elivulekile nxazonke esitokisini esikhethiwe
- Inombolo engahleliwe ephakathi kuka-0 no-1 kufanele ibonakale esitokisini samanje
- Ukwenza enye, cindezela ukhiye we- F5 ekhibhodi noma uvuselele isiphequluli
- Uma uchofoza esitokisini samanje, umsebenzi ophelele = RAND () uvela kubha yefomula ngaphezulu kwephepha lokusebenzela
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)