Okuqukethwe
I-Microsoft Word inomyalo wemenyu omkhulu Ifomethi – Uhlu (Ifomethi — Izinhlamvu nezinombolo), okukuvumela ukuthi uguqule ngokushesha isethi yezigaba ibe uhlu olunamachashazi noma olunezinombolo. Fast, elula, ebonakalayo, asikho isidingo ukulandela izinombolo. Awukho umsebenzi onjalo ku-Excel, kodwa ungazama ukuwulingisa usebenzisa amafomula alula nokufometha.
Uhlu olunamachashazi
Khetha amaseli edatha wohlu, chofoza kwesokudla kuwo bese ukhetha Ifomethi yeseli (Fometha Amaseli), ithebhu Inombolo (inombolo), Ngaphezu kwalokho - Wonke amafomethi (Ngokwezifiso). Khona ensimini Uhlobo faka imaski yefomethi yangokwezifiso elandelayo:
Ukufaka ichashazi eligqamile, ungasebenzisa isinqamuleli sekhibhodi u-Alt + 0149 (bamba u-Alt bese uthayipha 0149 ekhiphedi yezinombolo).
Uhlu olunezinombolo
Khetha iseli elingenalutho kwesokunxele ekuqaleni kohlu (esithombeni lithi C1) bese ufaka ifomula elandelayo kulo:
=IF(ISBLANK(D1),””;COUNT($D$1:D1))
=IF(ISBLANK(D1);»»;COUNTA($D$1:D1))
Bese ukopisha ifomula kuyo yonke ikholomu. Kufanele ugcine ngokufana nalokhu:
Eqinisweni, ifomula kukholomu C ihlola okuqukethwe kweseli eduze kwesokudla (imisebenzi IF и ISBLANK). Uma iseli eliseduze lingenalutho, ngakho-ke asibonisi lutho (izingcaphuno ezingenalutho). Uma ingenalutho, bonisa inombolo yamaseli angenalutho (umsebenzi I-COUNT) kusukela ekuqaleni kohlu kuya kuseli yamanje, okungukuthi, inombolo ye-ordinal.