Tsarin madauri yana faruwa a Excel lokacin da:
- Wata takarda tana dauke da tantanin halitta game da tantanin halitta wanda ya ƙunshi maɓallin kanta. Misali na wannan nau'in madauwari yana nuna a cikin hoton da ke sama inda inda ake magana a cikin tantanin halitta C1 yana dauke da ma'anar wannan tantanin halitta a cikin tsari: = A1 + A2 + A3 + C1
- Wata hanya tana nuna wasu ma'anar da zata sake komawa tantanin tantanin halitta wanda ya ƙunshi asali. Misali na irin wannan hanyar kai tsaye kamar yadda aka sani an nuna shi a misalin na biyu a cikin hoton inda bakan kiban da ke danganta kwayoyin A7, B7, da B9 sun nuna cewa ƙwayoyin da ke cikin wadannan kwayoyin sunyi la'akari da juna.
Tsarin Shawarar Gargaɗi
Kamar yadda aka nuna a cikin hoton da ke sama, idan wata mahimmanci ya fito a cikin takardar aiki na Excel, shirin yana nuna akwatin maganganun Alert yana nuna matsalar.
Sakon da yake a cikin akwatin maganganun ana magana da shi musamman saboda ba duk rubutattun siginar a cikin shafuka ba ne kamar yadda aka tsara a kasa.
"Mai kulawa, mun sami sifofi ɗaya ko fiye madauri a cikin littafinka wanda zai iya haifar da tsarinka don ƙididdigewa ba daidai ba"
Zabuka Masu amfani
Zaɓuɓɓukan mai amfani lokacin da akwatin maganganun ya bayyana yana danna Yaba ko Taimako, kuma ba wanda zai gyara matsalar ƙaddamarwar madauwari.
Idan kun karanta dogon lokaci da ɗan rikice a cikin akwatin maganganun za ku gane cewa:
- danna kan Taimako yana nufin amfani da shi lokacin da tsayayyar motsi ba tare da tunani ba; wannan yana ɗauke da ku zuwa bayanan fayil na bayanan na Excel game da nassoshi madauwari;
- danna OK ya yi amfani da shi don gaya Excel cewa an yi ma'anar madauwari da gangan kuma ya kamata ya bar shi a wuri.
Ƙididdiga Tsuntsauran Ƙira
Idan an yi maƙalar sakonni ba tare da gangan ba, bayanin taimakon fayil zai gaya muku yadda za ku ci gaba da ganowa da kuma cire nassoshi madauwari.
Fayil din taimakon za ta jagoranta ka don amfani da Error Error Checking kayan aiki da ke ƙarƙashin Formulas> Rubutun Kalma akan rubutun.
Yawancin labaran ƙwayoyin halitta ba tare da tantancewa ba za'a iya gyara ba tare da buƙatar kuskuren kuskure ta hanyar gyara daidai da ma'anar salula da aka yi amfani da ita ba. Maimakon rubuta kalmomin tantanin halitta a cikin wani tsari, amfani da ma'ana ------------------ danna ma'anar tantanin halitta tare da linzamin kwamfuta -------------- -------- don shigar da nassoshi cikin wani tsari.
Ra'ayoyin Tsarin Shawara
Hikimar madauwari ta Excel ba ta bayar da ƙayyadadden matsala ta hanyar ƙirar madaidaici ba domin ba dukan ƙididdigar madogara ba ne kuskure.
Yayinda waɗannan nassoshi masu mahimmanci ba su da mahimmanci fiye da wadanda basu da hankali, za a iya amfani da su idan kuna son Excel suyi amfani da shi ko yin amfani da tsari sau da yawa kafin a samar da sakamakon.
Yarda da Takaddun Ayyuka
Excel yana da wani zaɓi don taimaka wa waɗannan ƙididdigar lissafi idan kun shirya yin amfani da su.
Don ba da lissafin bayani:
- Danna kan fayil na shafin (ko button a cikin Excel 2007)
- Danna Zabuka don buɗe akwatin maganganu na Excel Zabuka
- A cikin ɓangaren hagu na akwatin maganganu, danna Formulas
- A cikin ɓangaren dama na akwatin maganganu, zaɓi Ƙara lissafin lissafin lissafi
Da ke ƙasa akwai zaɓin akwati don:
- saita matsakaicin adadin lokuta: yawan lokuta Excel ya kamata ya sake maimaita wannan tsari
- saita matsakaicin iyakar canjin da aka samu tsakanin sakamakon lissafi: ƙananan lambar, mafi ƙimar sakamakon
Ana nuna Zeros a cikin Sanyoyin da Aka Shafi
Don kwayoyin dake dauke da nassoshi madauwari, Excel ya nuna ko dai babu siffar kamar yadda aka nuna a cell C1 a misali ko ƙimar ƙidayar ƙarshe a tantanin halitta.
A wasu lokuta, ƙididdiga na iya tafiyar da nasara kafin su yi kokarin tantance tamanin tantancewar tantanin halitta a inda suke. Lokacin da wannan ya faru, tantanin halitta dauke da wannan tsari yana nuna darajar daga lissafi na ƙarshe.
Ƙari Game da Tsarin Shawarar Gargaɗi
Bayan samfurin farko na wata maƙirar da ke dauke da madaidaiciya a cikin littafi mai aiki , Excel ba dole ba ne sake nuna saƙon saƙo. Ya dogara ne akan yanayin da ta yaya kuma inda aka ƙirƙiri ƙarin nassoshi.
Misalan lokacin da akwatin da aka jijjiga wanda ke dauke da saƙon saƙo za a nuna shi don madaurin haruffa na gaba:
- Misali na farko na madaidaiciyar madogara a kowane littafi na budewa;
- Bayan cire duk nassoshi a madogara a cikin dukkan litattafan budewa, an kirkiro wani sabon tsari;
- Bayan rufe duk littattafan littattafai, ana kirkiro wani tsari da ke dauke da madaidaiciyar madogara a cikin sabon littafin aiki;
- An bude littafi mai ɗaukar madaidaiciyar madogara.