Ukwakhiwa kwenkinga
Ake sicabange ukuthi sidinga ukwakha iqoqo lezinombolo ezingahleliwe ngaphandle kokuphindaphinda ebangeni elinikeziwe lamanani. Izibonelo ohambeni:
- ukukhiqiza amakhodi angahleliwe ahlukile emikhiqizo noma abasebenzisi
- ukwabela abantu imisebenzi (ngayinye ngokungahleliwe ohlwini)
- Ukuguqulwa kwamagama embuzweni wosesho (sawubona seo-shnikam)
- ukudlala i-lotto njll.
Indlela 1. Ilula
Okokuqala, ake sicabangele inketho elula: sidinga ukuthola isethi engahleliwe yezinombolo eziyi-10 ukusuka ku-1 kuye ku-10. Sisebenzisa umsebenzi owakhelwe ku-Excel. PHAKATHI KWECALA (UMHLELI PHAKATHI) ukuhluka akuqinisekisiwe. Uma uyifaka kuseli yeshidi futhi uyikopishele phansi ngamaseli ayi-10, khona-ke ukuphindaphinda kungenzeka kalula:
Ngakho-ke, sizohamba ngenye indlela.
Zonke izinguqulo ze-Excel zinomsebenzi RANK (RANG), okuhloselwe ukukala noma, ngamanye amazwi, ukucacisa indawo ephezulu yenombolo esethi. Inombolo enkulu ohlwini inerenki=1, eyesibili phezulu inerenki=2, njalo njalo.
Masifake umsebenzi kuseli A2 I-SLCHIS (IRAND) ngaphandle kwama-agumenti bese ukopisha ifomula phansi kwamaseli ayi-10. Lo msebenzi uzosenzela isethi yezinombolo eziyi-10 ezingahleliwe ukusuka ku-0 kuye ku-1:
Kukholomu elandelayo sethula umsebenzi RANKukunquma isikhundla esilinganisweni senombolo ngayinye etholwe ngokungahleliwe:
Sithola kukholomu B ebesikufuna - noma iyiphi inombolo esiyifunayo yama-integer okungahleliwe angaphindi ukusuka ku-1 kuye ku-10.
Ngokwethiyori, isimo singavela lapho I-SLCHIS izosinika izinombolo ezingahleliwe ezimbili ezifanayo kukholomu A, amazinga azo azofana futhi sizothola impinda kukholamu B. Nokho, amathuba alesi simo mancane kakhulu, uma kubhekwa iqiniso lokuthi ukunemba kuyizindawo zamadesimali eziyi-15.
Indlela 2. Iyinkimbinkimbi
Le ndlela iyinkimbinkimbi kakhudlwana, kodwa isebenzisa ifomula yamalungu afanayo eyodwa kuphela. Ake sithi sidinga ukudala uhlu lwama-integer okungahleliwe angu-9 ebangeni elisuka ku-1 kuye ku-50 eshidini.
Faka ifomula elandelayo kuseli A2, chofoza ekugcineni Ctrl + Shift + Faka (ukuyifaka njengefomula yamalungu afanayo!) bese ukopisha ifomula phansi enanini elifunekayo lamaseli:
Indlela 3. Macro
Futhi, kunjalo, ungakwazi ukuxazulula inkinga usebenzisa uhlelo ku-Visual Basic. Kwesinye sezindatshana ezindala ezimayelana nokusampula okungahleliwe, sengivele ngicaphune umsebenzi omkhulu we-Lotto array, okhiqiza inombolo edingekayo yezinombolo ezingaphindwaphindwayo ukusuka kwesinye isikhathi esinikeziwe.
- Ungabala kanjani inani lamanani ahlukile kububanzi
- Ukukhetha okungahleliwe kwezakhi ohlwini