Mashandisiro Aungaita IYE uye NEMO Mabasa Anogadzirisa muGoogle Sheets

Kuedza mamiriro ezvinhu akawanda kudzoka TRUE kana kuti FALSE migumisiro

Izvo uye OR zvinoshanda zviviri zvezvinonyatsozivikanwa zvinonzwisisika zvinoshanda mumaGoogle Sheets . Vanoedza kuti vaone kana kubuda kwemashure maviri kana kupfuura kwemashoko kunosangana nemamiriro aunofunga.

Izvi zvinoshanda zvine musoro zvinongodzorera chimwe chezvikamu zviviri (kana kuti maBoolean maitiro ) muchitokisi iyo yavanoshandiswa, zvichida ECHOKWADI kana FALSE:

• Nokuda kweIYO uye Kushanda , mazano mumatare akawanda akaedzwa. Chero kana zvose izvi zvinyorwa zvokwadi ichaita basa kudzoka mhinduro dzechokwadi. Kana zvisina kudaro, basa rinodzoka FALSE sechikosha.
• Nokuda kweOO basa , kana chimwe chezvinyorwa zvakaedzwa chiri chokwadi, ipapo OR basa rinodzorera mhinduro ye TRUE. Chero kana maitiro ose asiri echokwadi kana OR kukupa kukosha kweFALSE mune sero iyo iripo.

Aya aya echokwadi kana eFALSE yeA AND uye OR mabasa anokwanisa kuratidzirwa sezviri mumasero ayo mabasa aripo, kana mabasa angave akabatanidzwa nemamwe mabasa eGoogle Spreadsheet, akadai seA IF function , kuratidza mhinduro dzakasiyana kana kuti aite zvishoma kuverenga.

Maitiro Ayo Manyolo Anoshanda Sei muGoogle Sheets

Mufananidzo uri pamusoro, masero B2 uye B3 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)

Mamiriro ezvinhu anoedza ndeaya:

• Kana data iri muchitokisi A2 iri pasi pe50 ( < ndiyo chiratidzo chepasi)
• Kana data iri muchitokisi A3 isinganzwisisi na 75 ( <> ndiyo chiratidzo chekusaenzana ne)
• Kana iyo data iri muchitokisi A4 yakakura kudarika kana yakaenzana ne100 ( > = ndiyo chiratidzo chikuru kune kana chakaenzana)

Nokuda uye kushanda muchitokisi B2, data iri mumasero A2 kusvika kuA4 inofanira kufanana nezvose zvitatu zviri pamusoro apa kuti basa ridzokere 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 B3, chete 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 aidiwa, saka zvakabuda kune OR kana basa ndezvechokwadi.

Syntax uye Arguments for AND / OR Mabasa

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weA AND work is:

= Uye ( zvinonzwisisika-zvinyorwa1, zvinonzwisisika_zvinyorwa2, ... )

Mutsara weO OR basa ndewokuti:

= HERE ( inonzwisisika_ixpression1, inonzwisisika_ixpression2, inonzwisisika_ixpression3, ... )

• chinonzwisisika_expression1 [Inodikanwa] chinoreva chiitiko chiri kuedzwa. Chimiro chechiitiko chacho chinowanzowanzo sero ye data iri kuongororwa inoteverwa nemamiriro acho pachayo, akadai seA2 <50.
• zvinonzwisisika_zvinyorwa2 , zvinonzwisisika_ixpression3, ... [Zvichida] ndezvimwe zvinogona kuongororwa.

Kupinda IN AND Function

Aya matanho anotevera anovhara kuti ungapinda sei NOMUSORO uri muchitokisi B2 mumufananidzo uri pamusoro. Matanho mamwechete anogona kushandiswa kupinda muO OR basa iri muchitokisi B3.

MaSpredishiti eGoogle haashandisi dialog boxes kuti apinde nharo dzemabasa nenzira iyo Excel inoita nayo. Pane kudaro, ine bhaji-yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.

1. Dzvanya pachitokisi B2 kuti uite sero rinoshanda ; iyi ndiyo iyo IYA uye basa rakapinda uye apo chiitiko chebasa chicharatidzwa.
2. Tora chiyero chakaenzana ( = ) chinotevera neA AND .
3. Sezvaunonyora, bhokisi re-auto-rinowanika rine mazita emabasa anotanga netsamba A.
4. Apo basa racho rinowanikwa mubhokisi, tanga pazita nezita rinokura.

Kupinda Maitiro Akashanda

Nharo dzeA AND function dzakapinda mushure mekuberekwa kwevana. Sezvakaitwa muEexcel, nhamba inowanikwa pakati pebasa rebasa kuita separadziri.

1. Dzvanya pachitokisi A2 mune pepa rekushanda kuti uite ino seferensi seyerigical_expression1 argument.
2. Tora <50 mushure mekufungidzira.
3. Tora comma mushure mekutsanangurwa kwesero yekuita separarator pakati pemashoko ekushanda.
4. Dzvanya pane sero A3 mune pepa rekushanda kuti uise ino rekero seyeri_nxpression2 argument.
5. Tora <> 75 mushure mekufungidzirwa kwesero.
6. Nyora yechipiri comma kuti uite seumwe separator.
7. Dzvanya pane sero A4 mune pepa rekushandisa kuti uise chetatu chetereferensi.
8. Ropa > = 100 mushure mechitatu chechitanhatu.
9. Dhinda pikicha inopinda mubhobhoyo kuti uise maherese ekuvhara mushure mokupikisana uye kupedza basa.

Ikoshi FALSE inofanira kuonekwa muchitokisi B2 nokuti data iri muchitokisi A4 haina kukwanisa mamiriro ekuva mukuru kana kuti akaenzana ne100.

Paunenge uchinge uri pane cell B2, basa rakakwana = AND (A2 <50, A3 <> 75, A4> = 100) rinowanikwa mubhadha yepamusoro pane pepa rekushanda.

KANA panzvimbo ye AND

Nhanho dziri kumusoro dzinogona kushandiswawo kupinda muO OR basa riri muchitokisi B3 mufananidzo webasa riri pamusoro.

Iyo yakapedzwa OR basa yaizova = OR (A2 <50, A3 <> 75, A4> = 100).

Chinokosha che TRUE chinofanira kunge chiripo muchitokisi B3 sezvo imwe chete yemamiriro ezvinhu ari kuedzwa inofanira kuva yechokwadi kune OR kana kuti kudzorera kukosha kwechokwadi, uye mumuenzaniso uyu zvinhu zviviri ndezvechokwadi:

• Iyo data iri muchitokisi A2 inopfuura makumi mashanu.
• Iyo data iri muchitokisi A3 haikwanisi 75.