Imisebenzi ye-Excel no-OR

Hlola izimo eziningi nge-Excel ka-AND ne-OR imisebenzi

I-AND ne-OR imisebenzi yimibili yemisebenzi eqondakalayo engcono kakhulu eyaziwayo ye-Excel, nokuthi yimuphi lo misebenzi emibili ukuhlola ukuhlola ukuthi ngabe ukukhishwa kwamaseli amabili noma ngaphezulu okubhekene nakho kuhlangabezana nezimo ozikhombayo.

IQINISO noma FALSE KUPHELA

Esinye sici salomsebenzi ukuthi bazobuya kuphela noma babonise omunye wemiphumela emibili noma amanani we-Boolean esitokisini lapho atholakala khona: TRUE noma FALSE.

Ukuhlanganisa nezinye imisebenzi

Lezi zimpendulo ze-TRUE noma ze-FALSE zingaboniswa njengama-cell lapho imisebenzi ikhona khona. Imisebenzi ingabuye ihlanganiswe neminye imisebenzi ye-Excel - njengomsebenzi we-IF - ngemigqa emine nangesihlanu ngenhla ukunikeza imiphumela ehlukahlukene noma ukwenza izibalo eziningi.

Yeka ukuthi Imisebenzi isebenza kanjani

Esithombeni ngenhla, amaseli B2 no-B3 aqukethe umsebenzi we-AND no-OR ngokulandelanayo. 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)

Futhi izimo abavivinywa ngazo:

KANYE NOKUTHUTHA NOMA OKUQHELEKILE

Ku-AND ANDROID ngeselula B3, idatha kumaseli (A2 kuya ku-A4) kufanele ihambisane nayo yonke imibandela emithathu 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 B2, 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 ukuze umkhiqizo we-OR umsebenzi uqiniswe.

NOMA / OR Imisebenzi 'i-Syntax ne-Arguments

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

I-syntax yomsebenzi we-OR yilezi:

= OR (i-Logical1, i-Logical2, ... i-Logical255)

I-syntax yomsebenzi we-AND:

= NO (i-Logical1, i-Logical2, ... i-Logical255)

I-Logical1 - (edingekayo) ibhekisela esimweni esihlolwe . Ifomu lesimo ngokuvamile kuvame ukubhekwa kweseli kwedatha ehlolwayo kulandelwa isimo ngokwayo, njenge-A2 <50.

I-Logical2, i-Logical3, ... I-Logical255 - (ngokuzikhethela) izimo ezingeziwe ezingahlolwa ifike ku-255.

Ukufaka i-OR Umsebenzi

Izinyathelo ezingezansi zihlanganisa ukuthi ungangena kanjani umsebenzi we-OR osesithombeni B2 esithombeni ngenhla. Izinyathelo ezifanayo zingasetshenziswa ukungena ku-AND function esesitokisini B3.

Nakuba kungenzeka ukuthayipha yonke ifomula njenge

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

ngokuzenzekelayo ube yiseli lokusebenzela, enye indlela ukusebenzisa ibhokisi lengxoxo yomsebenzi - njengoba kuchazwe ezinyathelweni ezingezansi - ukufaka umsebenzi kanye nezimpikiswano zalo esitokisini njenge-B2.

Izinzuzo zokusebenzisa ibhokisi lebhokisi liwukuthi i-Excel iyakhathalela ukuhlukanisa izingxabano ngasinye nge-comma futhi ihlanganisa zonke izimpikiswano kubangani.

Ukuvula ibhokisi le-OR function Dialog

  1. Chofoza ku-cell B2 ukuze wenze iseli elisebenzayo - yilapho umsebenzi we-ANDRO uzobe khona.
  2. Chofoza kuthebhu yefomathi yebhande .
  3. Chofoza ku-icon yeLogical ukuvula uhlu lwehla lokusebenza.
  4. Chofoza ku- OR ohlwini ukuze uvule ibhokisi lengxoxo lomsebenzi.

Idatha ezofakwa emigqeni engenalutho ebhokisini lebhokisi izokwenza izingqinamba zomsebenzi.

Ukufaka iziphakamiso ze-OR Function

  1. Chofoza ku- Logical1 line yebhokisi lengxoxo.
  2. Chofoza ku-cell A2 kusikripthi sokusebenza ukuze ufake leli referensi yeseli.
  3. Thayipha <50 ngemuva kokubhekisela kweseli.
  4. Chofoza ku- Logical2 line yebhokisi lengxoxo.
  5. Chofoza kuseli le-A3 kusikripthi sokufaka isicelo sokufaka ireferensi yeseli yesibini.
  6. Thayipha < > 75 ngemuva kokubhekisela kweseli.
  7. Chofoza ku- Logical3 line yebhokisi lengxoxo.
  8. Chofoza kuseli elingu-A4 kuspredishithi ukuze ufake isithenjwa sesitfombe sesithathu.
  9. Thayipha > = 100 ngemuva kokubhekisela kweseli.
  10. Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela.
  11. Inani le- TRUE kufanele livele esitokisini B2 ngoba idatha e-cell A3 ihlangabezana nesimo sokungalingani no-75.
  12. Uma uchofoza ku-cell B2, umsebenzi ophelele = OR (A2 <50, A3 <> 75, A4> = 100) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.

Futhi esikhundleni se-OR

Njengoba kukhonjisiwe, izinyathelo ezingenhla zingasetshenziselwa ukungena ku-AND function esesitokisini B3 esithombeni somshicileli ngenhla.

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

Inani le- FALSE kufanele libe khona esitokisini B3 ngoba kuphela eyodwa yezimo ezivivinywayo ezidingekayo ukuba zikhohlise umsebenzi we-NA ukubuyisela inani le-FALSE futhi kulezi zimo ezimbili zezimo zingamanga: