I-Google Spreadsheets 'I-RAND Umsebenzi: Ukuvelisa iiNombolo eziBhalisiweyo

01 ngo 01

Ukuvelisa ixabiso elingenalutho phakathi kwama-0 no-1 kunye nomsebenzi we-RAND

Enye indlela yokuvelisa amanqaku angakhanjethi kwi-Google Spreadsheets inomsebenzi we-RAND.

Ngokwalo, umsebenzi uvelisa ulwahlulo olukhawulelweyo xa kuvela ekuveleni amanani angenanto, kodwa ngokusebenzisa i-RAND kwiifomula nangokuzixuba kunye neminye imisebenzi, uluhlu lwexabiso, njengoko kuboniswe kumfanekiso ongentla ungenwe lula.

• Ngokucacisa amaxabiso aphakamileyo aphantsi kwimiba , i-RAND ingenziwa ukubuyisela amanani angenangqangi phakathi kwecandelo elikhankanywe - njenge-1 ne-10 okanye i-1 kunye ne-100
• Isiphumo somsebenzi sinokuncitshiswa sibe yi-integers ngokudibanisa umsebenzi nomsebenzi we-TRUNC, othembisa okanye ususe zonke iindawo zokugqibela ukusuka kwinombolo.

Qaphela : Ngokutsho kwefayile ye-Google Spreadsheets ', ifayili yeRAND ibuyisela inombolo engalindelekanga phakathi kwe-0 edibeneyo kunye ne-1 ekhethekileyo .

Kuthetha ukuthini ukuba ngelixa kuqhelekileyo ukuchaza uluhlu lwamanani aveliswe ngumsebenzi njengoko luvela ku-0 ukuya ku-1, inyaniso, kuchaneke ngakumbi ukuba uluhlu luphakathi kwe-0 kunye ne-0.99999999 ....

Ngomqondiso ofanayo, ifom ebuyisela inombolo engalindelekanga phakathi kwe-1 no-10 ibuyisela ixabiso phakathi kwe-0 no-9.999999 ....

I-syntax ye-RAND yomsebenzi

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

I-syntax yomsebenzi we-RAND yile:

= RAND ()

Ngokungafani nomsebenzi we-RANDBETWEEN, ofuna iingxabano eziphakamileyo kunye eziphantsi ukuba zichazwe, umsebenzi we-RAND awwamkeli iimbambano.

Umsebenzi weRAND kunye noVuqu

Umsebenzi we-RAND ngumsebenzi ongathandekiyo , ongaguqukiyo, utshintshile okanye uhlaziya rhoqo xa iphepha lokusebenzela liguquka, kwaye ezi tshintsho zibandakanya izenzo ezifana nokongezwa kwedatha entsha.

Ukongezelela, nayiphi na ifom exhomekeke kuyo - ngokuthe ngqo okanye ngokungathanga ngqo - kwiseli equkethe umsebenzi ongenamsebenzi uya kuphinda kwakhona kwakhona xa utshintsho kwiphepha lokusebenzela lwenzeka.

Ngoko ke, kwiifayile ezisebenzayo eziqukethe iinkcukacha ezinkulu, imisebenzi enokuzenzekelayo kufuneka isebenziswe ngokuqaphela njengoko inganciphisa ixesha lokuphendula kwenkqubo ngenxa yobunzima bokuphindaphinda.

Ukudala iNew Random Numeri ngokuhlaziya kwakhona

Ekubeni i-Google Spreadsheets iyinkqubo ye-intanethi, umsebenzi we-RAND unyanzelekile ukuba uvelise amanani amaninzi angangqaliyo ngokuhlaziya iskrini usebenzisa i-web browsers iqhosha iqhosha. Ngokuxhomekeke kwisiphequluli esisetyenzisiweyo, iqhosha lokuhlaziya ngokuqhelekileyo litsho lesicatshulwa esisecaleni kwinqanaba ledilesi yesiphequluli.

Inketho yesibili kukunyakraza iqhosha le- F5 kwikhibhodi ebuye ihlaziywe iwindow ye-browser yamanje:

Ukutshintsha iRAND yeRefresh Frequency

Kwi-Google Spreadsheets, ixesha apho i-RAND kunye neminye imisebenzi engathandabuzekiyo iyakwazi ukutshintsha ukusuka ekungagqibekanga kwenguqu :

• utshintsho kunye nayo yonke iminithi;
• utshintsho kunye neyure.

Amanyathelo okutshintsha izinga lokuhlaziya zi:

1. Cofa kwi Imenyu yefayile ukuvula uluhlu lwemenyu yezinketho
2. Cofa kwiSpreadsheet Izicwangciso kwiluhlu ukuvula ibhokisi yencoko yoqwalaselo lweSpredishithi
3. Ngaphantsi kweCandelo lokuQala kwakhona kwibhokisi yencoko, nqakraza kwimeko ekhoyo - njengenguqu ekutshintsheni uluhlu olupheleleyo lwezinto zokulungisa
4. Cofa kwikhetho lokufundwa kwakhona elifunwayo kwiluhlu
5. Cofa kwi-Inkinobho Yokugcina izixhobo ukugcina utshintsho kwaye ubuyele kwiphepha lokusebenzela

UMSEBENZI Wemisebenzi

Ngezantsi zidweliswe amanyathelo afunekayo ukuvelisa imizekelo eboniswe kumfanekiso ongentla.

1. Umntu wokuqala ungena kumsebenzi we-RAND ngokwawo;
2. Umzekelo wesibini udala umhlathi ovelisa inombolo ehleliweyo phakathi kwe-1 no-10 okanye i-1 kunye ne-100;
3. Umzekelo wesithathu uvelisa inani elingenanto phakathi ko-1 no-10 usebenzisa umsebenzi we-TRUNC.

Umzekelo 1: Ukufaka umsebenzi weRAND

Ekubeni umsebenzi we-RAND awuthathi ngxabano, unokungena kalula kwifayile yeshidi ngokuthayipha:

= RAND ()

Ngaphandle koko, umsebenzi ungangeniswa ngokusebenzisa ibhokisi ye-Google Spreadsheets ' ibonisa ibhokisi ephakanyiswayo njengoko igama lomsebenzi lifakwe kwiseli. Amanyathelo:

1. Cofa kwiseli kwiphepha lokusebenzela apho iziphumo zomsebenzi ziza kuboniswa khona
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi werandi
3. Njengoko uthayipha, ibhokisi ephakamisa ngokuzenzekelayo ibonakala ngamagama emisebenzi eqala ngeleta R
4. Xa igama i- RAND ibonakala kwibhokisi, nqakraza egameni nge-pointer ye mouse ukuze ufake igama lomsebenzi kunye nebhoksi evulekile ejikelezayo kwiseli ekhethiweyo
5. Inombolo engahleliweyo phakathi kwe-0 no-1 kufuneka ibonakale kwiseli langoku
6. Ukwenza omnye, cinezela iqhosha le- F5 kwikhibhodi okanye uvuselele isiqulathi
7. Xa ucofa kwiseli yangoku, umsebenzi opheleleyo = I-RAND () ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela

Umzekelo wesi-2: Ukuvelisa iinombolo zeRandom phakathi kwe-1 no-10 okanye i-1 kunye ne-100

Ifom ejwayelekile ye-equation esetyenziselwa ukuvelisa inombolo engalindelekanga kwinqanaba elikhankanyiweyo kukuba:

= I-RAND () * (Ephakamileyo - Ephantsi) + Ephantsi

apho iphakamileyo kunye nezantsi ibonisa imida engenasentla kunye nezantsi efunyenweyo yamanani.

Ukuvelisa inombolo ekhethiweyo phakathi kwe-1 no-10 faka ifom elandelayo kwiseli yomsebenzi:

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

Ukuvelisa inombolo ekhethiweyo phakathi kwe-1 no-100 faka ifom elandelayo kwiseli yomsebenzi:

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

Umzekelo wesi-3: Ukuvelisa ama-Random Integers phakathi kwe-1 no-10

Ukubuyisela i-integer - inombolo epheleleyo engenaso isahlulo esiphezulu - ifom ejwayelekile ye-equation yile:

= I-TRUNC (RAND () * (Ephakamileyo - Ephantsi) + Ephantsi)

Ukwenza i-integer ehleliweyo phakathi kwe-1 no-10 faka ifom elandelayo kwiseli yomsebenzi:

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