Yesani maulendo angapo ndi ntchito za Excel NDI AND ndi OR
Ntchito ndi OR ndi ntchito ziwiri zomwe zimadziwika bwino kwambiri , komanso zomwe ntchito ziwirizi zikuchita ndikuyesera kuti muone ngati zotsatira za maselo awiri kapena angapo akugwirizanitsa zomwe mukuzifotokoza.
ZOONA kapena ZONSE ZOKHALA
Chinthu chimodzi cha ntchitozi ndi chakuti iwo adzabweranso kapena kuwonetsa zotsatira imodzi kapena zofunikira za Boolean mu selo kumene zili: ZOONA kapena ZONSE.
- Kwa OR ntchito - mzere 2 pamwambapa - zikhalidwe zambiri zimayesedwa ndipo ngati chimodzi mwazoyesedwazo ndi zoona, ndiye OR ntchito imabweretsa yankho la WOONA. Zokha ngati zikhalidwe zonse siziri zoona OR angakupatseni mtengo WONSE;
- Kuchita ndi NTCHITO - mzere 3 pamwambapa - zochitika zambiri zimayesedwa ndipo kokha ngati zinthu zonse zili zoona ndiye kuti ntchitoyo ibwereranso kuyankha kwenizeni. Ngati ayi, ntchitoyo imabwerera FALSE ngati mtengo.
Kuphatikiza ndi Ntchito Zina
Mayankho owona kapena OTHANDIZA akhoza kuwonetsedwa monga momwe zilili mu maselo omwe ntchitozo zili. Ntchitoyi ikhonza kuphatikizidwa ndi ntchito zina za Excel - monga ntchito IF - m'mizere inayi ndi isanu pamwambapa kupereka zotsatira zosiyanasiyana kapena kuchita ziwerengero zingapo.
Momwe Ntchito Zimagwirira Ntchito
Mu chithunzi pamwambapa, maselo B2 ndi B3 ali ndi OR ndi ntchito OR motsatira. Onsewa amagwiritsa ntchito owerengera oyerekezera kuti ayese zinthu zosiyanasiyana kuti adziwe ma data A2, A3, ndi A4 a worksheet .
Ntchito ziwirizo ndi:
= NDI (A2 <50, A3 <> 75, A4> = 100)
= OR (A2 <50, A3 <> 75, A4> = 100)
Ndipo zikhalidwe zomwe amayesa ndi:
- ngati deta yomwe ili mu selo A2 ili pansi pa 50 ( < ndi chizindikiro chochepa),
- ngati deta yomwe ili mu selo A3 siilifanana ndi 75 ( <> ndi chizindikiro chosafanana),
- ngati chidziwitso chomwe chili mu selo A4 chiposa kapena chikufanana ndi 100 ( > = ndi chizindikiro chachikulu kapena chofanana).
NDIPONSO NDI ZOONA
Kwa AND ntchito mu selo B3, deta m'maselo (A2 mpaka A4) iyenera kufanana ndi zinthu zitatu zomwe zili pamwambapa kuti ntchitoyo ibwezeretsedwe.
Pamene zikuyimira, zigawo ziwiri zoyambirirazo zimakwaniritsidwa, koma popeza kulemera kwa selo A4 sikunene kapena kofanana ndi 100, zomwe zimatuluka ku ntchito ndi ZOYENERA.
Pankhani ya OR ntchito mu selo B2, chimodzi mwazimene zili pamwambazi ziyenera kukumana ndi deta m'maselo A2, A3, kapena A4 kuti ntchitoyo ibwerere kuyankha.
Mu chitsanzo ichi, deta m'maselo A2 ndi A3 onsewa amakwaniritsa chikhalidwe chofunikira kotero kuti chiwongolero cha OR ntchito ndi chowonadi.
NDI / OR Ntchito "Syntax ndi Arguments
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha OR ntchito ndi:
= OR (Logical1, Logical2, ... Logical255)
Chidule cha ntchito ndi:
= NDI (Logical1, Logical2, ... Logical255)
Logical1 - (yofunikira) imatanthawuza kuti chikhalidwe chikuyesedwa. Maonekedwe a chikhalidwechi nthawi zambiri amatanthauzira selo la deta poyang'aniridwa ndi chikhalidwe chomwecho, monga A2 <50.
Logical2, Logical3, ... Logical255 - (zosankha) zina zomwe zingayesedwe mpaka kufika pa 255.
Kulowa mu OR Function
Masitepe otsatirawa awonetse momwe mungalowerere OR ntchito yomwe ili mu selo B2 mu chithunzi pamwambapa. Masitepe omwewo angagwiritsidwe ntchito polowera ndi ntchito yomwe ili mu selo B3.
Ngakhale kuti n'zotheka kufalitsa mawonekedwe onse monga
= OR (A2 <50, A3 <> 75, A4> = 100)
mwapadera mu selo la ntchito, gawo lina ndilo kugwiritsa ntchito bokosi la zokambirana - monga momwe tafotokozera m'magulu otsatirawa - kulowa ntchito ndi zifukwa zake mu selo monga B2.
Ubwino wogwiritsira ntchito bokosilo ndikuti Excel imasamalira kulekanitsa mndandanda uliwonse ndi chiphatikizo ndipo imayambitsa zifukwa zonsezo.
Kutsegula bokosi la olozera la OR OR
- Dinani pa selo B2 kuti mupange selo yogwira ntchito - apa ndi pamene NTCHITO idzapezeka.
- Dinani pa Fomu tab ya riboni .
- Dinani pa chithunzi cha Logical kuti mutsegule ntchitoyi.
- Dinani OR mu mndandanda kuti mutsegule dialog box.
Deta yomwe idzalowetsedwe mndandanda wosalongosoka mu bokosi lazokambirana idzakhazikitsa mfundo za ntchitoyo.
Kulowa Mndandanda wa OR Function
- Dinani pa Logical1 mzere wa bokosi la bokosi.
- Dinani pa selo A2 mu tsamba lothandizira kuti mulowetse selo ili.
- Lembani <50 pambuyo pa selolo la selo.
- Dinani pa Logical2 mzere wa bokosi la bokosi.
- Dinani pa selo A3 mu ofesi yolemba kuti mulowetse selo yachiwiri.
- Lembani < > 75 pambuyo powerenga selo.
- Dinani pa Logical3 mzere wa bokosi la bokosi.
- Dinani pa selo A4 mu spreadsheet kuti mulowetse selo lachitatu.
- Mtundu > = 100 mutatha kufotokoza maselo.
- Dinani OK kuti mukwaniritse ntchitoyi ndi kubwerera kuntchito.
- Phindu lenileni liyenera kuoneka mu selo B2 chifukwa deta yomwe ili mu selo A3 imakhala ndi vuto losafanana ndi 75.
- Mukasindikiza pa selo B2, ntchito yomaliza = OR (A2 <50, A3 <> 75, A4> = 100) imapezeka muzenera zamatabwa pamwamba pa tsamba.
NDI mmalo mwa OR
Monga tanenera, masitepewa angagwiritsidwenso ntchito polowera NDI NTCHITO yomwe ili mu selo B3 mu chithunzi cha worksheet pamwambapa.
Zomaliza ndi ntchito zidzakhala: = NDI (A2 <50, A3 <> 75, A4> = 100) .
Phindu la FALSE liyenera kupezeka mu selo B3 chifukwa chimodzi mwa zifukwa zomwe zikuyesedwa ziyenera kukhala zabodza kwa ENA ndi kubwezeretsa mtengo WABWINO ndipo mu chitsanzo ichi zikhalidwe ziwiri ndi zabodza:
- Deta mu selo A2 si yosachepera 50;
- Deta yomwe ili mu selo A4 si yayikulu kapena ikufanana ndi 100.