Mmene Mungapangire Generator Yachiwerengero cha Random ku Excel

Gwiritsani ntchito RANDBETWEEN ntchito kuti mupange manambala osasintha

Pulogalamu ya RANDBETWE ingagwiritsidwe ntchito kupanga zopangira zosawerengeka (nambala zonse) pakati pa mfundo zosiyanasiyana mu Excel sheet sheet. Mndandanda wa nambala yosawerengeka imayankhidwa pogwiritsa ntchito zifukwa za ntchito .

Ngakhale kuti ntchito ya RAND yomwe imagwiritsidwa ntchito kawirikawiri idzabwezeretsa mtengo wa pakati pa 0 ndi 1, PADZIKHALA akhoza kupanga nambala pakati pazinthu ziwiri zomwe zafotokozedwa - monga 0 ndi 10 kapena 1 ndi 100.

Zogwiritsira ntchito PAMODZI zimaphatikizapo kupanga mapangidwe apadera monga ndalama zowonongeka ndondomeko yomwe ikuwonetsedwa mu mzere 4 mu chithunzi pamwambapa ndi maulendo oyendetsa .

Zindikirani: Ngati mukufuna kupanga manambala osasintha, kuphatikizapo ndalama zamtengo wapatali, gwiritsani ntchito RAND ntchito ya Excel .

Syntax ndi Zokambirana za RANDBETWEEN

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa.

Chidule cha RANDBETWEEN ntchito ndi:

= PALI (Pansi, Pamwamba)

• Pansi: (Kufunikila) Chotsimikizika kwambiri chotheka kugwira ntchito ndicho kubwerera. Chiwerengero chenichenicho chikhoza kulowetsedwa pazitsutsano ichi kapena chingakhale selo yeniyeni pa malo a deta mu tsamba la ntchito.
• Pamwamba: (Ofunikila) Wopambana wochuluka kwambiri ntchitoyo ndi kubwerera monga zotsatira. Chiwerengero chenichenicho chikhoza kulowetsedwa pazitsutsano ichi kapena chingakhale selo yeniyeni pa malo a deta mu tsamba la ntchito.
• #NUM! Cholakwika : Ngati kukangana kwakukulu ndi chiwerengero chachikulu kuposa ndemanga Yopambana , RANDBETWEEN ntchito idzabwerera #NUM! Kulakwitsa mu selo komwe ntchitoyo ilipo monga momwe ikusonyezedwa mu mzere 5 mu chithunzi pamwambapa.

Pogwiritsa ntchito ntchito ya RELBETWEEN ya Excel

Masitepe omwe ali m'munsimu akufotokoza mmene mungapezere ntchito YAM'MBUYO yowonjezera kubwezeretsa chiwerengero chokhazikika pakati pa 1 ndi 100 monga momwe tawonetsera mzere 3 mu chithunzi pamwambapa.

Kulowetsa Ntchito YOPHUNZITSIDWA

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yeniyeni monga: = PAMENE (1,100) kapena = PAMENE (A3, A3) mu selo lamasewera;
2. Kusankha ntchito ndi zifukwa pogwiritsa ntchito bokosi la bokosi la ntchito.

Ngakhale kuti n'zotheka kulembetsa ntchito yonseyo ndi dzanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo ngati akuyang'anira kulowa muzowonjezereka - monga mabakita ndi ogawanikana pakati pa zifukwa.

Kutsegula Bokosi la Zokambirana

Kutsegula RANDBETWEEN ntchito dialog box:

1. Dinani pa selo C3 kuti mupange selo yogwira ntchito - malo kumene NTCHITO ntchito idzakhazikitsidwe.
2. Dinani pa Fomu tab ya riboni .
3. Dinani pa Math & Trig icon kuti mutsegule ntchito yolemba pansi.
4. Dinani PAMODZI m'ndandanda kuti mutsegule dialog box.

Deta yomwe idzalowetsedwe mndandanda wosalongosoka mu bokosi lazokambirana idzakhazikitsa mfundo za ntchitoyo.

Kulowa pa ZINTHU ZONSE Zogwira Ntchito

1. Dinani Pansi pa mndandanda wa bokosi.
2. Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selo ili mu bokosi la dialog.
3. Dinani pa Mzere Wapamwamba wa bokosi la bokosi.
4. Dinani pa selo B3 mu tsamba lothandizira kuti mulowetse selo yachiwiri.
5. Dinani OK kuti mukwaniritse ntchitoyi ndi kubwerera kuntchito.
6. Nambala yopanda malire pakati pa 1 ndi 100 iyenera kuoneka mu selo C3.
7. Kuti mupange chiwerengero china chosasinthasintha, yesani key F9 pa makiyi omwe amachititsa tsambalo kukhazikitsanso.
8. Mukasindikiza pa selo C3 ntchito yonse = PAKATI (A3, A3) ikupezeka mu barra ya fomu pamwamba pa tsamba.

Ntchito YOPHUNZITSIDWA NDI KUYAMBA

Monga RAND ntchito, PAMODZI ndi imodzi mwa ntchito zosavuta za Excel. Izi zikutanthauza kuti:

• Ntchitoyi imagwirizanitsa - imapanga chiwerengero chatsopano pokhapokha tsamba lidasintha, ndipo izi zikuphatikizapo kuchita monga kuwonjezera deta kapena maulendo atsopano.
• Njira iliyonse yomwe imadalira - kaya mwachindunji kapena mwachindunji - mu selo yomwe ili ndi ntchito yosasinthasintha idzakhalanso kubwereza nthawi iliyonse kusintha kwa tsambali likuchitika.
• M'mapukutu kapena mabuku ogwira ntchito omwe ali ndi deta yambiri, ntchito zowonongeka ziyenera kukhala zogwiritsa ntchito mosamala pamene zingachepetse nthawi yowonjezera pulojekiti chifukwa cha kuwerengedwa kwafupipafupi.

Zisamaliro Zokumbukira

Ntchito zomwe zimagwiritsidwa ntchito mwachisawawa zimabwereranso phindu lililonse pazokonzanso. Izi zikutanthauza kuti nthawi iliyonse yomwe ntchito ikuyang'aniridwa mu selo yosiyana, mawerengedwe osasintha adzasinthidwa ndi kusintha kwatsopano kwa manambala.

Pachifukwa ichi, ngati mndandanda wa mawerengero otha msangamsanga uyenera kufufuzidwa pambuyo pake, zingakhale zopindulitsa kutsanzira mfundo izi, ndiyeno phatikizani mfundo izi mu gawo lina la tsamba.