Microsoft Word ine yakakura menyu yekuraira Maumbirwo – Rondedzero (Maumbirwo - Mabara uye Nhamba), iyo inokubvumira kukurumidza kushandura seti yendima kuita rondedzero ine mabara kana ine nhamba. Kurumidza, kuri nyore, kuona, hapana chikonzero chekutevera manhamba. Iko hakuna basa rakadaro muExcel, asi unogona kuedza kuitevedzera uchishandisa mafomula akareruka uye mafomati.
Bulleted list
Sarudza masero edata kune runyorwa, tinya-kurudyi paari uye sarudza Sero format (Mafomati Masero), tab nhamba (nhamba), Uyezve - Mafomu ese (Tsika). Zvino mumunda Rudzi isa iyo inotevera tsika fomati mask:
Kuisa doti rakashinga, unogona kushandisa nzira yekudimbudzira kiibhodhi Alt + 0149 (bata Alt wonyora 0149 pakiyipadhi yenhamba).
Manumber list
Sarudza sero risina chinhu kuruboshwe kwekutanga kwechinyorwa (mumufananidzo uri C1) uye isa inotevera fomula mairi:
=KANA(ISBLANK(D1),””;COUNT($D$1:D1))
=KANA(ISBLANK(D1);»»;COUNTA($D$1:D1))
Wobva wakopa fomula kune iyo column yese. Iwe unofanirwa kupedzisira uine chinhu chakadai:
Muchokwadi, iyo fomula muchikamu C inotarisa zviri mukati mesero padyo nekurudyi (mabasa IF и ISBLANK) Kana iyo sero yepedyo isina chinhu, saka isu hatiratidze chero chinhu (isina quotes). Kana isina chinhu, wobva waratidza huwandu hwemasero asina chinhu (function NY) kubva panotangira runyoro kusvika kune sero razvino, kureva nhamba yeordinal.