Boolean Values Tsanangudzo uye Kushandisa mu Excel neGoogle Spreadsheets
A Boolean Value , dzimwe nguva inonzi Logical Value , ndiyo imwe yemhando dzemhando dzakashandiswa mu Excel neGoogle Spreadsheets.
Anonzi mushure megumi nemakore zana remakore rechigumi nemakore makumi maviri nemapfumbamwe George Boole, kukosha kweBoolean chikamu chebazi re algebra rinonzi Boolean algebra kana Boolean logic .
Chirevo cheBoolean chinokosha kune tekombiyuta yekombiyuta, kwete mapurogiramu epadheseti, uye inotsigira pfungwa yokuti maitiro ose anogona kuderedzwa kuti ave ECHOKWADI kana FALSE kana kubva purogiramu yekombiyuta inobva pane imwe nhamba yemabhadhari, kusvika 1 kana 0.
Boolean Values uye Spreadsheet Mhemberero yeMagetsi
Kushandiswa kweBoolean mazano mumapurogiramu eparashiriti inowanzobatanidzwa neboka rinonzwisisika remabasa akadai seA IF function, neA AND function, uye OR basa.
Mune mabasa aya, sezvakaratidzwa mune zvinyorwa mumitsara 2, 3 ne4 mumufananidzo wepamusoro, maitiro eBoolean anogona kushandiswa semuipi wekupinza kweimwe yemashoko ekushanda kana vanogona kugadzira zvakabuda kana zvibereko zvebasa iri kuongorora imwe dheta mubhuku rekushanda.
Semuenzaniso, nharo yokutanga yeAIF basa mumutsara we5 - Logical_test nharo - inodiwa kudzorera kukosha kweBoolean semhinduro.
Izvi zvinoreva kuti, nharo yacho inofanira kugara ichitarisa mamiriro ezvinhu anogona kungoguma aita mhinduro ye TRUE kana FALSE. Uye, semugumisiro,
- Kana nharo yacho inodzorera mhinduro ye TRUE, basa racho richaita chimwe chiito (wedzerai data muchikamu cheA2 ne25).
- Kana kukakavara kuchidzorera mhinduro yeFALSE, basa racho richaita chiito chakasiyana (wedzera nhamba iri muchitokisi A2 ne10).
Boolean Values uye Mabasa Aritemu
Kusiyana nemabasa anonzwisisika, mabasa akawanda muExcel neGoogle Spreadsheets anoita mabasa ekuita masvomhu - akadai SUM, COUNT, uye AVERAGE - kusava nehanya neBoolean kukosha pavanenge vari mumasero akabatanidzwa mumagariro ebasa.
Somuenzaniso, mumufananidzo uri pamusoro, zvinhu COUNT zviri mumutsara wekutanga, izvo zvinongorore masero ane nhamba, inorega kutendeseka kwechokwadi uye kwemaBOLOan iri mumasero A3, A4, neA5 uye inodzorera mhinduro ye 0.
Kutendeuka CHOKWADI uye FALSE kusvika 1 ne0
Kuti uve neBoolean mazano akabatanidzwa mukuverenga kwemashoko echibvumirano, vanofanira kutanga vatendeuka kuhuwandu hwemhando dzisati dzavaendesa kune basa. Nzira mbiri dzisiri nyore dzekuita danho iri ndezvekuti:
- kuwedzera maitiro eBoolean nemumwe - sezvinoratidzwa nemafomu mumiganhu ye7 ne8, iyo inowedzera hutano TRUE uye FALSE mumasero A3 neA4 imwe;
- wedzera zero kumunhu mumwe nomumwe weBoolean - sezvinoratidzwa nemurairo mumutsara 9, iyo inowedzera zero kukosha TRUE muchitsetsi A5.
Aya maitiro anobatsira ekushandura:
- kukosha kwechokwadi TRUE mumasero A3 uye A5 kusvika 1;
- kukosha kweFALSE muchitokisi A4 kusvika ku0.
Somugumisiro, zvikamu COUNT zviri mumutsara wegumi-izvo zvinotora nhamba ye nhamba mumasero A7 kusvika kuA9 - inodzorera mugumisiro wevatatu panzvimbo ye zero.
Boolean Values uye Excel Formulas
Kusiyana nemabasa echibvumirano, mazano muExcel neGoogle Spreadsheets anoita mabasa ekuita masvomiti - sekuwedzera kana kubvisa - anofara kuverenga maitiro eBoolean se nhamba pasina kudiwa kwekutendeuka - maitiro akadaro anongogadzika TRUE akaenzana ne1 uye FALSE akaenzana ne 0.
Somugumisiro, fomu yekuwedzera mumutsara we 6 mumufananidzo uri pamusoro,
= A3 + A4 + A5
anoverenga data mumasero matatu se:
= 1 + 0 + 1
uye inodzorera mhinduro ye 2 maererano.