Amaya Toman Manambala pa Mac sikuti amangolowetsa mawu osavuta m'maselo amasamba - mutha kupanganso ma cell okhala ndi fomula kapena ntchito yomwe imapangitsa kuwerengera kosavuta komanso kothandiza kwambiri. Kupanga ma formula ndi ntchito mu Numeri ndizovuta kwambiri, koma palibe chovuta kwambiri. Manambala amapereka mazana a ntchito kuyambira zosavuta mpaka zowerengera, uinjiniya kapena zachuma.
Izo zikhoza kukhala chidwi inu
Kuti muyike fomula, dinani pa selo lomwe mukufuna kuwonjezera fomula ndikuyika chizindikiro "="". Mu mkonzi wa formula womwe umawonekera pagawo kumanja, dinani kuti musankhe zomwe mukufuna ndikutsimikizira podina Insert ntchito. Fomula yosinthira yomwe imawoneka pafupi ndi selo yosankhidwa imakokedwa pambuyo podina kumanzere kwake. Mwa kuwonekera pa chizindikiro cha fX kumanzere kwa mkonzi, mutha kuyika ngati mukufuna kuwonetsa fomuyo ngati mawu kapena kuyisintha kukhala mawu. Kenako sankhani mkangano wantchito ndikuyika mtengo wake - thandizo lothandizira liziwoneka pansi pagawo kumanja. Mukhozanso kudina kuti musankhe ma cell omwe mukufuna kugwiritsa ntchito. Kuti muphatikize zikhalidwe za mzere wonse kapena mzere mu fomula, dinani kapamwamba pamwamba pa mzere kapena kumanzere kwa mzere, kapena sankhani ma cell onse pamzere kapena mzere. Pambuyo pakusintha kofunikira, dinani batani lobiriwira kumanja kwa chosinthacho kapena dinani Enter / Return.
Ngati muwona makona atatu ofiira omwe ali ndi mawu ofuula mu selo, zikutanthauza kuti pali cholakwika mu ndondomekoyi. Mwa kuwonekera pa makona atatu, mukhoza kuona lolingana zolakwa uthenga. Kuti muwone mawerengedwe ofulumira amagulu enaake, sankhani gawo, mzere, kapena magulu enaake omwe mukufuna kuwona mawerengedwewo. Pagawo lomwe lili m'munsi mwa zenera la pulogalamuyo, mutha kuwona mitundu yosiyanasiyana yowerengera (onani chithunzi chazithunzi).
Zithunzi
Mu Nambala pa Mac, mutha kugwiritsanso ntchito zomwe zimatchedwa opareshoni m'matebulo - izi zimagwiritsidwa ntchito kuwunika ngati ma cell awiri ndi ofanana kapena ngati mtengo umodzi ndi waukulu kapena wocheperapo. Choyamba, muyenera kukhazikitsa mawu amtundu wa A1> A2 mu cell - woyendetsa adzakuuzani ngati mawuwo ndi oona. Dinani selo lomwe mukufuna kuyika zotsatira zofananitsa ndikulowetsa chizindikiro chofanana (=). Kokani ndikugwetsa chosintha chomwe chikuwoneka pafupi ndi selo kunja kwa selo. Kenako dinani pa selo lomwe mukufuna kufananitsa mtengo wake ndikulowetsa wofananira (>, <, <>, = etc.) ndikusankha selo lachiwiri kuti mufanizire.
