Kuyesera maulendo angapo kuti abwerere ZOONA kapena ZONSE zotsatira
Zomwe OR ndi ntchito OR zili ziwiri zomveka bwino zomwe zimagwira ntchito m'mabuku a Google . Amayesa kuti awone ngati zotsatira zochokera ku maselo awiri kapena angapo akugwirizanitsa zomwe mukuzifotokoza.
Ntchito izi zomveka zimangobweretsanso zotsatira imodzi (kapena zofunikira za Boolean ) mu selo zomwe zimagwiritsidwa ntchito, kaya ZOONA kapena ZOKHALA:
- Kwa Ntchito ndi Machitidwe , mawonekedwe m'maselo ambiri amayesedwa. Zokha ngati mauthenga onsewa ali oona, ntchitoyo idzabwezera yankho loona. Ngati ayi, ntchitoyo imabwerera FALSE ngati mtengo.
- Kwa OR ntchito , ngati imodzi mwa mayesero oyesedwa ndi oona, ndiye OR ntchito ikubwezerani yankho la WOONA. Zokha ngati mayesero onse sali owona OR angakupatseni mtengo WONSE mu selo yomwe ilipo.
Mayankho Owona Owona kapena OTHANDIZA a OR ndi ntchito akhoza kuwonetseredwa monga momwe zilili m'maselo omwe ntchitozo zili, kapena ntchito zingakhale zogwirizana ndi ntchito zina za Google Spreadsheet, monga ntchito ya IF , kusonyeza zotsatira zosiyanasiyana kapena kuti achite ziwerengero zingapo.
Momwe Ntchito Yogwirira Ntchito imagwirira ntchito mu Google Mapepala
Chithunzichi pamwamba, maselo B2 ndi B3 ali ndi OR ndi ntchito OR, motero. 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)
Zomwe amayesedwa ndi awa:
- Ngati deta yomwe ili mu selo A2 ndi yosakwana 50 ( < ndi chizindikiro chochepa)
- Ngati deta mu selo A3 siilifanana ndi 75 ( <> ndi chizindikiro chosafanana)
- Ngati deta yomwe ili mu selo A4 imaposa kapena ikufanana ndi 100 ( > = ndi chizindikiro choposa kapena chofanana)
Kwa AND function mu selo B2, deta m'maselo A2 mpaka A4 ayenera kufanana ndi zinthu zitatu zomwe zili pamwambapa kuti ntchito ibwezeretse yankho loona. 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 B3, chimodzi mwazimene zili pamwambazi ziyenera kukumana ndi deta m'maselo A2, A3, kapena A4 chifukwa cha ntchitoyo kubwezera yankho lenileni. Mu chitsanzo ichi, deta m'maselo A2 ndi A3 onsewa amakwaniritsa chikhalidwe chofunikira, kotero chiwerengero cha OR ntchito ndi chowonadi.
Syntax ndi Arguments kwa AND / OR Ntchito
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito ndi:
= NDI ( zomveka_zofotokozera1, zomveka_zofotokozera2, ... )
Chidule cha OR ntchito ndi:
= OR ( zomveka_zofotokozera1, zomveka_zofotokozera2, zomveka_zofotokozera3, ... )
- logical_expression1 [Chofunikira] limatanthauza chikhalidwe chomwe chikuyesedwa. Maonekedwe a chikhalidwechi nthawi zambiri amatanthauzira selo la deta poyang'aniridwa ndi chikhalidwe chomwecho, monga A2 <50.
- zomveka_zofotokozera2 , zomveka_zofotokozera3, ... [Zosankha] ndizo zina zomwe zingayesedwe.
Kulowa ndi NTCHITO
Zotsatira izi zikutsegula momwe mungalowerere ndi ntchito yomwe ili mu selo B2 mu chithunzi pamwambapa. Miyendo yomweyo ingagwiritsidwe ntchito kulowa mu OR ntchito yomwe ili mu selo B3.
Maofesi a Google samagwiritsa ntchito bokosi la dialogs kuti alowe mmaganizo monga momwe Excel imachitira. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.
- Dinani pa selo B2 kuti mupange selo yogwira ntchito ; Apa ndipamene ntchito ndi NTCHITO imalowa ndipo zotsatira za ntchitozo zidzawonetsedwa.
- Lembani chizindikiro chofanana ( = ) chotsatira ndi ntchito NDI .
- Pamene mukuyimira, bokosi lopangira okhalo likuwonekera ndi mayina a ntchito zomwe zimayamba ndi kalata A.
- Pamene ntchito NDIPO ikuwonekera m'bokosi, dinani pa dzina ndi ndondomeko ya mouse.
Kulowa Magulu a Ntchito
Zokambirana za NTCHITO ndi zolembedwera zimalowa pambuyo poyambira. Monga mu Excel, chiwerengero chimayikidwa pakati pa zokhudzana ndi ntchitoyo kuti azikhala olekanitsa.
- Dinani pa selo A2 patsiku la ntchito kuti mulowetse selo ili ngati ndondomeko_nxpression1 mtsutso.
- Lembani <50 pambuyo pa selolo la selo.
- Lembani comma mutatulutsira maselo kuti azikhala olekanitsa pakati pa zokhudzana ndi ntchito.
- Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selo ili monga ndondomeko_nxpression2.
- Lembani <> 75 pambuyo powerenga selo.
- Lembani kamphindi wachiwiri kuti mukhale wolekanitsa wina.
- Dinani pa selo A4 mu tsamba lothandizira kuti mulowetse selo lachitatu.
- Mtundu > = 100 pambuyo pa selo lachitatu.
- Lembani fungulo lolowani la Enter muikiramo kuti mulowetse zolemba zotsalira pambuyo pazitsutsano ndikukwaniritsa ntchitoyi.
Mtengo WABWINO uyenera kuwonekera mu selo B2 chifukwa deta yomwe ili mu selo A4 silingakumane ndi chikhalidwe choposa kapena chofanana ndi 100.
Mukasindikiza pa selo B2, ntchito yomaliza = NDI (A2 <50, A3 <> 75, A4> = 100) imapezeka muzenera zamatabwa pamwamba pa tsamba.
KODI M'malo mwa AND
Mapangidwe apamwamba angagwiritsidwe ntchito polowera OR ntchito yomwe ili mu selo B3 mu chithunzi cha worksheet pamwambapa.
Ntchito yomaliza OR idzakhala = OR (A2 <50, A3 <> 75, A4> = 100).
Phindu la choonadi liyenera kupezeka mu selo B3 chifukwa chimodzi mwazimene zikuyesedwa ziyenera kukhala zoona kwa OR ntchito kubwezera mtengo weniweni, ndipo mwachitsanzo ichi zinthu ziwiri ndizoona:
- Deta mu selo A2 ndi yosakwana 50.
- Deta yomwe ili mu selo A3 siilifanana ndi 75.