I-Operator ACCOUNT ibhekisela kwimisebenzi yezibalo ze-Excel. Umsebenzi walo oyinhloko ukuthi ubale ububanzi obubekiwe bamaseli aqukethe idatha yamanani. Masifunde kabanzi mayelana nezici ezihlukahlukene zokusebenzisa le fomula.
Sebenzisa nomsebenzi we-ACCOUNT
Umsebenzi ACCOUNT libhekisela eqenjini elikhulu labaqhubi bezinombolo, okuhlanganisa amagama angamakhulu. Umsebenzi usondelene kakhulu nemisebenzi yawo. COUNT. Kodwa, ngokungafani nenkulumo yengxoxo yethu, kuthatha amangqamuzana agcwaliswe ngokuphelele nanoma iyiphi idatha. I-Operator ACCOUNTmayelana nokuthi sizoba nengxoxo eningiliziwe, kubalwa kuphela amangqamuzana agcwele idatha ngenani lezinombolo.
Iyiphi idatha ebhekiselwa ezinqoleni? Lokhu kubhekisela ngokucacile kwinombolo yangempela, kanye nefomethi yosuku nosuku. Amanani we-boolean ("TRUE", "FALSE" njll) umsebenzi ACCOUNT kucatshangwa kuphela lapho beyizingqinamba ngokuqondile. Uma zitholakala nje endaweni yeshidi lapho iphikisana libhekisela khona, lowo opharetha akazicabangeli. Isimo esifanayo nesimo semibhalo yezinombolo, okungukuthi, lapho izinombolo zibhalwa kumaphuzu noma zizungezwe ezinye izinhlamvu. Nalapha futhi, uma bephikisana ngokushesha, bahlanganyela ekubalweni, futhi uma beseseshini, abangekho.
Kodwa ngokuphathelene nombhalo omsulwa, okungekho izinombolo, noma izinkulumo ezingalungile ("#DEL / 0!", #VALUE! Isimo) isimo sihlukile. Amanani anjalo asebenza ACCOUNT ayibhali nganoma iyiphi indlela.
Ngaphezu kwemisebenzi ACCOUNT futhi COUNT, ukubala inani lamaseli agcwele ahileleke opharetha abaningi COUNTES futhi COUNTERSILN. Ngosizo lwamafomula ungenza isibalo ucabangele izimo ezengeziwe. Leli qembu lama-opharetha wezibalo lizinikezwa esihlokweni esihlukile.
Isifundo: Indlela yokubala inani lamaseli agcwele e-Excel
Isifundo: Imisebenzi yezibalo ze-Excel
Indlela 1: Umsebenzi weWebhu
Ngomsebenzisi ongenalwazi, indlela elula yokubala amaseli aqukethe izinombolo usebenzisa ifomula ACCOUNT ngosizo luka Amakhosi omsebenzi.
- Sichofoza esitokisini esingenalutho kushidi, lapho umphumela wokubala uzoboniswa khona. Sicindezela inkinobho "Faka umsebenzi".
Kukhona enye inketho yokuqalisa. Amakhosi omsebenzi. Ukuze wenze lokhu, ngemuva kokukhetha iseli, iya kuthebhu "Amafomula". On the tape ebhodini amathuluzi "I-Function Library" cindezela inkinobho "Faka umsebenzi".
Kunenye indlela, mhlawumbe elula, kodwa ngesikhathi esifanayo edinga inkumbulo enhle. Khetha iseli kushidi bese ucindezela inhlanganisela yokhiye ekhibhodi Shift + F3.
- Kuzo zonke izimo ezintathu, iwindi lizoqala. Amakhosi omsebenzi. Ukuya efasiteleni lesigatshana seziphakamiso "Isitatimende"noma "Uhlu oluphelele lwe-alfabhethi" ngifuna into "ACCOUNT". Khetha bese uchofoza inkinobho. "Kulungile".
Futhi, iwindi lempikiswano lingathunyelwa ngenye indlela. Khetha iseli ukubonisa umphumela bese uya kuthebhu "Amafomula". Ebhebheni eqenjini lezilungiselelo "I-Function Library" chofoza inkinobho "Iminye imisebenzi". Kusukela kuhlu oluvela, susa isikhombisi endaweni "Isitatimende". Emenyu evula, khetha into "ACCOUNT".
- Iwindi lempikiswano iqala. Iphikisana kuphela yale fomula ingaba yinani elimele njengesixhumanisi noma libhalwa kuphela ensimini ehambelana nayo. Noma kunjalo, kusukela ngenguqulo ye-Excel 2007, amanani anjalo angaba ngu-255 ehlanganisiwe. Ezinguqukweni zangaphambilini kwakunabantu abangu-30 kuphela.
Idatha ingafakwa emasimini ngokuthayipha amagugu athile noma izixhumanisi zamaseli avela kukhibhodi. Kodwa kuqoqo lwezixhumanisi kulula kakhulu ukumane ubeke isikhombisi endle bese ukhetha iseli noma ibanga elifanele eshadini. Uma kunezinhlu ezimbalwa, ikheli leyesibili lingangena ensimini "Value2" nokunye Ngemva kokungena kwamanani, chofoza inkinobho. "Kulungile".
- Umphumela wokubala amaseli aqukethe amanani ezinombolo ebangeni elikhethiwe uzoboniswa endaweni yokuqala echaziwe kushidi.
Isifundo: I-Excel Function Wizard
Indlela 2: Bala nge-Argument eyengeziwe
Esikhathini esingenhla, sibheke icala lapho izimpikiswano zibhekisela kuphela emaphethini amashidi. Manje ake sicabangele inketho uma usebenzisa amanani angena ngqo enkampanini yokuphikisana.
- Nganoma yikuphi okukhethwa kukho okuchazwe kwindlela yokuqala, sebenzisa iwindi lempikiswano yokusebenza ACCOUNT. Ensimini "Inani1" ucacise ikheli lobubanzi nedatha, nasensimini "Value2" faka inkulumo enengqondo "TRUE". Sicindezela inkinobho "Kulungile"ukwenza isibalo.
- Umphumela uboniswa endaweni ekhethiwe ngaphambili. Njengoba ungabona, uhlelo lubalwe inani lamaseli anamanani ezinombolo futhi lanezela enye inani kwinani eliphelele, esibhale phansi ngegama "TRUE" kwenkambu yokuphikisana. Uma le nkulumo ibhalwa ngqo esitokisini, futhi enkundleni yayiyobe isixhumanisi sayo kuphela, khona-ke ngeke isengezwe inani eliphelele.
Indlela 3: Iformula Yomqulu Isingeniso
Ngaphezu kokusebenzisa Amakhosi omsebenzi futhi iwindi lempikiswano, umsebenzisi angakwazi ukungena encwadini ngesandla ngesandla kunoma yisiphi iseli kushidi noma kubha yefomula. Kodwa ngalokhu udinga ukwazi i-syntax yalolu opharetha. Akuyona inkimbinkimbi:
= ISUM (Inani1; Inani2; ...)
- Faka inkulumo yefomula esitokisini. ACCOUNT ngokusho kwe-syntax yayo.
- Ukuze ubale umphumela futhi uwubonise esikrinini, chofoza inkinobho. Ngenakufakwe kwikhibhodi.
Njengoba ubona, ngemuva kwalezi zenzo, umphumela wokubala uboniswa kuseli elikhethiwe. Kubasebenzisi abanolwazi, le ndlela ingaba lula nakakhulu futhi ngokushesha. Kunezikhathi ezedlule nekholi Amakhosi omsebenzi namawindi ephikisanayo.
Kunezindlela eziningana zokusebenzisa lo msebenzi. ACCOUNTumsebenzi wakhe oyinhloko ukubalwa amaseli aqukethe idatha yezinombolo. Ukusebenzisa ifomula efanayo, ungangena idatha eyengeziwe yokubala ngqo enkampanini ye-argument yefomula noma ngokuwabhala ngokuqondile kuseli ngokusho kwe-syntax yalolu opharetha. Ngaphezu kwalokho, phakathi kwama-opharetha okubalwa ngezibalo kunamanye amafomula ahilelekile ekubaleni amangqamuzana agcwalisiwe ebangeni elikhethiwe.
