Umsebenzi I-ACCOUNT kubhekiswa kwimisebenzi yezibalo ye-Excel. Umsebenzi wawo oyinhloko ukubala uhla olucacisiwe lwamaseli aqukethe idatha yokubala. Ake sifunde kabanzi mayelana nezici ezahlukahlukene zokusebenzisa le formula.
Sebenza no-opharetha ACCOUNT
Umsebenzi I-ACCOUNT kubhekiswa eqenjini elikhulu labasebenza ngokusebenza kwezibalo, okubandakanya izinto eziyikhulu. Umsebenzi usondele kakhulu kuwo emisebenzini yawo IZAKHONO. Kepha, ngokungafani nesihloko sengxoxo yethu, kuthatha amaseli we-akhawunti agcwaliswe nganoma iyiphi idatha. Umsebenzi I-ACCOUNT, esizoqhuba ingxoxo eningiliziwe ngayo, sibala kuphela amaseli agcwele idatha ngefomethi yenombolo.
Uhlobo luni lwedatha? Lokhu kufaka phakathi inani eliyiqiniso, kanye nefomethi yosuku nesikhathi. Amanani ama-Boolean ("IQINISO", FALSE njll.) ukusebenza I-ACCOUNT inaka kuphela uma ingumbango wayo ngqo. Uma zimane zitholakala endaweni yephepha lapho impikiswano ibhekisa khona, lapho-ke opharetha akazibongi. Isimo esifanayo sinjengokumelwa kombhalo kwezinombolo, okungukuthi, lapho izinombolo zibhalwa kumaki wezingcaphuno noma zizungezwe ezinye izinhlamvu. Lapha futhi, uma kungukuphikisana okuqondile, babamba iqhaza ekubalweni, futhi uma nje beshidi, abenzi.
Kepha ngokubhekisele kumbhalo ohlanzekile okungekho zinombolo kuwo, noma izinkulumo eziyiphutha ("#DEL / 0!", #VALUE! Njll.) Isimo sehlukile. Amanani anjalo ayasebenza I-ACCOUNT alisho nganoma iyiphi indlela.
Ngaphezu kwemisebenzi I-ACCOUNT futhi IZAKHONO, ukubala inani lamaseli agcwalisiwe kusenziwa ngabasebenza I-COUNTING futhi I-COUNTIMO. Usebenzisa lawa mafomula, ungakwazi ukubala ucabangele imibandela eyengeziwe. Isihloko esihlukile sinikezelwe kuleli qembu labasebenza ngezibalo.
Isifundo: Ungasibala kanjani isibalo samaseli agcwele ku-Excel
Isifundo: Imisebenzi yezibalo ku-Excel
Indlela yoku-1: Umsebenzi Wizard
Kumsebenzisi ongenalwazi, kulula ukubala amaseli aqukethe izinombolo esebenzisa ifomula I-ACCOUNT ngosizo lwe Umsebenzi Wizards.
- Sichofoza kuseli elingenalutho eshidini lapho kuzobukiswa khona umphumela wokubala. Chofoza inkinobho "Faka umsebenzi".
Kukhona enye inketho yokuqalisa. Umsebenzi Wizards. Ukuze wenze lokhu, ngemuva kokukhetha iseli, iya kuthebhu Amafomula. Kubambo olubekwe ebhokisini lamathuluzi Umtapo wesici chofoza inkinobho "Faka umsebenzi".
Kukhona enye inketho, mhlawumbe elula kakhulu, kepha ngasikhathi sinye efuna inkumbulo enhle. Khetha iseli eshidini bese ucindezela inhlanganisela yokhiye kwikhibhodi I-Shift + F3.
- Kuzona zontathu lezi zimo, iwindows izoqala Umsebenzi Wizards. Ukuya ewindini lokuphikisana kusigaba "Izibalo"noma "Uhlu oluphelele lwe-alfabhethi" ngifuna into "I-ACCOUNT". Khetha bese uchofoza inkinobho. "Kulungile".
Futhi, iwindi lokuphikisana lingaqalwa ngenye indlela. Khetha iseli ukukhombisa umphumela bese uya kuthebhu Amafomula. Kubambo obeseqoqweni lezilungiselelo Umtapo wesici chofoza inkinobho "Eminye imisebenzi". Ukusuka ohlwini oluvelayo, hambisa isikhombisi isikhundla "Izibalo". Kumenyu evulayo, khetha "I-ACCOUNT".
- Iwindi lokuphikisana liyaqala. Ukuphikisana kuphela kwaleli formula kungaba yinani elethulwa njengesixhumanisi noma nje elibhalwe emkhakheni ohambelana nawo. Kuliqiniso, ukuqala ngohlobo lwe-Excel 2007, amanani anjalo angafika ku-255. Ezinguqulweni zangaphambili bekukhona ama-30 kuphela.
Ungafaka imininingwane emasimini ngokuthayipha amanani athile noma izixhumanisi zeseli kusuka kukhibhodi. Kepha uma uthayipha ngokuxhumanisa, kulula kakhulu ukumisa isikhombisi enkambu bese ukhetha iseli elihambelana nalo noma ibanga eshidini. Uma kukhona amabanga athile, khona-ke ikheli lesibili labo lingafakwa enkambu "Inani2" njll. Ngemuva kokuthi amanani afakiwe, chofoza inkinobho "Kulungile".
- Umphumela wokubala amaseli aqukethe amanani ezinombolo ebangeni elikhethiwe azokhonjiswa endaweni echazwe ekuqaleni kweshidi.
Isifundo: Umsebenzi Wizard e-Excel
Indlela yesi-2: Ikhomishini isebenzisa i-Optional Argument
Esibonelweni esingenhla, sihlolisise icala lapho iziphikiso zikhonjiswa kuphela kububanzi bephepha. Manje ake sibheke inketho lapho amanani afakwe ngqo enkambu yezimpikiswano nawo asetshenziswa.
- Sisebenzisa noma yikuphi ukukhetha okuchazwe indlela yokuqala, sethula iwindi lokuphikisana komsebenzi I-ACCOUNT. Ensimini "Inani1" khombisa ikheli lohlu olunedatha, nasensimini "Inani2" faka inkulumo enengqondo "IQINISO". Chofoza inkinobho "Kulungile"ukwenza ukubala.
- Umphumela uboniswa endaweni ekhethwe ngaphambilini. Njengoba ukwazi ukubona, uhlelo lwabala inani lamaseli anamanani wokubala futhi lafaka inani elilodwa ngaphezulu, esilibhalile ngegama "IQINISO" enkundleni yokuphikisana. Uma ngabe le nkulumo ibibhalwe ngqo esitokisini, futhi kwakuxhunyaniswa kuphela okumi kuyo ensimini, khona-ke bekungeke kufakwe enanini eliphelele.
Indlela 3: ukwethulwa kwencwadi ebhukwana
Ngaphezu kokusebenzisa Umsebenzi Wizards ewindini lokuphikisana, umsebenzisi angangena ngesandla isabizwana kunoma yiliphi iseli eshidi noma kubha yefomula. Kepha ngalokhu udinga ukwazi isixaka salowo opharetha. Akuyona inkimbinkimbi:
= SUM (Inani 1; Inani2; ...)
- Faka inkulumo yefomula esitokisini I-ACCOUNT ngokwe-syntax yayo.
- Ukubala umphumela bese uwubonisa esikrinini, chofoza inkinobho Ngenaibekwe kwikhibhodi.
Njengoba ukwazi ukubona, ngemuva kwalezi zenzo, umphumela wokubala uboniswa esibukweni esitokisini esikhethiwe. Abasebenzisi abanolwazi, le ndlela ingaba lula kakhulu futhi isheshe. Kunokwedlule ngenselelo Umsebenzi Wizards namafasitela aphikisayo.
Kunezindlela eziningana zokusebenzisa umsebenzi. I-ACCOUNTUmsebenzi wakhe oyinhloko ukubala amaseli aqukethe idatha yezinombolo. Usebenzisa ifomula efanayo, ungafaka idatha eyengeziwe yokubalwa ngokuqondile emkhakheni wezimpikiswano zefomula noma ngokubabhalela ngqo esitokisini ngokusho syntax yalowo opharetha. Ngaphezu kwalokho, phakathi kwe-opharetha yezibalo kunamanye amafomula abandakanyekayo ekubaleni amaseli agcwalisiwe ebangeni elikhethiwe.
