Yi amfani da aikin RANDBETWEEN don samar da lambobi bazuwar
Za'a iya amfani da aikin RANDBETWEEN don samar da mahallin bazuwar (dukan lambobi kawai) tsakanin iyakar dabi'un a cikin takardar aikin Excel. Ƙungiyar don lambar bazuwar an ƙayyade ta amfani da muhawarar aikin .
Ganin cewa aikin da aka fi amfani dashi na RAND zai dawo da adadin adadi tsakanin 0 da 1, RANDBETWEEN zai iya samar da lamba tsakanin kowane dabi'u biyu da aka ƙayyade - irin su 0 da 10 ko 1 da 100.
Ana amfani da shi don RANDBETWEEN hada da samar da samfurori na musamman kamar su tsabar kudin da aka nuna a jere 4 a cikin hoton da ke sama da kuma juyayi ƙira .
Lura: Idan kana buƙatar samar da lambobi bazuwar, ciki har da ma'auni na ƙima, yi amfani da aiki na Excel ta RAND .
HANYAR DA HALKAR GABATARWA DA GUDATARWA
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara.
Haɗin aikin aikin RANDBETWEEN shine:
= RANDBETWEEN (Bottom, Top)
- Ƙasa: (Da ake buƙata) Ƙaƙƙarƙƙwan ƙirar aiki mai mahimmanci shine aikin dawowa a sakamakon. Za'a iya shigar da ainihin mahalarta don wannan hujja ko kuma zai iya kasancewa tantancewar salula akan wurin da aka sanya bayanai a cikin takardun aiki.
- Top: (Da ake buƙata) Babban aikin da yafi dacewa shine aikin dawowa a sakamakon. Za'a iya shigar da ainihin mahalarta don wannan hujja ko kuma zai iya kasancewa tantancewar salula akan wurin da aka sanya bayanai a cikin takardun aiki.
- #NUM! kuskure : Idan hujjar Bottom ta fi girma fiye da Tambaya Mafi Girma , aikin RANDBETWEEN zai dawo da #NUM! ɓataccen kuskure a cikin tantanin halitta inda aikin yake samuwa kamar yadda aka nuna a jere 5 a cikin hoton da ke sama.
Amfani da Hukuncin Wel's RANDBETWEEN aikin
Matakan da aka jera a kasa suna rufe yadda za a sami aikin RANDBETWEEN don dawo da yawan bazuwar tsakanin daya da 100 kamar yadda aka nuna a jere 3 a cikin hoton da ke sama.
Shigar da HANDA Sakamakon
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin kamar: = RANDBETWEEN (1,100) ko = RANDBETWEEN (A3, A3) a cikin sashin layi na aiki;
- Zabi aikin da muhawara ta amfani da maganganun aikin .
Kodayake yana yiwuwa a rubuta aikin gaba ɗaya ta hannu, mutane da dama suna neman sauƙin yin amfani da akwatin maganganu kamar yadda yake kula da shigar da haɗin aikin - irin su shafuka da rabuwa tsakanin ɓangarori tsakanin jayayya.
Ana buɗe akwatin maganganu
Don buɗe akwatin maganganu na RANDBETWEEN:
- Danna kan tantanin C3 don sanya shi tantanin aiki - wurin da za'a sa aikin RANDBETWEEN.
- Danna kan Rubutun shafin shafin rubutun .
- Danna kan maɓallin Math & Trig don buɗe jerin abubuwan da aka sauke aikin.
- Danna RANDBETWEEN cikin jerin don bude akwatin maganganun.
Bayanan da za a shiga cikin layuka marar haske a cikin akwatin maganganu zasu haifar da muhawarar aikin.
Shigar da RANDBETWEEN Ayyukan Magana
- Danna Maɓallin Ƙasa na akwatin maganganu.
- Danna kan A3 a cikin takardar aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu.
- Danna kan Girman saman akwatin maganganu.
- Danna kan tantanin halitta B3 a cikin takardun aiki don shigar da tantanin halitta na biyu.
- Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki.
- Yawan da ba a lasafta tsakanin 1 zuwa 100 ya kamata ya bayyana a cell C3 ba.
- Don samar da wani lambar bazuwar, danna maɓallin F9 a kan maballin wanda ya sa aikin aiki ya sake rikodin.
- Lokacin da ka danna kan tantanin C3 a cikakke aikin = RANDBETWEEN (A3, A3) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
HANYAR GABATARWA DA BUKATA
Kamar aikin RAND, RANDBETWEEN yana ɗaya daga cikin ayyukan da ke cikin Excel. Abin da ake nufi shine:
- Ayyukan ya sake rikodin - yana samar da wani sabon bazuwar duk lokacin da aikin aiki ya canza, kuma wannan ya haɗa da ayyuka kamar ƙara sabon bayanai ko tsari.
- Duk wani dabarar da ya dogara - ko dai kai tsaye ko a kaikaice - a kan tantanin halitta wanda ke dauke da wani aiki maras tabbas zai sake rikitawa duk lokacin da canji a cikin takardar aiki yake faruwa.
- A cikin takardun aiki ko littattafan littattafan da ke ɗauke da manyan bayanai, dole ne a yi amfani da ayyuka masu banƙyama tare da taka tsantsan kamar yadda zasu iya jinkirta lokacin amsawa na shirin saboda yawan saukewa.
Recalculation Amfani
Ayyukan da ke aiki da bazuwar zai dawo da darajar daban-daban akan kowane rikici. Wannan yana nufin cewa duk lokacin da aka kimanta aikin a cikin kwayar halitta daban daban, za a maye gurbin lambobin bazuwar ta hanyar sabunta lambobi.
Saboda wannan dalili, idan za ayi nazarin lambobin da ba a ƙidayar ba daga baya, zai zama da amfani don kwafin waɗannan dabi'u, sannan kuma a ɗeɗa waɗannan dabi'u zuwa wani ɓangare na takardun aiki.