Indlela yokusebenzisa i-AND AND no-OR Imisebenzi eqoshiwe kuma-Google AmaSpredishithi

Ihlola izimo eziningi ukubuyisa i-TRUE noma imiphumela ye-FALSE

I-AND no-OR imisebenzi yimisebenzi emibili engcono kakhulu eyaziwayo kumaSpredishithi e- Google . Bahlola ukuze babone ukuthi ukukhishwa kwamaseli amabili noma ngaphezulu okubhekene nawo kuhlangana nezimo ozibekayo.

Le miisebenzi enengqondo izobuyisela kuphela imiphumela emibili (noma ama-boolean amanani ) esitokisini lapho asetshenziselwa khona, kungaba yi-TRUE noma FALSE:

• Nge-AND AND Function , amafomula kumaseli amaningi ahlolwe. Kuphela uma zonke lezi fomula ziyiqiniso ngeke umsebenzi ubuyele impendulo ye-TRUE. Uma kungenjalo, lo msebenzi ubuyisela i-FALSE njengenani.
• Ngomsebenzi we-OR , uma omunye wefomula evivinywa kuyiqiniso, khona-ke umsebenzi we-OR ubuyisa impendulo ye-TRUE. Kuphela uma wonke amafomula engekho iqiniso noma OR akunike inani le-FALSE esitokisini lapho itholakala khona.

Lezi zimpendulo ze-TRUE noma ze-FALSE ze-AND AND imisebenzi ye-OR zingaboniswa njengama-cell lapho imisebenzi ikhona khona, noma imisebenzi ingahlanganiswa neminye imisebenzi ye-Google Spreadsheet, efana nomsebenzi we- IF , ukubonisa imiphumela ehlukahlukene noma ukwenza izibalo eziningana.

Yeka ukuthi Imisebenzi Engokomzwelo isebenza kanjani kumaSpredishithi e-Google

Isithombe esingenhla, amaseli B2 no-B3 aqukethe umsebenzi we-AND no-OR ngokulandelana. Bobabili basebenzisa inombolo yokuqhathanisa opharetha ukuhlola izimo ezihlukahlukene zedatha kumaseli A2, A3, ne-A4 wephepha lokusebenzela .

Imisebenzi emibili yilezi:

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

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

Izimo abavivinywa ngazo:

• Uma idatha engqamuzaneni le-A2 ingaphansi kuka- 50 ( < uphawu oluphansi kunalokhu)
• Uma idatha engqamuzaneni le-A3 lingalingani no- 75 ( <> uphawu lokungalingani)
• Uma idatha engqamuzaneni le-A4 likhulu kunaleyo noma lilingana no- 100 ( > = liwuphawu olukhulu kunale noma elilinganayo)

Ku-AND ANDROID esebenzelana ne-cell B2, idatha kumaseli A2 kuya ku-A4 kufanele ihambisane nazo zonke izimo ezintathu ngenhla ukuze umsebenzi ubuyele impendulo ye-TRUE. Uma imile, izimo ezimbili zokuqala zihlangene, kodwa njengoba inani eliseli cell A4 alikhulu kunalokhu noma lilingana no-100, umkhiqizo we-AND AND umsebenzi uFALSE.

Endabeni yomsebenzi we-OR esitokisini B3, eyodwa kuphela yezimo ezingenhla kufanele ihlangabezane nedatha kumaseli A2, A3, noma A4 ukuze umsebenzi ubuyele impendulo ye-TRUE. Kulesi sibonelo, idatha kumaseli A2 no-A3 bobabili bahlangabezana nesimo esidingekayo, ngakho ukukhishwa komsebenzi we-OR kuyiqiniso.

I-Syntax ne-Arguments ye-AND / OR Imisebenzi

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-AND:

= KANYE ( okuqondakalayo_kuzichazayo1, okunengqondo_kuveza2, ... )

I-syntax yomsebenzi we-OR yilezi:

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

• okuqondakalayo_kucindezela1 [Okudingekayo] kubhekisela esimweni esihlolwe. Ifomu lesimo ngokuvamile kuvame ukubhekwa kweseli kwedatha ehlolwayo kulandelwa isimo ngokwayo, njenge-A2 <50.
• okuqondakalayo_kucindezela2 , okuqondakalayo_ukuziveza3, ... [Okokukhetha] yizimo ezengeziwe ezingatholakala.

Ukufaka umsebenzi no-ANDROID

Izinyathelo ezilandelayo zimboza ukuthi ungangena kanjani umsebenzi we-ANDI osefayilini B2 esithombeni ngenhla. Izinyathelo ezifanayo zingasetshenziselwa ukungena ku-OR umsebenzi osefebeni B3.

I-Google AmaSpredishithi ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi ngendlela i-Excel eyenza ngayo. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

1. Chofoza kuseli B2 ukuze wenze iseli elisebenzayo ; yilapho umsebenzi we-AND wangena futhi lapho imiphumela yomsebenzi izoboniswa khona.
2. Thayipha uphawu olulinganayo ( = ) olulandelwe umsebenzi no-AND .
3. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngencwadi A.
4. Uma umsebenzi u-AND uvela ebhokisini, chofoza igama nge-mouse pointer.

Ukufaka iziphakamiso zomsebenzi

Iziphakamiso ze-AND AND umsebenzi zifakwe ngemuva kwe-parenthesis evuliwe. Njengoba ku-Excel, i-comma ifakwa phakathi kwezingqinamba zomsebenzi wokusebenza njengomhlukanisi.

1. Chofoza ku- cell A2 kushidi lokusebenzela ukuze ufake le nkomba ye-cell njenge-argument logical_expression1 .
2. Thayipha <50 ngemuva kokubhekisela kweseli.
3. Thayipha i- comma ngemuva kokubhekisela kweseli ukwenza njengecalazi phakathi kwezingxoxo zomsebenzi.
4. Chofoza kuseli le- A3 kusikripthi sokusebenza ukuze ufake lokhu kusetshenziselwa iseli njengengxabano ye- logical_expression2 .
5. Thayipha <> 75 ngemuva kokubhekisela kweseli.
6. Thayipha i- comma yesibili ukwenza njengenye ihlukanisi.
7. Chofoza ku-cell A4 kushidi lokufaka ukuze ufaka isithenjwa sesithathu.
8. Thayipha > = 100 ngemuva kokubhekiselwe kwesitfombe sesithathu.
9. Cindezela ukhiye we- Enter ekhibhodi ukuze ufake ama-parenthesis wokuvala ngemva kokuphikisana nokuqedela umsebenzi.

Inani le-FALSE kufanele livele esitokisini B2 ngoba idatha eselifayilini le-A4 ayihlangabezani nesimo sokukhulu kunazo zonke noma esilingana no-100.

Uma uchofoza ku-cell B2, umsebenzi ophelele = NO (A2 <50, A3 <> 75, A4> = 100) uvela ebhafini yefomula ngaphezulu kwephepha lokusebenzela.

NOMA esikhundleni se-AND

Izinyathelo ezingenhla zingase zisetshenziselwe ukungena ku-OR function esesitokisini B3 esithombeni somshicileli ngenhla.

Umsebenzi ophelile OR uzoba = OR (A2 <50, A3 <> 75, A4> = 100).

Inani le-TRUE kufanele libe khona esitokisini B3 ngoba eyodwa yemibandela evivinywa idinga ukuba yiqiniso kumsebenzi we-OR ukubuyisela inani le-TRUE, futhi kulesi sibonelo ezimbili zezimo ziyiqiniso:

• Imininingwane yedatha ye-A2 ingaphansi kuka-50.
• Imininingwane yedatha ye-A3 ayilingani 75.