Binciken Ƙimar Tallace-tsaren Bayyanawa da Amfani a cikin Tashoshi na Excel da Google
Wani darajar Boolean , wani lokaci ake magana da shi a matsayin Ma'anar Ainihin , yana ɗaya daga yawan bayanai da dama da aka yi amfani da su a cikin Excel da Google Spreadsheets.
An lasafta shi a bayan masanin lissafi na karni na sha tara George Boole, Boolean dabi'u suna cikin ɓangaren reshe na algebra da ake kira Boolean algebra ko Boolean dabaru .
Boolean ƙwarewa yana da muhimmanci ga duk kayan fasahohin kwamfuta, ba kawai fayilolin aikawa ba, kuma yana dogara ne akan manufar cewa za'a iya rage dukkan dabi'un ko dai TRUE ko FALSE ko tun lokacin da fasahar kwamfuta ta dogara ne akan tsarin binary number, ko dai ko 1 ko 0.
Bada Ƙididdiga da Ɗaukaka Ayyukan Ma'anar Lissafi
Amfani da dabi'un Boolean a cikin shirye-shiryen shafukan rubutu shine mafi yawancin hade da ƙungiya mai mahimmanci na ayyuka kamar aikin IF, da DA aiki, da kuma aikin OR.
A cikin waɗannan ayyuka, kamar yadda aka nuna a cikin ƙididdiga a cikin layuka 2, 3 da 4 a cikin hoton da ke sama, Ana iya amfani da dabi'u mai amfani a matsayin tushen shigarwa don daya daga cikin muhawarar aiki ko zasu iya samar da fitarwa ko sakamakon aikin da yake gwada sauran bayanai a cikin takardun aiki.
Alal misali, gardama na farko game da aikin IF a jere 5 - hujjar Logical_test - ana buƙata don mayar da darajar Boolean azaman amsa.
Wato, hujja dole ne a koyaushe yin la'akari da yanayin da zai iya haifar da wata amsa TRUE ko FALSE. Kuma, a sakamakon haka,
- Idan hujja ta dawo da amsar TRUE, aikin zaiyi aikin daya (ninka bayanai a cikin salula A2 ta 25).
- Idan hujjar ta dawo da amsar FALSE, aikin zai yi aiki daban (ninka bayanai a cikin cell A2 ta 10).
Ƙididdiga Tarurruka da Ayyukan Ƙididdiga
Sabanin ayyukan da ya dace, mafi yawan ayyuka a cikin Excel da Google Rubutun da ke aiwatar da ayyukan lissafi - irin su SUM, COUNT, da AVERAGE - watsi da dabi'u Boolean idan sun kasance a cikin kwayoyin da aka haɗa a cikin muhawarar aiki.
Alal misali, a cikin hoton da ke sama, aikin COUNT a jere na 5, wanda kawai ya ƙidaya kwayoyin da ke dauke da lambobi, ba su kula da dabi'un TRUE da FALSE Boolean a cikin kwayoyin A3, A4, da A5 ba kuma ya dawo da amsar 0.
Ana canza TRUE da FALSE zuwa 1 da 0
Don samun halayen Boolean da aka haɗa a cikin lissafin ayyukan aikin lissafi, dole ne a fara tuba zuwa lambobin lambobi kafin su wuce su zuwa aikin. Hanyoyi biyu masu sauki don aiwatar da wannan mataki shine:
- ninka halayen Boolean ta daya - kamar yadda aka nuna ta dabarar a cikin layuka 7 da 8, wanda ya ninka dabi'un TRUE da FALSE a cikin kwayoyin A3 da A4 daya;
- ƙara zero zuwa kowane darajar Boolean - kamar yadda aka nuna ta hanyar da ke cikin jere 9, wanda ya ƙara zera zuwa lambar TRUE a cell A5.
Wadannan ayyukan suna da tasirin canzawa:
- darajar TRUE a cikin kwayoyin A3 da A5 zuwa 1;
- darajar FALSE a cikin salula A4 zuwa 0.
A sakamakon haka, aikin COUNT a jere na 10 - wanda ya ƙididdige adadin bayanai a cikin kwayoyin A7 zuwa A9 - ya dawo sakamakon sakamako uku maimakon zero.
Bada Ƙididdiga da Formats na Excel
Ba kamar ayyukan lissafi ba, ƙididdiga a cikin Excel da Shafukan Wizard na Google waɗanda suke gudanar da ayyukan lissafi - kamar ƙara ko raguwa - suna farin ciki don karanta dabi'un Boolean kamar lambobi ba tare da buƙatar tuba - irin wannan takamammen suna saita TRUST daidai da 1 da FALSE daidai da 0.
A sakamakon haka, daɗaɗɗen tsari a jere 6 a cikin hoton da ke sama,
= A3 + A4 + A5
karanta bayanan da ke cikin kwayoyin guda uku kamar:
= 1 + 0 + 1
kuma ya dawo da amsar 2 bisa ga haka.