Phakathi kwezinkomba eziningi ezisetshenziselwa izibalo, kudingeka ukhethe ukubalwa kokuhluka. Kumele kuqashelwe ukuthi ukwenza ngokwezifiso lokhu kubalwa kuwumsebenzi onzima kakhulu. Ngenhlanhla, i-Excel inemisebenzi yokwenza inqubo yokubala. Thola i-algorithm yokusebenza ngalawa mathuluzi.
Ukubalwa kokuhluka
Ukuhlakazeka kuyisilinganiso sokuhlukahluka, okuyikwele eliphakathi lokuphambuka kusuka ekulindeni. Ngakho-ke, kubonisa ukuhluka kwezinombolo ezihlobene nencazelo. Ukubala kokuhluka kungahle kwenziwe kubantu abaningi, kanye nesampula.
Indlela 1: Ukubala inani labantu
Ukuze kubalwe le nkomba ku-Excel kubo bonke abantu, umsebenzi I-DISP.G. I-syntax yale nkulumo ilandelayo:
= ISIQEPHU G (Inomboro 1; Inombolo 2; ...)
Ingqikithi yenkulumo engu-1 kuya ku-255 ingasetshenziswa. Izimpikiswano zingaba yizinombolo zamanani noma izinkomba ezisezintweni eziqukethwe kuzo.
Ake sibone ukuthi singakanani ukubala leli xabiso ebangeni nge idatha yenombolo.
- Yenza ukhetho lweseli eshadini, lapho imiphumela yokubala kokuhluka kuzoboniswa khona. Chofoza inkinobho "Faka umsebenzi"kufakwe ngakwesokunxele kwe-bar yefomula.
- Iqala Umsebenzi weWebhu. Esikhathini "Isitatimende" noma "Uhlu oluphelele lwe-alfabhethi" yenza usesho lwempikiswano negama "DISP.G". Uma usutholiwe, khetha bese uchofoza inkinobho "Kulungile".
- Yenza i-arguments function window I-DISP.G. Setha isikhombisi emkhakheni "Number1". Khetha uhla lwamaseli eshidi, equkethe uchungechunge lwamanani. Uma kunezinhlobo eziningi eziningana, zingasetshenziswa futhi ukufaka izixhumanisi zabo efasiteleni lokuphikisana kwensimu "Number2", "Number3" nokunye Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalezi zenzo, ukubalwa kwenziwa. Umphumela wokubala ukuhluka kwesibalo sabantu kuboniswa kuseli elichazwe ngaphambilini. Lona kanye iseli lapho ifomula itholakala khona I-DISP.G.
Isifundo: I-Excel umsebenzi wizard
Indlela 2: ukubalwa kwesampuli
Ngokuphambene nokubala kwenani labantu jikelele, ekubalweni kwesampula, i-denominator ayibonakali inani lezinombolo, kodwa elilodwa lingaphansi. Lokhu kwenziwa ukuze kulungiswe iphutha. I-Excel iyacabangela le nuance emisebenzini ekhethekile eyenzelwe lolu hlobo lokubala - i-DISP.V. I-syntax yayo imelwe ifomula elandelayo:
= DISP.V (Inombolo1; Inombolo2; ...)
Inombolo yezimpikiswano, njengomsebenzi wangaphambilini, ingahluka kusukela ku-1 kuya ku-255.
- Khetha iseli futhi ngendlela efanayo nangesikhathi esidlule, sebenzisa Umsebenzi weWebhu.
- Esikhathini "Uhlu oluphelele lwe-alfabhethi" noma "Isitatimende" bheka igama "DISP.V". Ngemuva kokuthi ifomula itholakala, khetha bese uchofoza inkinobho "Kulungile".
- I-window ye-arguments window iqalisiwe. Okulandelayo, siqhubeka ngendlela efanayo nokusebenzisa isitatimende sangaphambilini: setha isikhombisi enkampanini yokuphikisana "Number1" bese ukhetha indawo equkethe uchungechunge lwamanani ekhasini. Bese uchofoza inkinobho. "Kulungile".
- Umphumela wokubala uzoboniswa kuseli elihlukile.
Isifundo: Ezinye imisebenzi zezibalo ku-Excel
Njengoba ungabona, uhlelo lwe-Excel lungasiza kakhulu ukubala kokuhluka. Lesi sibalo singabalwa ngesicelo, kokubili kubantu jikelele kanye nesampula. Kulesi simo, zonke izenzo zomsebenzisi empeleni ziyancishiswa kuphela ukucacisa uhla lwezinombolo ezicutshungulwayo, futhi i-Excel yenza umsebenzi oyedwa ngokwayo. Yiqiniso, lokhu kuzosindisa isikhathi esibalulekile somsebenzisi.
