Edzai mitemo yakawanda neExcel AND AND nemabasa
Izvo uye OR zvinoshanda mabasa maviri eExcel anozivikanwa anonyatsozivikanwe, uye izvo zvinoshanda izvi zviviri ndeyekuedza kuona kana zvakabuda kubva kune maviri kana kupfuura mamwe masero anosangana nemamiriro aunofunga.
IYE CHOKWADI kana IYE CHOKWADI
Chimwe chezvinhu izvi ndezvekuti vachadzoka chete kana kuratidza chimwe chezvibereko zviviri kana maBoolean maitiro muchitokisi kwavanenge vari: TRUE kana FALSE.
- Nokuda kweO OR basa - mutsara 2 pamusoro - mamiriro ezvinhu mazhinji anoedzwa uye kana chimwe chezvinhu zvakaedzwa chiri chechokwadi, saka OR basa rinodzorera mhinduro ye TRUE. Chero kana mamiriro ezvinhu ose asiri echokwadi kana OR kukupa kukosha kweFALSE;
- Nokuda kweChina uye Kushanda - mutsara 3 pamusoro - mamiriro ezvinhu mazhinji anoongororwa uye chete kana zvose zviitiko zviri zvechokwadi basa racho rinodzoka mhinduro dzechokwadi. Kana zvisina kudaro, basa rinodzoka FALSE sechikosha.
Kubatana neMamwe Mabasa
Aya aya echokwadi kana eFALSE anokwanisa kuratidzirwa sezviri mumasero ayo mabasa aripo. Mabasa acho anogonawo kuiswa pamwe nemamwe mabasa eEexcel - akadai seAIF basa - mumitsara mana neyishanu pamusoro apa kupa mhando dzakaguma kana kuita zviverengero zvakawanda.
Maitiro Ekuti Mabasa Anoshanda Sei
Mumufananidzo uri pamusoro, masero B2 neB3 ane A AND uye OR basa maererano. Zvose izvi zvinoshandisa nhamba dzinoverengeka dzekuenzanisa kuti zviongorore zvakasiyana-siyana zvemashoko e data mumasero A2, A3, uye A4 emushandi webasa.
Mabasa maviri aya ndeokuti:
= Uye (A2 <50, A3 <> 75, A4> = 100)
= OR (A2 <50, A3 <> 75, A4> = 100)
Uye mamiriro avo anoedza ndeaya:
- kana data iri muchitokisi A2 isingapfuuri 50 ( < ndiyo chiratidzo chepasi)
- kana data iri muchitokisi A3 isinganzwisisi na 75 ( <> ndiyo chiratidzo chekusaenzana),
- kana data iri muchitokisi A4 yakakura kudarika kana yakaenzana ne100 ( > = ndiyo chiratidzo chikuru kune kana chakaenzana).
NOKUDZIDZA KANA KUTI IYE CHOKWADI
Nokuda uye kushanda muchitokisi B3, data iri mumasero (A2 kusvika kuA4) inofanira kufanana nezvose zvitatu zviri pamusoro apa kuti basa ridzorere mhinduro ye TRUE.
Sezvazvinomira, mamiriro maviri ekutanga anosangana, asi sezvo kukosha muchitokisi A4 hakuna chikuru kune kana kuti chakaenzana ne100, zvakakonzerwa neA AND function ndeye FALSE.
Muchiitiko cheO OR basa muchitokisi B2, imwe chete yemamiriro ezvinhu pamusoro apa inofanira kusangana nemashoko ari mumasero A2, A3, kana A4 kuitira basa kudzorera mhinduro ye TRUE.
Mumuenzaniso uyu, deta iri mumasero A2 neA3 mbiri inosangana nemamiriro ezvinhu anoda kuitira kuti chibereko cheA OR basa chiri CHOKWADI.
Uye / OR Mabasa 'Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara weO OR basa ndewokuti:
= OR (Logical1, Logical2, ... Logical255)
Mutsara weA AND work is:
= Uye (Logical1, Logical2, ... Logical255)
Logical1 - (inoda) inoreva mamiriro ezvinhu ari kuedzwa. Chimiro chechiitiko chacho chinowanzowanzo sero ye data iri kuongororwa inoteverwa nemamiriro acho pachayo, akadai seA2 <50.
Logical2, Logical3, ... Logical255 - (zvichida) mamwe mamiriro ezvinhu anogona kuongororwa kusvika ku 255.
Kupinda muO OR Function
Matanho ari pasi apa anowanikwa sei muO OR basa iri muchitokisi B2 mumufananidzo uri pamusoro. Matanho mamwechete anogona kushandiswa pakupinda muAIT uye basa riri muchitokisi B3.
Kunyange zvazvo zvichikwanisika kunyora zvose zvakasarudzwa zvakadai se
= OR (A2 <50, A3 <> 75, A4> = 100)
zvinyorwa mumasero ekushanda, rimwe sarudzo nderokushandisa sarudzo yebhokisi rebasa - sezvinotsanangurwa mumatanho ari pasi - kuisa basa uye nharo dzayo muchitokisi chakadai seB2.
Kubatsirwa kwekushandisa iyo bhokisi rebhokisi ndeyekuti Excel inotarisira kuparadzanisa mhiriro imwe neimwe nekomma uye inovhara nharo dzose mumhuri.
Kuzarura OR OR Dialog Box
- Dzvanya pachitokisi B2 kuti uite sero rinoshandiswa - iyi ndiyo iyo MUMWE uye basa richawanikwa.
- Dzvanya paMafomu tab yebhoni .
- Dzvanya pa Logical icon kuti uzarure basa rinoyerera pasi.
- Dzvanya pa OR kana kuti pane urongwa kuti uzarure bhokisi rebasa rebasa.
Dhesi iyo ichapindirwa mumitsetse isina chinhu mubhokisi yebhokisi ichaita maitiro ebasa.
Kupinda muO OR Function Arguments
- Dzvanya pa Logical1 mutsara webhokisi rebhokisi.
- Dzvanya pachitokisi A2 mune pepa rekushanda kuti uise iyi seferensi yekero.
- Tora <50 mushure mekufungidzira.
- Dzvanya pa Logical2 mutsara webhokisi rebhokisi.
- Dzvanya pane sero A3 mune pepa rekushanda kuti uise yechipiri cheseferensi.
- Tora < > 75 mushure mekufungidzirwa kwesero.
- Dzvanya pa Logical3 mutsara webhokisi rebhokisi.
- Dzvanya pachitokisi A4 mune pepadheetti kuti uise chechitatu chechitsetse.
- Ropa > = 100 mushure mekufona kwesero.
- Dzvanya OK kuti upedze basa uye dzokera kushizha rekushanda.
- Kukosha TRUE kunofanira kuonekwa muchitokisi B2 nokuti data iri muchitokisi A3 inosangana nemamiriro ezvinhu ekusaenzana ne75.
- Paunenge uchitarira pane cell B2, basa rakakwana = OR (A2 <50, A3 <> 75, A4> = 100) rinowanikwa mubhadha yepamusoro pane pepa rekushanda.
Uye panzvimbo ye OR
Sezvakataurwa, matanho ari kumusoro anogonawo kushandiswa kupinda muAIT uye iri muchitokisi B3 mune peji yepaji yepamusoro pepamusoro.
Iyo yakapedzwa uye basa raizova: = NA (A2 <50, A3 <> 75, A4> = 100) .
Chinokosha cheFALSE chinofanira kunge chiripo muchitokisi B3 sezvo iyo imwe chete yemamiriro ezvinhu ari kuedzwa inofanira kunge inhema nokuda kweA AND function kudzorera kukosha kweFALSE uye mumuenzaniso uyu mbiri yemamiriro acho ndeechokwadi:
- iyo data muchitokisi A2 haisi pasi pe50;
- iyo data iri muchitokisi A4 haisi mukuru kudarika kana yakaenzana ne100.