Indlela yokusebenzisa ukusebenza kwe-COUNTBLANK yeSpredishithi ye-Google
AmaSpredishithi e-Google, nakuba angaxhunywanga ngokugcwele njengenguqulo yedeskithophu ye-Microsoft Excel noma i-LibreOffice Calc, noma kunjalo inikeza imisebenzi eminingi ehlose ukusekela ukuhlaziywa kwedatha. Omunye wale miisebenzi- COUNTBLANK () -buyisela inani lamaseli ebangeni elikhethiwe elinama-null.
Amapredishithi e-Google asekela imisebenzi eminingi yokubala ebala inani lamaseli ebangeni elikhethiwe eliqukethe uhlobo oluthile lwedatha.
Umsebenzi we- COUNTBLANK umsebenzi ukubala inani lamaseli ebangeni elikhethiwe ukuthi:
- Akukho lutho: Amaseli aqukethe idatha
- Okungafaki: Amaseli aqukethe ifomula ebuyisela okungenalutho noma okungenalutho
COUNTBLANK i-Syntax yomsebenzi kanye neziphakamiso
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I-syntax yomsebenzi we-COUNTBLANK yile:
= COUNTBLANK (ibanga)
Lapho uhla (ukuphikisana okudingekayo) kubonisa eyodwa noma ngaphezulu amaseli noma ngaphandle kwedatha ukuthi afakwe ekubaleni.
Ingxabano yobubanzi ingaqukatha:
- Ikholi ngayinye ekhonjiswe endaweni yedatha kushidi lokusebenzela
- Ububanzi bezinkomba zeseli
- Ibanga elibizwe
I-argument yebanga kufanele ibe yiqembu eliqoqayo lamaseli. Ngenxa yokuthi i-COUNTBLANK ayivumeli izingxenye eziningi ukuthi zingeniswe ku-argument yobubanzi , izimo eziningana zomsebenzi zingangeniswa kwifomula elilodwa ukuthola inombolo yamangqamuzana angenalutho noma angenalutho emigqeni emibili noma engaphenduki.
Ukufaka umsebenzi we-COUNTBLANK
I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.
- Chofoza kuseli C2 ukuze wenze iseli esebenzayo .
- Thayipha uphawu olulinganayo (=) olulandelwe igama lebala lokusebenza- uma uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngencwadi C.
- Uma igama le- COUNTBLANK livela ebhokisini, cindezela ukhiye we- Enter ekhibhodi ukuze ufaka igama lomsebenzi ne-parenthesis evulekile (ibhande elijikelezayo) kuseli C5.
- Qinisekisa amaseli A2 kuya ku-A10 ukuze uwafake njengengxabano yomsebenzi womsebenzi.
- Cindezela ukhiye we- Enter ekhibhodi ukuze ungeze ama-parenthesis wokuvala futhi uqedele umsebenzi.
- Impendulo izovela esitokisini C2.
COUNTBLANK Amafomu Okungalingani
Esikhundleni se-COUNTBLANK, ungasebenzisa futhi COUNTIF noma COUNTIFS.
Umsebenzi we-COUNTIF uthola inani lamangqamuzana angenalutho noma angenalutho ku-A2 kuya ku-A10 futhi unikeza imiphumela efanayo njengo-COUNTBLANK. Umsebenzi we-COUNTIFS uqukethe izimpikiswano ezimbili futhi ubala kuphela inani lezimo lapho zombili izimo zifinyelelwa khona.
Lezifomula zinikeza ukuguquguquka okungaphezulu kwezilingo ezingenalutho noma ezingenalutho ebangeni libalwa.