Kukanganisa kwakajairika kunowanikwa mu Excel mafomu uye kuti ungagadzirisa sei
Kana Excel isingagoni kunyatsoongorora fomu yemashandi kana basa; iyo icharatidza kukanganisa kwakakosha - yakadai se #REF !, #NULL !, # DIV / 0! - muchitokisi umo maitiro acho aripo.
Iko kukanganisa kunofanidza pachako pamwe nekusarudza bhosho bhatani, iyo inoratidzwa mumasero ane mapurogiramu ekukanganisa, inopa rubatsiro pakuziva dambudziko pamusoro penharo.
Zvidhori ZveGreen uye Yellow Diamonds
Excel icharatidza katatu kadiki yakasvibirira mukona yepamusoro kuruboshwe rwemasero ane zvinyorwa zvinokosha - masero D2 kusvika kuD9 mumufananidzo uri pamusoro. Huru hutatu hunoratidza kuti zvinyorwa zviri mukati zvinoputsa chimwe chekukanganisa kweEexcel kutonga mitemo.
Kushanda pachitokisi chine pfupa rakatsetseka kuchaita kuti bhodhi yakagadzirwa nemarimondi kuve pedyo nekatatu. Dhijhini tsvuku ndiyo yakasarudzwa yeEexcel yekukanganisa uye ine zvingasarudzwa zvekugadzirisa kukanganisa kunonzwisisika.
Hovering the mouse pointer pamusoro pechikanganiso chekusarudza zvingaratidza mharidzo-inozivikanwa sehover text - iyo inotsanangura chikonzero chekukanganisa kwemaitiro.
Pasi apa pane nhoroondo dzakawanda dzinokanganisa mararamiro anoratidzwa neExcel, pamwe chete nezvimwe zvinokonzera uye zvinogadzirisa kubatsira kugadzirisa dambudziko racho.
#NULL! Zvikanganiso - Zvisinganzwisisiki Zvikamu Zvitsanangudzo
#NULL! kukanganisa maitiro kunoitika apo maviri kana kupfuura mamwe masero akaparadzaniswa zvisina kunaka kana kuti asingaiti nemaune mukana mu-formula - mitsetse 2 kusvika ku5 mumufananidzo uri pamusoro.
Muchidimbu chemuenzaniso, nzvimbo inoshandiswa inoshandiswa sevashandi vekutsvaga, iyo inoreva kuti inoshandiswa painongedzera zvikamu zviviri kana kupfuura zvakapetanidza kana zvidimbu zvakasiyana-siyana zvemashoko, zvakadai se: A1: A5 A3: C3 (sero reference A3 chikamu chemazera maviri maviri , saka mitambo inopindirana).
#NULL! zvikanganiso zvinoitika kana:
- multiple cell reference in a form are separated by space instead of a mathematical operator such as a plus sign ( + ). Muenzaniso: = A1 A3 + A5;
- kutanga nekuguma kwemasero akaparadzaniswa nenzvimbo pane nzvimbo inotarisa mutambi-colon (:). Muenzaniso: = SUM (A1 A5);
- mumwe munhu sezvikamu zvinyorwa mune chirevo zvakasarudzwa nenzvimbo pane nzvimbo ye union union - iyo comma (,). Muenzaniso: = SUM (A1 A3, A5);
- iyo inonzi intersect operator (nzvimbo yemunhu) inoshandiswa nemaune, asi zvikamu zvakatarwa hazvipindi. Muenzaniso: = SUM (A1: A5 B1: B5)
Mhinduro: Dzimba dzakasiyana dzinofanirwa zvakanaka.
- akaparadzanisa masero ezvinyorwa mumutsetse ane mutambi wemasvomhu. Muenzaniso: = A1 + A3 + A5;
- kuparadzanisa kutanga uye kuguma pfungwa dzezera rakakura (:). Muenzaniso: = SUM (A1: A5);
- akaparadzanisa mumwe munhu masero anotsanangurwa mune chirevo ne comma. Muenzaniso: = SUM (A1, A3, A5);
- chengetedza kuti nzvimbo dzakasiyana dzakaparadzana. Muenzaniso: = SUM (A1: A5 A3: C3).
#REF! Zvikanganiso - Zvisingabvumirwi Ma Cell References
An invalid cell reference error inowanikwa apo chirevo chinenge chisina kukodzera masero zviratidzo - mitsetse 6 ne7 mumuenzaniso uri pamusoro. Izvi zvinowanzoitika apo:
- masero ega ega kana zvikamu zvose kana mitsara ine data inotsanangurwa mumushonga yakangoerekana yabviswa;
- Dhiyabhorosi kubva kune imwe sero inoshandiswa (kushandiswa nekucheka kana kudonha kana kudonhera uye kudonhedzera) mune imwe sero inotaridzirwa nesarudzo;
- chirevo chinosanganisira kubatana-kushandisa OLE (Kubatanidza Kubatanidza uye Kubudiswa) - kune chirongwa chisiri kunyanya kushanda iye zvino.
Mhinduro:
- shandisai Excel kushandura chiitiko chekuwanazve data yakarasika mumasero akadzingwa, ma column kana mitsetse;
- kana iyo data isingagoni kugadziriswa, dzoka zvakare data uye gadzirisa zvinyorwa zvinyorwa kana zvichidikanwa;
- mapurogiramu akazarura ane OLE links uye kuvandudza pepa rekushandisa rine #REF! kukanganisa.
# DIV / O! - Gurai neZero Mhosva
Gurai nezvikanganiso zvitatu zvinoitika apo chimiro chinoedza kugovana ne zero - mitsetse 8 ne9 mumufananidzo wepamusoro. Izvi zvinogona kukonzerwa apo:
- iyo dudziro kana denominator mubasa rekuparadzanisa yakaenzana ne zero - kana pachena - se = A5 / 0 kana semugumisiro wechipiri kuverenga ine zero nekuda kwechigumisiro;
- chirevo chekutsanangurira sero iyo isina chinhu.
Mhinduro:
- Tarisa kuti une dhi rakarurama mumasero anotsanangurwa mumutsetse.
- Tarisa kuti data yako iri mumakiromita akakodzera.
- Cherechedza kuti yakakodzera masero ezvinyorwa akashandiswa mumutsetse.
##### Chikanganiso - Cell Formatting
Sero yakazadzwa nemutsara weHaashags , zviratidzo zvemazita, kana zviratidzo zvepaundi sezvazvinonziwo, hazvitauri sechikanganiso chinoshandiswa naMicrosoft asi zvinonzi chichikonzerwa nehurefu hwe data yakapinda muchitokisi chakaitwa.
Saka, mutsetse we ##### unoitika mumhando dzakasiyana-siyana, dzakadai sekuti:
- iyo inopinda kukosha yakazara kupfuura ikozvino sero kubhiti kweesero yakagadzirirwa mazuva kana nguva - mutsara 10 mumufananidzo uri pamusoro.
- chirevo chinopinda muchitokisi chakasanganiswa kuti nhamba inobereka chigumisiro icho chakapfuura kupfuura sero.
- nhamba kana nhamba yedhesi, inopfuura mazita 253, inopinda muchitokisi yakarongedzwa nokuda kwemazuva, nhamba, kana kuverenga.
- nhamba isina kunaka inogara mune imwe sero yakave yakarongedzwa kwemazuva kana nguva. Mazuva uye nguva muExcel zvinofanira kuva nemaonero akanaka sezvakaratidzwa munharaunda 11 mumufananidzo uri pamusoro.
Mhinduro:
- Wedzerai sero rakagadziriswa nekuwedzera iyo korome (masero ega ega haagoni kuwedzerwa pasina kuwedzera muromo wose).
- Svetesa urefu hwe data iri muchitokisi kana zvichibvira kana kusarudza fomu yakasiyana yesero seGeneral .
- Ruramisa zuva kana kukosha kwemaawa mukati memasero akabatwa kuitira kuti chigumisiro chisati chakaipa.
- Ruramisa nzira iyo inoguma nenguva isina kunaka kana kuti kukoshesa kwezuva kunoratidzwa mumatare akabatwa.