Ama-Boolean Values Definition kanye nokusetshenziswa ku-Excel nama-Google Spreadsheets
I- Boolean Value , ngezinye izikhathi ebizwa ngokuthi i- Logical Value , ingenye yezinhlobo eziningi zedatha ezisetshenziswe ku-Excel nama-Google Spreadsheets.
Ebizwa nge-mathmatian yekhulu leshumi nesishiyagalolunye uGeorge Boole, amanani we-Boolean ayiyingxenye yegatsha le-algebra eyaziwa ngokuthi i- Boolean algebra noma i- Boolean logic .
I-logic ye-boolean ibalulekile kuwo wonke ubuchwepheshe bekhompuyutha, hhayi nje izinhlelo zesipredishithi, futhi ihlala emqondweni wokuthi wonke amanani angancishiswa ku-TRUE noma FALSE noma kusukela ubuchwepheshe bekhompuyutha kusekelwe ohlelweni lwezinombolo zobunambambili, ku-1 noma ku-0.
Ama-Boolean Value and Spreadsheet Imisebenzi eqondayo
Ukusetshenziswa kwamanani we-Boolean kumahlelo wesipredishithi ngokuvamile kuhlotshaniswa neqembu elinengqondo lemisebenzi efana nomsebenzi we-IF, umsebenzi we-AND, nomsebenzi we-OR.
Kule miisebenzi, njengoba kuboniswe kumfomula emigqeni engu-2, 3 no-4 esithombeni esingenhla, amanani we-Boolean angasetshenziswa njengomthombo wokufakazela ngenye yezingxabano zomsebenzi noma angakha umkhiqizo noma imiphumela yomsebenzi owenzayo ukuhlola enye idatha ekhasini lokusebenzela.
Isibonelo, ukuphikisana kokuqala komsebenzi we-IF emgqeni wesi-5 - ingxabano ye- Logical_test - kuyadingeka ukubuyisa inani le-Boolean njengempendulo.
Okusho ukuthi, impikiswano kufanele ihlaziye njalo isimo esingasenza kuphela impendulo ye-TRUE noma FALSE. Futhi, ngenxa yalokho,
- Uma impikiswano ibuyisela impendulo ye-TRUE, umsebenzi uzokwenza isenzo esisodwa (phinda idatha ku-cell A2 ngo-25).
- Uma impikiswano ibuyisela impendulo ye-FALSE, umsebenzi uzokwenza isenzo esihlukile (phinda idatha ku-cell A2 ngo-10).
Ama-Boolean Amanani nemisebenzi ye-Arithmetic
Ngokungafani nemisebenzi enengqondo, imisebenzi eminingi ku-Excel nama-Google Spreadsheets enza imisebenzi yezibalo - njenge-SUM, COUNT, ne-AVERAGE - ayishaya indiva amanani we-Boolean uma ekhona kumaseli afakwe emibhalweni yomsebenzi.
Isibonelo, esithombeni ngenhla, imisebenzi engu-COUNT emgqeni wesi-5, okubalwa kuphela amaseli aqukethe izinombolo, ayinaki izimiso ze-TRUE ne-FALSE ze-Boolean ezisemaseleni A3, A4, no-A5 futhi abuyisela impendulo ye-0.
Iguqula i-TRUE ne-FALSE ku-1 no-0
Ukuze ube namanani we-Boolean afakwe ekubalweni kwemisebenzi ye-arithmetic, kumele kuqala aguqulwe ibe ngamanani wenombolo ngaphambi kokuba adlulisele emsebenzini. Izindlela ezimbili ezilula zokufeza lesi sinyathelo zilandelayo:
- ukwandisa amanani we-Boolean ngomunye - njengoba kuboniswe amafomula emigqeni engu-7 no-8, okwandisa amanani TRUE kanye FALSE kumaseli A3 no-A4 ngenye;
- engeza i-zero ku-value ngayinye ye-Boolean - njengoba kuboniswe ifomula kulayini 9, enezela i-value ku-value TRUE kuseli A5.
Lezi zenzo zinomphumela wokuguqula:
- inani elingu-TRUE kumaseli A3 no-A5 kuya ku-1;
- inani FALSE kuseli A4 kuya ku-0.
Ngenxa yalokho, imisebenzi engu-COUNT emgqeni we-10 - ebeka inani lezinombolo kumaseli A7 kuya ku-A9 - ibuyisela umphumela wezintathu kunokuba i-zero.
Ama-Boolean Values namafomula e-Excel
Ngokungafani nemisebenzi ye-arithmetic, amafomula ku-Excel nama-Google Spreadsheets enza imisebenzi ye-arithmetic - njengokufaka noma ukususa - bayajabula ukufunda amanani we-Boolean njengezinombolo ngaphandle kwesidingo sokuguqulwa - amafomula anjalo abeka ngokuzenzakalelayo TRUE alingana no-1 no-FALSE ofana no-0.
Ngenxa yalokho, ifomula lokufaka emgqeni wesi-6 esithombeni ngenhla,
= A3 + A4 + A5
ufunda idatha kula maseli amathathu njenge:
= 1 + 0 + 1
futhi ubuyisela impendulo ye-2 ngokufanele.