Malemba a Boolean Tanthauzo ndi Kugwiritsa ntchito mu Excel ndi Google Spreadsheets
Mtengo wa Boolean , nthawi zina umatchedwa Logical Value , ndi imodzi mwa mitundu yambiri ya deta yogwiritsidwa ntchito mu Excel ndi Google Spreadsheets.
Amatchedwa katswiri wa masamu wa zaka za m'ma 1800 George Boole, chikhalidwe cha Boolean ndi mbali ya nthambi ya algebra yotchedwa Boolean algebra kapena Boolean logic .
Malingaliro a Boolean ndi ofunikira kwa makina onse a makompyuta, osati mapulogalamu a pulaneti, ndipo amatsamira pa lingaliro loti zinthu zonse zikhoza kuchepetsedwa kukhala ZOONA kapena ZOKHALA kapena kuchokera ku matekinoloje a makompyuta amachokera ku dongosolo lachiwerengero, ngakhale 1 kapena 0.
Makhalidwe a Boolean ndi Kufalitsa Mauthenga Othandiza
Kugwiritsiridwa ntchito kwa ma Boolean mu mapulogalamu a spreadsheet nthawi zambiri kumagwirizanitsidwa ndi gulu logwirika la ntchito monga IF function, AND function, ndi OR ntchito.
Mu ntchitoyi, monga momwe tawonetsedwera mu malemba awiri, 3 ndi 4 mu chithunzi pamwambapa, ziyeso za Boolean zingagwiritsidwe ntchito monga chitsimikizo chothandizira mfundo imodzi ya ntchito kapena akhoza kupanga zotsatira kapena zotsatira za ntchito yomwe ili Kufufuza deta ina mu tsamba la ntchito.
Mwachitsanzo, kukangana koyamba kwa IF kumagwira ntchito mzere 5 - mtsutso wa Logical_test - umayenera kubwezera mtengo wa Boolean monga yankho.
Izi zikutanthauza kuti kutsutsana kuyenera nthawi zonse kufufuza vuto limene lingathe kupeza yankho loona kapena lokhazikika. Ndipo, motero,
- Ngati mtsutso umabweretsa yankho la CHOONA, ntchitoyi idzachita chinthu chimodzi (kuwonjezera deta mu selo A2 ndi 25).
- Ngati mkangano umabweretsa yankho la FALSE, ntchitoyi idzachita zosiyana (kuwonjezera deta mu selo A2 ndi 10).
Miyambo ya Boolean ndi Ntchito za Arithmetic
Mosiyana ndi ntchito zomveka bwino, ntchito zambiri mu Excel ndi Google Spreadsheets zomwe zimagwira ntchito masamu - monga SUM, COUNT, ndi AVERAGE - kunyalanyaza zoyenera za Boolean pamene zimapezeka m'ma selo zikuphatikizidwa pazokambirana.
Mwachitsanzo, mu chithunzi pamwambapa, COUNT imakhala mu mzere 5, yomwe imangokhala maselo omwe ali ndi manambala, amanyalanyaza zikhulupiliro zenizeni zomwe zimapezeka m'maselo A3, A4, ndi A5 ndipo zimayankhira yankho la 0.
Kutembenuza CHOONA ndi ZOKHALA kwa 1 ndi 0
Kukhala ndi chikhalidwe cha Boolean mu mawerengedwe a masabata, ayenera poyamba kutembenuzidwa kuzinthu zamtengo wapatali asanawapereke kuntchito. Njira ziwiri zochepetsera izi ndizo:
- wonjezerani chikhalidwe cha Boolean ndi chimodzi - monga momwe zisonyezedwera ndi malemba mu mzere 7 ndi 8, omwe amachulukitsa zikhulupiliro ZOONA ndi ZOKHALA m'maselo A3 ndi A4 mwa imodzi;
- onjezerani zero ku mtengo uliwonse wa Boolean - monga momwe zasonyezedwera ndi ndondomeko ya mzere 9, yomwe imapanga zero ku mtengo woona mu selo A5.
Ntchito izi zimakhala ndi zotsatira zokonzanso:
- phindu lenileni m'maselo A3 ndi A5 mpaka 1;
- phindu lokhazikika mu selo A4 mpaka 0.
Zotsatira zake, zochitika COUNT mu mzere 10 - zomwe zimawerengetsa chiwerengero cha chiwerengero m'maselo A7 mpaka A9 - amabweretsanso zotsatira zitatu osati zero.
Miyambo ya Boolean ndi Excel Formula
Mosiyana ndi ntchito za masamu, zolemba mu Excel ndi Google Spreadsheets zomwe zimapanga masamu - monga kuwonjezera kapena kuchotsa - ndi okondwa kuwerengera chiwerengero cha Boolean monga nambala popanda kufunikira kutembenuka - njira zoterezi zimakhazikitsa CHOONA chofanana ndi 1 ndi FALSE ofanana ndi 0.
Zotsatira zake, ndondomeko yowonjezera mu mzere 6 mu chithunzi pamwambapa,
= A3 + A4 + A5
amawerenga deta mu maselo atatu monga:
= 1 + 0 + 1
ndi kubwezera yankho la 2 molingana.