Google Spreadsheets 'RAND Basa: Itai Nemajeri Nhamba

01 ye 01

Ita Chirongwa Chisingakoshi pakati pe 0 ne1 neRAND Function

Imwe nzira yekuita nhamba dzisingabatsiri muGoogle Spreadsheets iri neRAND basa.

Nayo pachayo, basa racho rinoita rutivi ruduku kana richiuya pakuunza nhamba dzisina kuitika, asi nekushandisa RAND mumashonga uye nekuisangana nemamwe mabasa, huwandu hwenheyo, sezvakaratidzwa mumufananidzo uri kumusoro unogona kuwedzerwa nyore nyore.

• Nokutsanangura marefu uye pasi mashoma emhando , RAND inogona kuitwa kuti idzoke nhamba dzisingashandisi mukati mehuwandu hwakatarwa - dzakadai se1 ne10 kana 1 ne100
• Izvo zvinoshandiswa zvinogona kuderedzwa zvizere nekubatanidza basa nebasa re TRUNC, iro rinosunungura kana kubvisa nzvimbo dzose dzepakati kubva pane nhamba.

Cherechedza : Maererano neGoogle Spreadsheets 'faira rekubatsira, RAND basa rinodzoka nhamba dzisingatauri pakati pe 0 dzinobatanidza uye 1 chete .

Zvinorevei ndezvokuti kunyange zvazvo zvichiwanzo kurondedzera huwandu hwehutano hwakakonzerwa nebasa sekubva kune 0 kusvika ku1, muchokwadi, zvinonyanya kutaura kuti utera huri pakati pe 0 ne 0.99999999 ....

Nenzira imwecheteyo, chirevo chinodzorera nhamba dzisinganzwisisiki pakati pe1 ne10 chinodzorera kukosha pakati pe 0 ne 9.999999 ....

Iko Syntax yeRAND Function

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .

Mutsara weRAND basa ndewokuti:

= RAND ()

Kusiyana neRANDBETWE function, iyo inoda kuti magumo ekupedzisira uye ekupedzisira asarudzwa, RAND basa harigamuchiri nharo.

RAND Basa Rinoita uye Kuratidzira

RAND basa rinoita basa rakaoma iro, kana risipo, rinoshandura kana kuti rinodzokorora nguva dzose apo peji rekushandura richichinja, uye kuchinja uku kunosanganisira zviito zvakadai sekuwedzera kwemashoko matsva.

Uyezve, chero sarudzo inofanirwa - zvichireva zvakananga kana kuti zvisina kujeka - pane imwe kero ine basa rakaoma ichadzokorora zvakare nguva dzose kuchinja kwebasa racho rinoitika.

Nokudaro, mumashandi ekushandisa ane zvakawanda zvemashoko, kushandiswa kwemaitiro kunofanirwa kushandiswa nekuchenjerera sezvavanogona kuderedza nguva yechirongwa chepurogiramu nekuda kwehuwandu hwekudzokorora.

Kubereka Nhamba YemaRandom Mitsva neRefresh

Sezvo Google Spreadsheets iri purogiramu iri muIndaneti, RAND basa rinogona kumanikidzwa kuunza nhamba itsva dzisina kuitika kuburikidza nekuvandudza chinyorwa uchishandisa web browsers rezorodza bhatani. Zvichienderana neshanduro yakashandiswa, bhodhi rezorodza rinowanzova museve wepachiyero uri pedyo nebar browser address yebar.

Chinhu chechipiri ndechokufambisa F5 key pabhobhoyo iyo inofanidzawo ikozvino firistiro yewindo:

Kuchinja RAND Refresh Frequency

MuGoogle Spreadsheets, iyo nguva iyo RAND nezvimwe zvinoshandiswa zvekare zvekushandura zvinogona kuchinjwa kubva pane zvisingasviki pakuchinja ku:

• pakuchinja uye neminiti yose;
• pakuchinja uye awa imwe neimwe.

Matanho ekuchinja mafungiro ekuvandudza ndiwo:

1. Dzvanya paFirimu menyu kuti uzarure mhando yemhando yezvasarudzo
2. Dzvanya paSpreadsheet Purogiramu pane urongwa kuti uzarure bhokisi reSpreadsheet Settings dialog
3. Pasi pechikamu chekudzokorora chebhokisi rebhokisi, chengetedza pakurongeka kwemazuva ano - sekushandura kuratidzira mahedheni akazara ekugadzirisa zvakare
4. Dzvanyira pane zvaunoda kugadzirisa zvakare munyaya
5. Dzvanya paKachengetedza Bhokisi reZvirongwa kuti uchengetedze shanduko uye dzokera kushizha remabasa

RAND Basa Basa Mienzaniso

Pasi apa yakatorwa matanho anodiwa kuti aite mienzaniso inoratidzwa mumufananidzo pamusoro apa.

1. Yokutanga inopinda muRAND basa pachayo;
2. Muenzaniso wechipiri unogadzira chirevo chinogadzira nhamba dzisingatauri pakati pe1 ne10 kana 1 ne100;
3. Muenzaniso wechitatu unoumba huwandu husingaperi pakati pe1 ne10 uchishandisa TRUNC basa.

Muenzaniso 1: Kupinda Basa RAND

Sezvo RAND basa risingatauri nharo, inogona nyore nyore kupinda mune chero sero reeseji rekushanda chete nekunyora:

= RAND ()

Zvimwewo, basa racho rinogonawo kupinda mukati meGoogle Spreadsheets ' auto- bhokisi bhokisi iro rinoputika sezvo zita rebasa racho richiiswa muchitokisi. Matanho aya:

1. Dzvanya pane sero mune pepa rekushanda apo zvikamu zvebasa zvinofanira kuratidzwa
2. Tora chiyero chakakwana (=) chinotevera nezita rebasa rand
3. Sezvaunonyora, bha-self- bhokisi bhokisi rinowanikwa nemazita emabasa anotanga netsamba R
4. Apo zita rokuti RAND rinowanikwa mubhokisi, chengetedza zita nezine mouse pointer kuti uise zita rebasa uye bhora rakazaruka rakapinda mujecha rakasarudzwa
5. Nhamba isina kuverengwa pakati pe 0 ne1 inofanira kuonekwa mune imwe sero iripo
6. Kuti uite mumwe, shandisa f5 key pabhobhoyo kana kuti shandisazve shanduro
7. Paunenge uchinyanya pane sero riripo, iro rakakwana basa = RAND () rinowanikwa mubhairi yepamusoro pane pepa pepaji

Muenzaniso wechipiri: Kuita maRandom Numeri pakati pe1 ne10 kana 1 ne100

Mhando yakawanda ye equation inoshandiswa kuunza nhamba dzisinganzwisisiki pane imwe nzvimbo yakatarwa ndeyikuti:

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

uko High uye Low inoratidzira mhedziso yepamusoro uye yakaderera yehuwandu hwehuwandu hwenhamba.

Kuita nhamba dzisinganzwisisiki pakati pe1 ne10 pinda fomu inotevera inese sepaji yekushanda:

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

Kuti uwane nhamba dzisinganzwisisiki pakati pe1 ne100 inyorera fomu inotevera mueseji yekushanda:

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

Muenzaniso wechitatu: Kuita maRandard Integers pakati pe1 ne10

Kudzorera nhamba - nhamba yose isina chikamu chepamusoro - fomu yakawanda ye equation ndeyikuti:

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

Kuti uite kuwanda kwemajeri pakati pe1 ne10 pinda maitiro aya anotevera mune rimwe sepaji rekushanda:

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