Indlela yokusebenzisa i-AND AND OR OK Imisebenzi engqalileyo kwi-Google AmaSpredishithi

Ukuvavanya iimeko ezininzi ukubuyela kwi-TRUE okanye iziphumo zeFALSE

I-OR kunye ne-OR imisebenzi yimiba emibini yemisebenzi engqiqweni eyaziwayo kwi- Google AmaSpredishithi . Bavavanya ukuba babone ukuba imveliso evela kumaseli amabini okanye athile ekujoliswe kuyo ihlangabezana nezimo ozichazayo.

Le mi sebenzi enengqiqo iya kubuyisa kuphela enye yeziphumo ezimbini (okanye ixabiso leBoolean ) kwiseli apho zisetyenzisiweyo, nokuba yiQINISO okanye FALSE:

• KUNYE NOMSEBENZI , iifomula kwiiseli ezininzi ziyavavanywa. Kuphela ukuba zonke ezi zifomula ziyinyaniso, umsebenzi uya kubuya impendulo ye-TRUE. Ukuba akunjalo, umsebenzi ubuyisela iFALSE njengexabiso.
• Ukuba umsebenzi we-OR , ukuba nayiphi na iifomula ezivivinywayo ziyinyani, ngoko umsebenzi we-OR ubuyisela impendulo ye-TRUE. Kuphela ukuba zonke iifomula aziyiyo inyaniso okanye OKUYA kukunika inani le-FALSE kwiseli apho ikhona khona.

Izimpendulo ze-TRUE okanye ze-FALSE kwimisebenzi ye-AND ne-OR ingabonakaliswa njengoko kusetsini apho imisebenzi ikhona khona, okanye imisebenzi inokudibaniswa neminye imisebenzi ye-Google Spreadsheet, njengomsebenzi we- IF , ukubonisa iintlobo ezahlukeneyo zeziphumo okanye ukufeza inani lokubala.

Indlela Imisebenzi Yengqondo Esebenzayo kwi-Google AmaSpredishithi

Umfanekiso ongentla, iiseli B2 kunye neB3 ziqukethe umsebenzi we-NA kunye ne-OR, ngokulandelanayo. Bobabini basebenzise inani labasebenzisi bokuqhathanisa ukuvavanya iimeko ezahlukeneyo zeedatha kwiiseli A2, A3, kunye ne-A4 kwiphepha lokusebenzela .

Le mibini mi sebenzi:

= NO (A2 <50, A3 <> 75, A4> = 100)

= OKANYE (A2 <50, A3 <> 75, A4> = 100)

Imiqathango abavavanya ngayo:

• Ukuba idatha kwiseli ye-A2 ingaphantsi kwama- 50 ( < iyisimboli esingaphantsi kwe)
• Ukuba idatha kwiseli A3 ayilingana no- 75 ( << iyisimboli yokungalingani)
• Ukuba idatha kwiseli ye-A4 ingaphezulu okanye ilingana no- 100 ( > = iyisimboli esikhulu kunaleyo okanye elinganayo)

KOMSEBENZI WOMSEBENZI kwiseli yeB2, idatha kwiiseli A2 ukuya kwi-A4 kufuneka ihambisane nayo yonke imiqathango emithathu apha ngasentla ukuze umsebenzi ubuyisele impendulo ye-TRUE. Njengoko limi, iimeko ezimbini zokuqala zidibene, kodwa ekubeni ixabiso kwi-cell A4 alimkhulu kunokuba lilingana no-100, umphumo we-AND umsebenzi u-FALSE.

Kwimeko ye-OR umsebenzi kwiseli B3, kuphela enye yeemeko ezingentla apha kufuneka idibane nedatha kwiiseli A2, A3, okanye i-A4 yomsebenzi ukubuyisela impendulo yangempela. Kulo mzekelo, idatha kwiiseli ze-A2 kunye ne-A3 zombini zidibana nemeko efunekayo, ngoko umphumo we-OR umsebenzi uYIQINISO.

I-Syntax kunye neengxoxo ze-AND / OK Imisebenzi

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax ye-AND function is:

= NAKWENKQUBO ( ngokucacileyo_kunyanzeliso1, okucacileyo_kuchazwa2, ... )

I-syntax yomsebenzi we-OR yile:

= OK ( ingqiqo_yentetho1, ingqiqo_yentetho2, ingqiqo_iyichazi3, ... )

• ngqiqo_ncoko1 [Ifunekayo] ibhekisela kwimeko evavanywayo. Ifom yesiko ngokuqhelekileyo isalathisi yeselfowuni ehlolwe ilandelwe yimeko ngokwalo, njenge-A2 <50.
• ngqiqo_ncoko2 , uqikelelo_ncoko3, ... [Optional] ziimeko ezongezelelweyo ezinokuhlolwa .

Ukungena kunye NOMSEBENZI

Amanyathelo alandelayo afaka indlela yokufaka umsebenzi WOMSEBENZI osefayilini B2 kumfanekiso ongentla. Amanyathelo afanayo angasetyenziselwa ukungena kwi-OR umsebenzi okhoyo kwiseli B3.

AmaSpredishithi eGoogle ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi ngendlela i-Excel eyenzayo. Endaweni yoko, inebhokisi ephakanyiswa yi-auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwifowuni B2 ukwenza iseli esebenzayo ; le yilapho umsebenzi WOMNYE ungeniswe kwaye apho umphumo walo msebenzi uza kuboniswa khona.
2. Thayipha uphawu olulinganayo ( = ) olulandelwe ngu- AND AND .
3. Njengoko uthayipha, ibhokisi ye-auto-suggestion ibonakala ngamagama emisebenzi eqala ngeleta A.
4. Xa umsebenzi kunye NOKUvela kwibhokisi, nqakraza kwigama kunye ne-mouse pointer.

Ukungena kwiSigqibo seMisebenzi

Iingxoxo zomsebenzi we-NA zifakwe emva kohlobo lwabazali. Njengoko ku-Excel, i-comma ifakwe phakathi kweengxoxo zomsebenzi ukwenza njengomhluli.

1. Cofa kwiseli A2 kwiphepha lokusebenzela ukuze ufake le ferensi yeseli njengengqiqo_expression1 ingxabano.
2. Thayipha <50 emva kokusetyenziswa kweeseli.
3. Thayipha i- comma emva kokuba iselferensi yeselenzana isebenze njengohluli phakathi kweengxoxo zomsebenzi.
4. Cofa kwifowuni A3 kwiphepha lokusebenzela ukuze ufake le ferensi yeseli njengengqiqo_expression2 ingxabano.
5. Thayipha <> 75 emva kokubhekisele kweseli.
6. Thayipha i- comma yesibini ukwenza njengomnye umhluli.
7. Cofa kwiseli A4 kwiphepha lokusebenzela ukuze ufake ifowuni yesithathu.
8. Uhlobo > = 100 emva kwereferensi yeselula yesithathu.
9. Cinezela ukhiye wokungena kwibhodibhodi ukungena kubazali bokuvala emva kweengxoxo kunye nokugqiba umsebenzi.

Ixabiso le-FALSE kufuneka livele kwiseli yeB2 kuba idatha kwi-A4 yeseli ayifumananga nemeko enkulu kunaleyo okanye ilingana no-100.

Xa ucofa kwi-cell B2, umsebenzi opheleleyo = NO (A2 <50, A3 <> 75, A4> = 100) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

OKANYE endaweni yeNYE

Amanyathelo angentla angasetyenziselwa ukungena kwi-OR umsebenzi okhoyo kwiseli B3 kwisithombe somsebenzi apha ngasentla.

I-OR epheleleyo igqityiweyo iya kuba = OK (A2 <50, A3 <> 75, A4> = 100).

Ixabiso le-TRUE kufuneka libe khona kwiseli yeB3 kuba enye yeemeko ezivivinywayo kufuneka iyenze inyaniso kwi-OR umsebenzi ukuba ubuyisele ixabiso le-TRUE, kwaye kule mzekelo mibini yeemeko ziyinyaniso:

• Idatha kwiseli ye-A2 ingaphantsi kwama-50.
• Idatha kwiseli ye-A3 ayilingani 75.