Zolakwitsa zambiri zimapezeka mu Excel ma formula ndi momwe mungakonzekere
Ngati Excel silingathe bwino ndondomeko ya ntchito kapena ntchito; idzawonetsa zolakwika - monga #REF !, #NULL !, # DIV / 0! - mu selo momwe chikhalidwecho chili.
Cholakwikacho chimadzikweza chokha kuphatikizapo batani la zosankha, zomwe zimawonetsedwa m'maselo ndi zolakwika, zimapereka chithandizo pozindikira vuto la vutoli.
Triangles a Green ndi Diamondi Yellow
Excel iwonetsa katatu kakang'ono kobiriwira kumtunda wapamwamba kumanzere kwa maselo okhala ndi zolakwika - maselo D2 mpaka D9 mu chithunzi pamwambapa. Katatu wobiriwira amasonyeza kuti zomwe zili m'katimo zimaphwanya malamulo ena olakwika a Excel.
Kuyika pa selo yomwe ili ndi katatu wobiriwira kumayambitsa batani la chikasu chooneka ngati chikasu. Daimondi yachikasu ndibokosi la zolakwika za Excel ndipo liri ndi njira zothetsera zolakwikazo.
Kuwongolera pointer ya mouse pambali ya batani yosankha mungasonyeze uthenga - wotchedwa hover text - yomwe imalongosola chifukwa cha zolakwikazo.
M'munsimu muli mndandanda wa malingaliro olakwika omwe akuwonetsedwa ndi Excel, pamodzi ndi zifukwa zomwe zimayambitsa zothetsera vutoli.
#NULL! Zolakwitsa - Zigawidwe Zapadera za Cell
#NULL! Malingaliro olakwika amapezeka pamene mafotokozedwe awiri kapena angapo amasiyanitsidwa molakwika kapena mosadziwika ndi malo mu fomu - mzere 2 mpaka 5 mu chithunzi pamwambapa.
Mu ma Excel formula, chiwonetsero cha danga chikugwiritsidwa ntchito monga wogwiritsira ntchito, kutanthauza kuti imagwiritsidwa ntchito polemba mndandanda wa zigawo ziwiri kapena zingapo zomwe zimagwirizanitsa, monga: A1: A5 A3: C3 (cell reference A3 ndi mbali ya mawiri awiri , choncho mizere imadutsana).
#NULL! zolakwika zimachitika ngati:
- ma selo angapo mumasewu amasiyanitsidwa ndi malo m'malo mwa masamu monga chizindikiro chowonjezera ( + ). Chitsanzo: = A1 A3 + A5;
- mapepala oyambirira ndi otsiriza a maselo akulekanitsidwa ndi danga mmalo mwa otsogolera osiyanasiyana - colon (:). Chitsanzo: = SUM (A1 A5);
- Mafotokozedwe amodzi omwe ali m'ndandanda amapatulidwa ndi malo m'malo mwa ogwirizanitsa - comma (,). Chitsanzo: = SUM (A1 A3, A5);
- wogwiritsira ntchito (malo amtundu) amagwiritsidwa ntchito mwachangu, koma mndandanda wazinthu sizidutsutsana. Chitsanzo: = SUM (A1: A5 B1: B5)
Zolinga: Kusiyanitsa mafotokozedwe a selo molondola.
- magawo osiyana a maselo mu chidule ndi olemba masamu. Chitsanzo: = A1 + A3 + A5;
- yambani mapepala oyambirira ndi mapeto a osiyanasiyana ndi colon (:). Chitsanzo: = SUM (A1: A5);
- mafotokozedwe osiyana pamaselo payekha ndi chida. Chitsanzo: = SUM (A1, A3, A5);
- onetsetsani kuti mzere wosiyana ndi danga kwenikweni umadutsana. Chitsanzo: = SUM (A1: A5 A3: C3).
#REF! Zolakwitsa - Zolemba Zomwe Sizilondola
Cholakwika cholakwika cha selo chikupezeka pamene fomu ili ndi maumboni olakwika a selo - mzere 6 ndi 7 mu chitsanzo chapamwamba. Izi zimachitika nthawi zambiri pamene:
- maselo amodzi kapena mazenera onse kapena mizere yomwe ili ndi deta yomwe imatchulidwa mu njirayi yawonongeka mwangozi;
- Deta kuchokera ku selo imodzi imasunthidwa (pogwiritsa ntchito kudula ndi kuphatikiza kapena kukoka ndi kuponyera) mu selo yomwe imatchulidwa ndi ndondomeko;
- ndondomeko ili ndi chiyanjano - pogwiritsira ntchito OLE (Kuphatikizana ndi Kuphatikizidwa) - ku pulogalamu yomwe ikuchitikabe.
Zothetsera:
- gwiritsani ntchito ndondomeko yowonongeka kwa Excel kuti mubwezeretse deta yotayika m'maselo otsala, mizere kapena mizere;
- ngati deta silingapezeke, yongolani deta ndikusintha mafotokozedwe a selo ngati pakufunikira;
- mapulogalamu otseguka omwe ali ndi maulumikizi a OLE ndikusintha tsamba lomwe lili ndi #REF! zolakwika.
# DIV / O! - Gawani ndi Zolakwa Zero
Gawani ndi zolakwa 0 zikuchitika pamene fomu ikuyesera kugawa ndi zero - mzere 8 ndi 9 mu chithunzi pamwambapa. Izi zikhoza kuchitika pamene:
- wotsogolera kapena gulu mu ntchito yogawanitsa ndi ofanana ndi zero - kaya momveka - monga = A5 / 0 kapena monga zotsatira za chiwerengero chachiwiri chomwe chiri ndi zotsatira;
- ndondomeko yosonyeza selo yomwe ilibe kanthu.
Zothetsera:
- Onetsetsani kuti muli ndi deta yolondola m'maselo omwe tawatchula.
- Onetsetsani kuti deta yanu ili mumaselo olondola.
- Onetsetsani kuti mafotokozedwe olondola a selo amagwiritsidwa ntchito mu njirayi.
##### Zolakwitsa - Kulemba Zithunzi
Selo lodzaza ndi mahtasag , zizindikiro za nambala, kapena zizindikiro za mapaundi monga momwe zimatchulidwanso, sizitchulidwa kuti ndizolakwika kwa Microsoft koma zimatengedwa chifukwa cha kutalika kwa deta yomwe inalowa mu selo lopangidwa.
Choncho, mzere wa ##### umachitika nthawi zosiyanasiyana, monga pamene:
- malingaliro olowa mkati ndi ochuluka kusiyana ndi mawonekedwe a pakali pano a selo lopangidwira masiku kapena nthawi - mzere 10 mu chithunzi pamwambapa.
- ndondomeko yalowa mu selo yosinthidwa kwa manambala imabweretsa zotsatira zomwe ndizitali kuposa selo.
- Deta yamtundu kapena malemba, pazinthu zoposa 253, imalowa mu selo yopangidwa ndi masiku, nthawi, kapena ndalama.
- nambala yolakwika imakhala mu selo yomwe yapangidwa kwa nthawi kapena nthawi. Nthawi ndi nthawi mu Excel ziyenera kukhala ndi mfundo zabwino monga momwe tawonetsera mzere 11 mu chithunzi pamwambapa.
Zothetsera:
- Tsekulitsani selo lokhudzidwayo pofutukula chigawochi (maselo pawokha sangathe kufalikira popanda kuwonjezera chigawo chonse).
- Fufuzani kutalika kwa deta mu selo ngati nkotheka kapena musankhe mtundu wosiyana wa selo monga General .
- Lembetsani tsiku kapena nthawi yamtengo wapatali mu selo yogwidwa kuti zotsatira zisakhale zoipa.
- Konzani njira yomwe imapangitsa kuti nthawi yosasintha kapena tsiku lachiwonetsero liwonetsedwe mu selo yogwidwa.