Nzira Yokugadzira Nenjere Nenjere Generator mune Excel

Shandisa RANDBETWEEN function kuti uite nhamba dzisina kuitika

Iyo RANDBETWE basa rinogona kushandiswa kuunza integers dzisingabatsiri (nhamba dzose chete) pakati pehutano hwehutano mune imwe shanduro yekushanda Excel. Rutivi rwe nhamba dzisingatauri runotsanangurwa uchishandisa nharo dzebasa.

Kunyange zvazvo iro rinowanzoshandiswa RAND basa richadzoka kuwedzerwa kwepakati pakati pe 0 ne1, RANDBETWE ingagona kuunza integer pakati pemhando mbiri dzakatsanangurwa - dzakadai se 0 ne10 kana 1 uye 100.

Zvishandiso zveRANDBETWE zvinosanganisira kugadzira mapepa akasiyana-siyana akadai semari inoshandiswa yakashandurwa mumutsara wechina mumufananidzo wepamusoro uye dice rolling simulations .

Cherechedza: Kana iwe uchida kuunza nhamba dzisina kuverenga, kusanganisira decimal mazano, shandisa RAND basa reRAND .

Iro RANDBETWE Syntax yeMabasa uye Arguments

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

Mutsara weRANDBETWEEN basa ndewokuti:

= PANE (Pasi, Pamusoro)

• Pasi: (Inodikanwa) Pasi pfupi inogona kunyanya basa iri kudzoka semugumisiro. Iko kukwana chaiyo kunogona kupindirwa nekuda kwepikisano iyi kana inogona kuva sero rinotarisa kune nzvimbo yedhesi mubasa rekushanda.
• Pamusoro: (Inodikanwa) Inonyanya kukwanisika basa iri kudzoka semugumisiro. Iko kukwana chaiyo kunogona kupindirwa nekuda kwepikisano iyi kana inogona kuva sero rinotarisa kune nzvimbo yedhesi mubasa rekushanda.
• #NUM! kukanganisa : Kana nharo yepasi iri nhamba yakakura kudarika nharo yakakwirira , RANDBETWEEN basa richadzoka #NUM! kukanganisa kukosha muchitokisi umo basa racho riripo sezvinoratidzwa mumutsara 5 mumufananidzo uri pamusoro.

Kushandisa Excel RANDBETWEEN Function

Matanho ari pasi apa anowanikwa maitiro ekuwana RANDBETWEEN basa kuti adzorere huwandu husinganzwisisi pakati pe1 ne100 sezvaratidzwa mumutsara 3 mumufananidzo uri pamusoro.

Kupinda muRANDBETWEEN Function

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana rakadai se: = RANDBETWE (1,100) kana = RANDBETWE (A3, A3) muchengeti yekushanda;
2. Kusarudza basa uye nharo kushandisa sarudzo yebhokisi rebasa .

Kunyange zvazvo zvichibvira kungonyora basa rakakwana nemaoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi sezvo rinotarisira kupinda mumashandisirwo emagetsi - zvakadai seakabhakani uye vaparamadzi vemazana pakati pemakakatanwa.

Kuvhura Bhokisi reDhialog

Kuti uzarure RANDBETWE PENZIKA dialog box:

1. Dzvanya pachitokisi C3 kuti uite sero rinoshanda - nzvimbo iyo RANDBETWEEN basa ichawanikwa.
2. Dzvanya paMafomu tab yebhoni .
3. Dzvanya paMat & Trig icon kuti uzarure basa redu rezasi.
4. Dzvanya paRANDBETWE mune urongwa kuti uzarure bhokisi rebasa rebasa.

Dhesi iyo ichapindirwa mumitsetse isina chinhu mubhokisi yebhokisi ichaita maitiro ebasa.

Kupinda RANDBETWE Mhiridzo yeMabasa

1. Dzvanya pazasi Pasi pebhokisi rebhokisi.
2. Dzvanya pane sero A3 mune pepa rekushanda kuti uise ino rekero mubhokisi rebhokisi.
3. Dzvanya Pamusoro peNzira yebhokisi rebhokisi.
4. Dzvanya pane sero B3 mune pepa rekushanda kuti uise wechipiri chekuverenga.
5. Dzvanya OK kuti upedze basa uye dzokera kushizha rekushanda.
6. Nhamba isina kuverengwa pakati pe1 ne100 inofanira kuonekwa muchitokisi C3.
7. Kuti uite imwe nhamba dzisinganzwisisiki, shandisa key F9 pane keyboard iyo inokonzera kuti pepa rekudzidzira rive zvakare.
8. Paunenge uchinyora pachitsime C3 basa rakakwana = RANDBETWE (A3, A3) rinowanikwa mubhairi yepamusoro pane pepa pepaji.

RANDBETWE BASA ROKUITA NOKUDZIDZA

Kufanana neRAND function, RANDBETWE ndeimwe yeExcel inobata mabasa . Zvinorevei izvi ndezvi:

• Basa racho rinodzokorora - rinobudisa nhamba itsva isina kuitika nguva dzose kana pepa rekushandura richichinja, uye izvi zvinosanganisira zviito zvakadai sekuwedzera data itsva kana mazano.
• 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.

Recalculation Cautions

Mabasa anosangana nekusarura achadzoka kukosha kwakasiyana pane imwe neimwe yekudzokorora. Izvi zvinoreva kuti nguva imwe neimwe iyo basa rinoongororwa mune rimwe sero, nhamba dzisingatauri dzichatsiviwa nekuvandudzwa kwenhamba dzisina kuitika.

Nokuda kwechikonzero ichi, kana imwe nhamba yemhando dzisingatauri inofanira kuongororwa gare gare, zvingava zvakakosha kukopa maitiro aya, uye kuisa maitiro aya kune imwe chikamu chebasa.