Mai gudanarwa kwatankwacin

Excel da Tashoshin Kwantattun Bayanai guda shida na Google

Masu gudanarwa, a gaba ɗaya, alamomin da aka yi amfani da su a cikin siffofin don ƙayyade irin lissafin da za'a ɗauka.

Mai aiki na kwatanta, kamar yadda sunan ya nuna, yana ɗaukar kwatanta tsakanin dabi'u guda biyu a cikin tsari kuma sakamakon wannan kwatanci zai iya zama ko TRUE ko FALSE kawai.

Masu daidaitawa shida

Kamar yadda aka nuna a cikin hoton da ke sama, akwai masu amfani da misalin misalin shida da suke amfani da su a cikin shirye-shiryen sassauki irin su Excel da Google Spreadsheets.

Ana amfani da waɗannan masu amfani don gwada yanayin kamar:

• daidaitattun lambobi, kamar 5 = 5,
• Ƙananan daidaito,
  • kamar 4 <> 5 (ba daidai)
  • ko 5> = 4 (mafi girma ko ko daidai da).

Yi amfani da Formulas na Cell

Excel yana da matukar sassauci a hanyar da za'a iya amfani da waɗannan masu amfani da su. Alal misali, zaka iya amfani da su don kwatanta sel guda biyu , ko kwatanta sakamakon daya ko fiye da ƙwayoyin . Misali:

• = A1 = A2
• = A1 = (A2 * 5)
• = (A1 * 10) <= (A2 / 5)

Kamar yadda waɗannan misalai suka ba da shawara, za ka iya rubuta wadannan a cikin sel a cikin Excel kuma Ka yi Excel lissafta sakamakon dabarar kamar yadda zai yi da kowane tsari.

Tare da waɗannan matakan, Excel zai dawo ko dai TRUE ko FALSE a matsayin sakamakon cikin tantanin halitta.

Za'a iya amfani da masu amfani da kwakwalwa a cikin wani tsari wanda ya kwatanta dabi'u a cikin kwayoyin biyu a cikin takardun aiki .

Bugu da ƙari, sakamakon wannan nau'i na samfurin zai kasance ko TRUE ko FALSE kawai.

Alal misali, idan salula A1 ya ƙunshi lambar 23 da salula A2 ya ƙunshi lamba 32, ma'anar = A2> A1 zai dawo sakamakon TRUE.

Ma'anar = A1> A2, a gefe guda, zai dawo da sakamakon FALSE.

Yi amfani da Bayanan Yanayi

Ana amfani da masu amfani da kwaskwarima a cikin maganganun kwakwalwa, irin su ƙwaƙwalwar gwajin gwaji ta IF don ƙayyade daidaito ko bambanci tsakanin dabi'u biyu ko wasan kwaikwayo.

Gwajin gwaji na iya zama kwatanci tsakanin sassan layi biyu kamar:

A3> B3

Ko gwajin gwaji na iya kasancewa kwatanta tsakanin tantanin halitta da ƙayyadadden adadin kamar:

C4 <= 100

A game da aikin IF, kodayake gwajin gwajin gwaji kawai yayi la'akari da kwatanta kamar TRUE ko FALSE, aikin IF ba ya nuna waɗannan sakamakon a cikin fayilolin aikin aiki.

Maimakon haka, idan yanayin da aka gwada shi ne TRUE, aikin yana aiwatar da aikin da aka jera a cikin ƙimar Value_if_true .

Idan, a gefe guda, yanayin da ake jarraba shi ne FALSE, aikin da aka jera a cikin shawara na Value_if_false an kashe a maimakon.

Misali:

= IF (A1> 100, "Fiye da mutum ɗari", "Ɗari ɗari ko žasa")

An gwada gwajin gwaji a cikin wannan aikin IF don sanin ko darajar da take cikin sel A1 ya fi 100.

Idan wannan yanayin shine TRUE (lamba a A1 ya fi 100), saƙon rubutu na farko Mafi fiye da mutum ɗari an nuna a cikin tantanin halitta inda tsarin ya kasance.

Idan wannan yanayin shine FALSE (lamba a A1 yana da ƙasa da ko kuma daidai da 100), sakon na biyu Ɗari ko žasa yana nuna a cikin tantanin halitta dauke da wannan tsari.

Yi amfani da Macros

Ana amfani da masu amfani da kwakwalwa cikin maganganu masu mahimmanci a cikin Excel macros , musamman ma a cikin madaukai, inda sakamakon sakamakon ya yanke hukunci ko kisa ya kamata a ci gaba.