Nuna gwada yanayi tare da ayyukan Excel na AND da OR
Ayyukan AND da OR sune biyu na ayyukan Excel mafi kyau da aka sani, kuma abin da waɗannan ayyukan biyu ke yi shi ne don jarraba don ganin ko fitowar daga ɗakunan ƙwayoyin biyu ko fiye sun haɗa da ka'idodi da ka saka.
TRUE ko FALSE kawai
Ɗaya daga cikin waɗannan ayyuka shine cewa zasu dawo ko nuna daya daga cikin sakamako biyu ko Boolean dabi'u a cikin tantanin halitta inda aka samo su: TRUE ko FALSE.
- Domin aikin OR - jere na 2 a sama - yanayin da aka gwada da kuma idan duk wani yanayin da aka gwada shi gaskiya ne, to, aikin OR ya dawo da amsar TRUE. Sai dai idan duk yanayi ba gaskiya bane KO zai baka darajar FALSE;
- Don Sakamakon - jere 3 a sama - yanayi ana gwadawa kuma idan dukkanin yanayin sun kasance gaskiya ne aikin zai dawo da amsa mai ƙarfi. Idan ba haka ba, aikin zai dawo FALSE a matsayin darajar.
Haɗa da sauran ayyuka
Wadannan amsoshin TRUE ko FALSE za a iya nuna su kamar yadda suke a cikin sel inda aka samo ayyukan. Har ila yau ana iya hade ayyukan tare da sauran ayyuka na Excel - irin su aikin IF - a cikin layuka hudu da biyar a sama don ba da sakamako mai yawa ko gudanar da ƙididdiga.
Yaya Ayyukan Ayyuka
A cikin hoto a sama, sassan B2 da B3 sun ƙunshi nauyin AND da OR daidai. Dukansu suna amfani da wasu masu amfani da gwadawa don gwada yanayi daban-daban don bayanai a cikin kwayoyin A2, A3, da A4 na takardun aiki .
Biyu ayyuka sune:
= AND (A2 <50, A3 <> 75, A4> = 100)
= OR (A2 <50, A3 <> 75, A4> = 100)
Kuma yanayin da suke gwada su ne:
- idan bayanan da ke cikin salula A2 ya kasa da 50 ( < shine alama don kasa da),
- idan bayanai a cikin salula A3 ba daidai ba ne da 75 ( <> alama ce don ba daidai ba),
- idan bayanai a cikin cell A4 ya fi girma ko kuma daidai da 100 ( > = shine alama ga mafi girma ko ko daidai da).
DA FALSE KO TRUE
Don aikin DA a cikin tantanin halitta B3, bayanai a cikin kwayoyin (A2 zuwa A4) dole ne ya dace da dukkanin yanayin uku a sama don aikin don mayar da martani TRUE.
Kamar yadda yake tsaye, yanayi biyu na farko sun haɗu, amma tun lokacin ƙimar sallar A4 ba ta fi girma ba ko kuma daidai da 100, kayan fitarwa na NA aiki shine FALSE.
A cikin yanayin aikin OR a cikin sel B2, ɗaya daga cikin yanayin da ke sama ya kamata a hadu da bayanan a cikin sassan A2, A3, ko A4 don aikin don mayar da martani TRUE.
A cikin wannan misali, bayanai a cikin kwayoyin halitta A2 da A3 sun hadu da yanayin da ake buƙata don haka fitarwa don aikin OR shine TRUE.
AND / OR Ayyukan ayyuka da jayayya
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin na OR shine:
= OR (Logical1, Logical2, ... Logical255)
Haɗin aikin na AND aiki shine:
= AND (Logical1, Logical2, ... Logical255)
Logical1 - (buƙata) yana nufin yanayin da aka gwada. Nau'in yanayin shine yawancin tantancewar kwayoyin halitta na bayanan da aka bari sannan kuma yanayin da kanta, kamar A2 <50.
Logical2, Logical3, ... Logical255 - (na zaɓi) ƙarin yanayin da za a gwada har zuwa iyakar 255.
Shigar da aikin OR
Matakan da ke ƙasa suna rufe yadda za a shiga aikin OR wanda yake cikin tantanin halitta B2 a cikin hoton da ke sama. Haka matakan za a iya amfani dashi don shigar da DA aikin da ke cikin sel B3.
Kodayake yana yiwuwa a rubuta dukkan tsari kamar
= OR (A2 <50, A3 <> 75, A4> = 100)
da hannu a cikin wani saitunan aiki, wani zaɓi shine don amfani da maganganun maganganun - kamar yadda aka tsara a cikin matakan da ke ƙasa - don shigar da aikin da maganganunsa zuwa cikin tantanin halitta irin su B2.
Amfani da amfani da maganganun maganganu shine Excel yana kula da raba kowace gardama tare da rikici kuma yana rufe dukan muhawara a cikin iyaye.
Gudun daftarin aikin OR na Kwance
- Danna kan tantanin halitta B2 don sa shi tantanin aiki - wannan shine inda aikin NA zai kasance.
- Danna kan Rubutun shafin shafin rubutun .
- Danna kan maɓallin Abubuwan Aiwatarwa don buɗe jerin ayyuka na sauke ayyukan.
- Danna KO a cikin jerin don bude akwatin maganganun.
Bayanan da za a shiga cikin layuka marar haske a cikin akwatin maganganu zasu haifar da muhawarar aikin.
Shigar da muhawarar na OR
- Danna kan layi na Logical1 na maganganun maganganu.
- Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta.
- Rubuta <50 bayan bayanan salula.
- Danna kan layi na Logical2 na maganganun maganganu.
- Danna kan A3 a cikin takardun aiki don shigar da tantanin halitta na biyu.
- Rubuta < > 75 bayan bayanan salula.
- Danna kan layi na Logical3 na akwatin maganganu.
- Danna kan salula A4 a cikin maƙallan rubutu don shigar da sulhu na sulhu.
- Rubuta > = 100 bayan bayanan salula.
- Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki.
- Dogaro TRUE ya kamata ya bayyana a tantanin halitta B2 saboda bayanan da ke cikin salula A3 ya haɗu da yanayin rashin daidaitawa da 75.
- Idan ka danna kan tantanin halitta B2, cikakken aikin = OR (A2 <50, A3 <> 75, A4> = 100) ya bayyana a cikin maɓallin tsari a sama da aikin aiki.
DA maimakon KO
Kamar yadda aka ambata, za a iya amfani da matakai a sama don shiga aikin NA wanda yake cikin tantanin halitta B3 a cikin hoton ɗawainiya image.
Ayyukan da aka kammala NA zai zama: = AND (A2 <50, A3 <> 75, A4> = 100) .
Daraja na FALSE ya kamata a kasance a cikin tantanin halitta B3 tun da yake ɗaya daga cikin yanayin da aka jarraba shi ne ya zama ƙarya ga aikin NA don dawo da darajar FALSE kuma a cikin wannan misali biyu daga cikin yanayin sune ƙarya:
- bayanai a cikin salula A2 ba kasa da 50 ba;
- bayanai a cell A4 ba fiye da ko daidai da 100.