Nzira Yekugadzira Random Numeri Ne Excel RAND Basa

01 ye 01

Ita Chirongwa Chisingakoshi pakati pe 0 ne1 neRAND Function

Imwe nzira yekuita nhamba dzisingabatsiri mu Excel ndeyeRAND basa.

Nayo pachayo, basa racho rinogadzira nhamba shoma dzenhamba dzisingatauriki, asi kuburikidza nekushandisa RAND mune mazano nemamwe mabasa, huwandu hwenheyo, sezvakaratidzwa mumufananidzo uri pamusoro, zvinogona kuwedzerwa nyore kuitira kuti:

• 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 neFel yaibatsira faira, basa reRAND rinodzoka nhamba yakagoverwa yakawanda kudarika kana yakaenzana ne0 uye pasi pe1 .

Izvi zvinorevei ndezvokuti kunyange zvazvo zvakajairika 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 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;
4. Muenzaniso wekupedzisira unoshandisa basa reROUND kuti kuderedze nhamba yezvimbo dzepamusoro dze nhamba dzisingatauriki.

Muenzaniso 1: Kupinda Basa RAND

Sezvo RAND basa risingatauri nharo, inogona nyore nyore kupinda mune chero sero resebasa rekushanda nekungobata pane imwe sero nekunyora:

= RAND ()

uye kuvhara muIkiyi pane keyboard. Chigumisiro chichava nhamba dzisinganzwisisiki pakati pe 0 ne1 muchitokisi.

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)

RAND NOKUDZIDZA: Deredza nzvimbo dzeDzimba

Panzvimbo pokubvisa nzvimbo dzose dzekupedzisira ne TRUNC basa, muenzaniso wekupedzisira pamusoro apa unoshandisa iyi inotevera ROUND basa pamwe neRAND kuti kuderedza nhamba yezvigaro zvepamusoro pane nhamba dzisingatauri kusvika mbiri.

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

RAND Basa Rinoita uye Kuratidzira

IRAND basa nderimwe reExcel rinoshandiswa . Zvinorevei izvi ndezvi:

• Basa racho rinodzokorora - rinogadzira nhamba itsva yekusarura - nguva dzose pashanduro yebasa ichichinja, uye izvi zvinosanganisira zviito zvakadai sekuwedzera data itsva.
• Chero mhando iyo inofanirwa - zvichida zvakananga kana zvisina kujeka - pane imwe kero ine basa rakaoma ichadzokorora zvakare nguva dzose kuchinja mune pepa rekushanda kunoitika.
• Mune mapepa okushanda kana mabhuku ebasa ane zvakawanda zvemashoko, kushandiswa kwemaitiro kunofanira kuve kushandiswa nekuchenjerera sezvavanogona kunonoka pasi purogiramu yechirongwa chepurogiramu pamusana pekuwandisa kwekudzokorora.

Kutanga uye Kurega Nhamba Dzechizvarwa Nherera neF9

Kumanikidzira RAND basa kuti rive nemitemo mitsva isina kumira pasina kuita zvimwe shanduko kune rimwe bhuku rinogona kuitwa kuburikidza nekusimudzira f9 key pa keyboard. Izvi zvinomanikidza bhesi rose rekugadzirisa zvakare - kusanganisira chero masero ane rine RAND basa.

Nzira yeF9 inokwanisawo kushandiswa kudzivirira nhamba dzisingashanduki kubva pakuchinja nguva dzose kana shanduko ichiitwa kune pepa rekushandisa, uchishandisa matanho anotevera:

1. Dzvanya pamusero webasa rekushanda, uko nhamba ye random inogara
2. Tora iyo basa = RAND () mubhokisi yepamusoro pane pepa pepaji
3. Shingairira F9 key kuti uchinje RAND basa mumutambo unotarisa
4. Dhinda pikicha inopinda mubhobhoyo kuti uise nhamba dzisinganzwisisiki mumusero wakasarudzwa
5. Kuomesa F9 zvakare hakuzovi nemigumisiro pane nhamba dzisinganzwisisiki

Iro RAND Function Dialog Box

Inenge yose mabasa muExcel inogona kuiswa achishandiswa nebhokisi rebhokisi panzvimbo pokupinda mairi. Kuita izvi kuitira RAND basa kushandisa matanho anotevera:

1. Dzvanya pane sero mune pepa rekushanda apo zviitiko zvebasa zvinofanira kuratidzwa;
2. Dzvanya paMafomu tab yebhoni ;
3. Sarudza Math & Trig kubva kubhoni kuti uzarure basa rinoyerera pasi;
4. Dzvanya paRAND mune urongwa;
5. Basa rebhokisi rebhokisi rinoshandisa ruzivo kuti basa racho harina matanho;
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda;
7. Nhamba isinganzwisisiki pakati pe1 ne1 inofanirwa kuonekwa mumusero wezvino;
8. Kuti uite mumwe, shandisa f9 key pane keyboard;
9. Paunenge uchinge uri pa cell E1, basa rakakwana = RAND () rinowanikwa mubhairi yepamusoro pane pepa pepaji.

Iri RAND Basa muMicrosoft Word uye PowerPoint

RAND basa rinogona kushandiswawo mune dzimwe sangano reMicrosoft Office, zvakadai seShoko uye PowerPoint, kuwedzera mamwe mavara emadhidhi kumagwaro kana kuiswa. Imwe inogona kushandiswa kwechikamu ichi sezadza zvinyorwa mumatura.

Kuti ushandise chiitiko ichi, pinda basa nenzira imwechete mune mamwe mapurogiramu akaita se Excel:

1. Dzvanya nehotera munzvimbo iyo rugwaro rwuri kuwedzerwa;
2. Tanga = RAND ();
3. Dhinda pikicha inopinda mubhokisi.

Nhamba yemavara emashoko akasiyana-siyana anosiyana zvichienderana nehuwandu hwepurogiramu inoshandiswa. Semuenzaniso, Shoko 2013 rinopa ndima nhatu dzemashoko zvakashata, asi Shoko 2010 rinobudisa zvitatu chete.

Kuti uchengetedze huwandu hwemashoko akabudiswa, pinda nhamba yemadiro aunoda sepikano pakati pebhakki dzisina chinhu.

Semuyenzaniso,

= RAND (7)

ichaita ndima minomwe yezvinyorwa munzvimbo yakasarudzwa.