Yadda za a yi amfani da Ayyukan DA DA KO Aiki a cikin Google Sheets

Gwada sharuɗɗan yanayi don dawo da sakamako na TRUE ko FALSE

Ayyukan AND da OR sune biyu daga cikin ayyukan da aka fi sani a cikin Google Sheets . Suna gwada don ganin ko fitowar daga ɗakunan ƙirar biyu ko fiye sun hadu da ka'idodi da ka saka.

Wadannan ayyuka masu mahimmanci zasu dawo daya daga sakamako biyu (ko Boolean dabi'u ) a cikin tantanin halitta inda aka yi amfani da su, ko TRUE ko FALSE:

• Ga Sakamakon da yake da shi , ana gwada kwayoyin halitta a cikin sel masu yawa. Sai kawai idan duk waɗannan ƙididdiga sun kasance gaskiya ne aikin zai dawo da amsa mai ƙarfi. Idan ba haka ba, aikin zai dawo FALSE a matsayin darajar.
• Domin aikin OR , idan duk wani samfurin da aka gwada gaskiya ne, to, aikin OR ya dawo da amsar TRUE. Sai kawai idan duk samfurori ba gaskiya bane KO zai baka darajar FALSE a cikin tantanin halitta inda aka samo shi.

Wadannan TRUE ko FALSE suna amsa tambayoyin AND da OR zasu iya bayyana kamar yadda yake a cikin sel inda ake aiki, ko ayyuka zasu iya haɗawa tare da sauran ayyukan Rubutun Google, irin su aikin IF , don nuna alamun da dama ko kuma don gudanar da ƙididdiga.

Yaya Ayyukan Ma'anar Aiki ke aiki a cikin Google Sheets

Hoton da ke sama, sassan B2 da B3 sun ƙunshi nauyin AND da OR, daidai da haka. 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)

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 da 75 ( <> alama ce don ba daidai ba)
• Idan bayanan da ke cikin salula A4 ya fi girma ko kuma daidai da 100 ( > = shine alama don mafi girma ko ko daidai da)

Don DA aiki a cikin tantanin halitta B2, bayanai a cikin sassan A2 zuwa A4 dole ne ya dace da dukkanin yanayin uku a sama domin aikin don dawo da amsa mai ƙarfi. 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 game da aikin OR a cikin tantanin halitta B3, ɗaya daga cikin yanayin da ke sama ya kamata a hadu da bayanan a cikin sassan A2, A3, ko A4 domin aikin don dawo da amsa mai ƙarfi. A cikin wannan misali, bayanan da ke cikin sel A2 da A3 sun haɗu da yanayin da ake buƙata, don haka fitarwa don aikin OR shine TRUE.

Hadin rubutu da Magana akan ayyukan AND / OR

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Haɗin aikin na AND aiki shine:

= AND ( logical_expression1, logical_expression2, ... )

Haɗin aikin na OR shine:

= OR ( logical_expression1, logical_expression2, logical_expression3, ... )

• logical_expression1 [Bukatar] yana nufin yanayin da aka jarraba. Nau'in yanayin shine yawancin tantancewar kwayoyin halitta na bayanan da aka bari sannan kuma yanayin da kanta, kamar A2 <50.
• logical_expression2 , logical_expression3, ... [Zaɓi] ne ƙarin yanayi da za a iya gwada.

Shigar da AND Function

Matakan da suka biyo baya sunyi yadda za a shigar da DA aikin da ke cikin tantanin halitta B2 a cikin hoton da ke sama. Haka matakan za a iya amfani dashi don shiga aikin OR wanda yake cikin tantanin halitta B3.

Google Sheets ba ya amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda Excel yake yi. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.

1. Danna kan tantanin halitta B2 don sa shi tantanin halitta ; Wannan shi ne inda aka shigar da aikin NA kuma inda za a nuna sakamakon aikin.
2. Rubuta daidai alamar ( = ) bi da aikin NA .
3. Yayin da kake bugawa, akwatin zane-zane yana nuna tare da sunayen ayyukan da suka fara tare da harafin A.
4. Lokacin da aikin kuma ya bayyana a akwatin, danna sunan tare da maɓallin linzamin kwamfuta.

Shigar da Magana Magana

An shigar da muhawarar DA AND aiki bayan bude budewa. Kamar yadda yake a cikin Excel, an saka waƙa a tsakanin muhawarar aiki don aiki a matsayin mai raba.

1. Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta kamar maganganun logical_expression1 .
2. Rubuta <50 bayan bayanan salula.
3. Rubuta comma bayan bayanan tantanin halitta don aiki a matsayin mai raba tsakani a tsakanin muhawarar aikin.
4. Danna kan A3 a cikin takardar aiki don shigar da wannan tantanin halitta kamar maganganun logical_expression2 .
5. Rubuta <> 75 bayan bayanan salula.
6. Rubuta comma na biyu don aiki a matsayin wani mai warewa.
7. Danna kan A4 a cikin takardun aiki don shigar da sulhu na uku.
8. Rubuta > = 100 bayan bayanan sulhu na uku.
9. Latsa maɓallin shigarwa a kan keyboard don shigar da bayanan rufe bayan bayanan da kuma kammala aikin.

Darajar FALSE ya kamata ya bayyana a cikin tantanin halitta B2 saboda bayanan a cikin cell A4 ba ya haɗu da yanayin kasancewa mafi girma ko kuma daidai da 100.

Idan ka danna kan tantanin halitta B2, cikakken aikin = AND (A2 <50, A3 <> 75, A4> = 100) ya bayyana a cikin maɓallin tsari a sama da aikin aiki.

OR Maimakon DA

Matakan da ke sama za a iya amfani da su don shiga aikin OR wanda yake cikin tantanin halitta B3 a cikin hoton ɗawainiya a sama.

Ayyukan da aka kammala OR zai zama = OR (A2 <50, A3 <> 75, A4> = 100).

Tamanin TRUE ya kamata a kasance a cikin tantanin halitta B3 tun da yake ɗaya daga cikin yanayin da ake jarraba ya kamata ya zama gaskiya ga aikin OR don dawo da darajar TRUE, kuma a cikin wannan misali biyu daga cikin ka'idodin gaskiya ne:

• Bayanai a cikin salula A2 ba kasa da 50 ba.
• Bayanai a cikin salula A3 ba daidai ba 75.