Inqubo yokubala okuhlukahlukene nokusebenza nedatha, kuvame ukudingeka ukubala inani labo elilinganiselwe. Kubalwa ngokungeza izinombolo nokuhlukanisa inani eliphelele ngenani labo. Ake sibone indlela yokubala isilinganiso seqoqo lezinombolo usebenzisa i-Microsoft Excel ngezindlela ezihlukahlukene.
Indlela Yokubala Ejwayelekile
Indlela elula futhi eyaziwa kakhulu yokuthola i-arithmetic kusho izinombolo zezinombolo ukusebenzisa inkinobho ekhethekile kwi Ribbon ye-Microsoft Excel. Khetha ububanzi bezinombolo ezikukholomu noma umugqa wodokhumenti. Ngenkathi kuthebhu "Ekhaya", chofoza inkinobho ethi "AutoSum", ekhonjeni ebhokisini lamathuluzi "Ukuhlela". Kusuka ohlwini lokudonsa, khetha into "Isilinganiso".
Emva kwalokho, usebenzisa umsebenzi "ISITHOMBE", ukubalwa kwenziwa. Isilinganiso se-arithmetic salesi setha sezinombolo siboniswa esitokeni ngaphansi kwekholomu ekhethiwe, noma ngakwesokudla komugqa okhethiwe.
Le ndlela ilula futhi kulula. Kodwa futhi unezinselele ezibalulekile. Ngalendlela, ungakwazi ukubala inani elilinganiselwe lalabo kuphela izinombolo ezihlelwe ngokulandelana kukholomu eyodwa, noma emgqeni owodwa. Futhi lapha, ngezinhlobo zamaseli, noma ngamaseli ahlakazekile kushidi, usebenzisa le ndlela ayikwazi ukusebenza.
Isibonelo, uma ukhetha amakholomu amabili bese ubala isilinganiso se-arithmetic ngendlela echazwe ngenhla, khona-ke impendulo izonikezwa kukholomu ngayinye ngokwehlukana, hhayi yonke inqamuzana yamaseli.
Ukubalwa usebenzisa idijithali yomsebenzi
Ezimweni uma udinga ukubala isilinganiso samanani sezinhlobo zamaseli, noma amaseli ahlakazekile, ungasebenzisa umsebenzi wizard. Usebenza wonke umsebenzi ofanayo "ISITHOMBE", esaziwa ngendlela yokuqala yokubala, kodwa ingabe ngendlela ehlukile.
Sichofoza esitokisini lapho sifuna khona ukubalwa kokubaluleka okulinganiselwe. Chofoza inkinobho ethi "Faka umsebenzi", esekelwe ngakwesokunxele kwebha yefomula. Noma, sibhala inhlanganisela yokhiye Shift + F3.
Iqala umsebenzi wizard. Kuhlu lwemisebenzi esiyibheke "ISIGABA". Khetha, bese uchofoza inkinobho ethi "Kulungile".
Iwindi lempikiswano yomsebenzi ivula. Ensimini "Inombolo" faka izingxabano zomsebenzi. Lezi zingaba izinombolo ezejwayelekile noma amakheli eseli lapho lezi zinombolo zikhona. Uma kungenakwenzeka ukuba ufake amakheli eseli ngesandla, kufanele uchofoze inkinobho ekhona ngakwesokudla kwenkambu yokufaka idatha.
Ngemuva kwalokho, iwindi lempikiswano yokusebenza lincishisiwe, futhi ungakhetha iqembu lamaseli eshidi owathathayo ekubaleni. Khona-ke, chofoza inkinobho ngakwesobunxele kwenkambu yokungena kwedatha ukuze ubuyele ewindini lezingxoxo zokusebenza.
Uma ufuna ukubala isilinganiso samanani phakathi kwamanani asezinhlangothini ezihlukene zamaseli, khona-ke yenza izinyathelo ezifanayo njengoba kukhonjisiwe ngenhla ensimini ye- "Number 2". Futhi njalo kuze kube yilapho zonke amaqembu ezidingekile wamaseli akhethiwe.
Ngemva kwalokho, chofoza inkinobho ethi "Kulungile".
Umphumela wokubala isilinganiso sesibalo se-arithmetic uzogqanyiswa esitokisini owakhethile ngaphambi kokusebenzisa idijithali yomsebenzi.
Ibha yefomula
Kunendlela yesithathu yokuqalisa umsebenzi "ISIGABA". Ukuze wenze lokhu, iya kuthebhu "Amafomula". Khetha iseli lapho umphumela uzoboniswa khona. Emva kwalokho, eqenjini lamathuluzi "I-Library of imisebenzi" ku-tape chofoza inkinobho "Ezinye imisebenzi". Uhlu luvela lapho okudingeka uhambisane nezinto "Isitatimende" no- "AVERAGE" ngokulandelana.
Khona-ke, ifasitela lempikiswano elifanayo lomsebenzi liqaliswa njengalapho usebenzisa i-Function Wizard, ukusebenza esichazwe ngokuningiliziwe ngenhla.
Izenzo ezengeziwe zifana ncamashi.
Umsebenzi wokufaka ngesandla
Kodwa ungakhohlwa ukuthi ungakwazi njalo ukungena emsebenzini "ISITHOMBE" ngesandla uma ufisa. Izoba nephethini elilandelayo: "= ISITHOMBE (cell_address (inombolo); cell_address (inombolo)).
Yiqiniso, le ndlela ayiyona elula njengakudala, futhi idinga amafomula athile agcinwe ekhanda lomsebenzisi, kodwa iguquguquka kakhulu.
Ukubala kokubaluleka okujwayelekile kwesimo
Ngaphandle kokubala okuvamile kwesilinganiso esijwayelekile, kungenzeka ukubala inani elijwayelekile lesimo. Kulesi simo, kuphela lezo zinombolo ezivela ebangeni elikhethiwe ezihlangabezana nesimo esithile zizocatshangelwa. Isibonelo, uma lezi zinombolo zikhulu noma zingaphansi kwesilinganiso esithile seqoqo.
Ngale njongo, umsebenzi "ISIGABA" sisetshenziswa. Njengomsebenzi "WOKUSEBENZA", ungaqaliswa ngeWindows Function, kusukela kubha yefomula, noma ngokufaka ngesandla ngesitokisi. Ngemuva kokuthi ifasitela lezingxoxo livuliwe, udinga ukufaka imingcele yayo. Emkhakheni we "Range", faka ububanzi bamaseli, amanani ayo azohlanganyela ekunqumeni inombolo ye-arithmetic. Senza ngendlela efanayo nangomsebenzi "ISIGABA".
Futhi lapha, esimweni esithi "Isimo" kufanele sibonise inani elithile, izinombolo ezingaphezulu noma ngaphansi zazo ezizobamba iqhaza ekubalweni. Lokhu kungenziwa ngokusebenzisa izimpawu zokuqhathanisa. Isibonelo, sithathe inkulumo ethi "> = 15000". Lokhu kungukuthi, amaseli kuphela ebangeni lapho izinombolo ezikhulu noma ezilingana no-15000 zithathwa ukubalwa. Uma kunesidingo, esikhundleni senombolo ethile, ungacacisa ikheli leseli lapho inombolo ehambelana nayo.
Inkambu yohlu lokulinganisa ayidingekile. Ukufaka idatha kuyo kuyimpoqo kuphela uma usebenzisa amaseli enokuqukethwe kombhalo.
Uma yonke idatha ingenisiwe, chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, umphumela wokubala wesilinganiso se-arithmetic ebangeni elikhethiwe kuboniswa kuseli elanduliwe, ngaphandle kwamaseli anemininingwane engahlangabezane nemibandela.
Njengoba ubona, ku-Microsoft Excel, kunamathuluzi amaningi ongakwazi ukubala inani elilinganiselwe luchungechunge lwezinombolo ezikhethiwe. Ngaphezu kwalokho, kunomsebenzi okhetha ngokuzenzakalelayo izinombolo ezivela ebangeni elingavumelani nemigomo ebekwe ngaphambilini ngumsebenzisi. Lokhu kwenza ukubala ku-Microsoft Excel ngisho nangokwengeziwe komsebenzisi.
