Iimpawu zeBoolan Definition kunye nokuSebenza kwi-Excel kunye ne-Google Spreadsheets
Ixabiso leBoolean , ngamanye amaxesha elibizwa ngokuba yixabiso loLungiso , lunye lweentlobo zeedatha ezisetyenziswa kwi-Excel kunye ne-Google Spreadsheets.
Ebizwa emva kweempawu ze-mathematian yekhulu le-19 uGeorge Boole, ixabiso leBoolean liyinxalenye yesebe ye-algebra ebizwa ngokuba yi- Boolean algebra okanye i- Boolean logic .
I-logic ye-Boolean ibalulekile kuzo zonke iikhompyutheni zekhompyutheni, kungekhona nje iiprogram ze-spreadsheet, kwaye ihlala ingcamango yokuba zonke izithethe zingancitshiswa zibe yi-TRUE okanye FALSE okanye ekubeni iteknoloji yekhompuyutha isekelwe kwinkqubo yenombolo yebhanari, kwi-1 okanye kwi-0.
Imilinganiselo yeBoolean kunye neSpreadsheet Imisebenzi yoLwazi
Ukusetyenziswa kweempawu zeBoolean kwiiprogram ze-spreadsheet zidla ngokudibanisa neqela elinengqiqo yemisebenzi enjengomsebenzi we-IF, umsebenzi we-AND, kunye nomsebenzi we-OR.
Kule mi sebenzi, njengoko kuboniswe kwiifomula kwimigangatho yesi-2, 3 kunye no-4 kumfanekiso ongentla, ixabiso le-Boolean lingasetyenziselwa njengomthombo wokufakelwa kwesinye seziphakamiso zomsebenzi okanye bangenza umphumo okanye iziphumo zomsebenzi owenziwa ukuvavanya ezinye iinkcukacha kwiphepha lokusebenzela.
Umzekelo, ingxabano yokuqala ye-IF umsebenzi kumqolo 5 - ingxabano ye- Logical_test - iyadingeka ukubuyisa inani leBoolean njengempendulo.
Oko kukuthi, ingxabano kufuneka ihlalutye imimiselo engabangela kuphela impendulo ye-TRUE okanye FALSE. Kwaye, ngenxa yoko,
- Ukuba impikiswano ibuyisela impendulo ye-TRUE, umsebenzi uya kwenza enye inxaxheba (phinda idatha kwi-cell A2 ngo-25).
- Ukuba impikiswano ibuyisela impendulo ye-FALSE, umsebenzi uya kwenza isenzo esahlukileyo (phinda idatha kwi-cell A2 ngo-10).
Imilinganiselo yeBoolean kunye neMisebenzi yeAritith
Ngokungafani nemisebenzi enengqiqo, ininzi imisebenzi kwi-Excel kunye ne-Google Spreadsheets ezenza imisebenzi ye-arithmetic - njenge-SUM, COUNT, kunye NE -VERVERAGE - ingayinaki imilinganiselo ye-Boolean xa ikhona kwiiseli ezibandakanyiwe kwiingxoxo zomsebenzi.
Umzekelo, kumfanekiso ongentla, umsebenzi we-COUNT kumgca we-5, obala kuphela amaseli anenombolo, ayinaki imilinganiselo ye-TRUE ne-FALSE ye-Boolean ekhoyo kwiiseli A3, A4, ne-A5 kwaye abuyisela impendulo ye-0.
Ukuguqula IQINISO kunye NOKUQALA kwi-1 no-0
Ukuba neenqobo zeBoolean zibandakanyiwe kubalo lweemisebenzi ze-arithmetic, kufuneka ziqale ziguqulwe kwiimanani zecatshulwa ngaphambi kokuba zidluliselwe emsebenzini. Izindlela ezimbini ezilula zokufeza eli nyathelo zi:
- ukwandisa ixabiso leBoolean ngenye - njengoko kuboniswe ngamafomula kwimigangatho yesi-7 no-8, ephindaphinda ixabiso le-TRUE kunye ne-FALSE kwiiseli ze-A3 kunye ne-A4 enye;
- yongeza intlawulo kwixabiso ngalinye leBoolean - njengoko kuboniswe ngolu hlobo kumgca-9, obangela inani kwixabiso LEQINISO kwi-cell A5.
Le mi sebenzi inefuthe lokuguqula:
- Ixabiso eliyinyaniso kwiiseli A3 kunye ne-A5 ukuya ku-1;
- ixabiso FALSE kwiseli A4 ukuya ku-0.
Ngenxa yoko, umsebenzi we-COUNT kumqolo 10 - owenza inani leenombolo kumaseli A7 ukuya ku-A9 - ubuyisela umphumo wezinto ezintathu kunokuba zero.
Iimpawu zeBoolan kunye neeFomula ze-Excel
Ngokungafani nemisebenzi ye-arithmetic, iifomula kwi-Excel kunye ne-Google Spreadsheets ezenza imisebenzi ye-arithmetic - njengokongezwa okanye ukususa - bayavuya ukufunda amaBoolean njengamanani ngaphandle kwesidingo sokuguqulwa - ezo zifomula zibeka ngokuzenzekelayo i-TRUE elingana no-1 ne-FALSE elingana no-0.
Ngenxa yoko, ifomula yokufakela kumqolo 6 kumfanekiso ongentla,
= A3 + A4 + A5
ufunda idatha kwiiseli ezintathu njenge:
= 1 + 0 + 1
kwaye ubuyisela impendulo ye-2 ngokufanelekileyo.