Kunezindlela eziningi zokulinganisa ukuthambekela okuphakathi noma, njengoba kubizwa ngokujwayelekile, isilinganiso, ngesethi yamanani.
Isilinganiso esivame ukubalwa ngaso sonke isikhathi sisho ukuthi i-arithmetic isho ukuthini - noma isilinganiso esilula - futhi kubalwa ngokungeza iqembu lezinombolo ndawonye bese uhlukanisa ngokubalwa kwalezo zinombolo. Isibonelo, isilinganiso esingu-4, 20, no-6 esongezwe ndawonye ngu-10 njengoba kuboniswe kulayini 4.
Amapredishithi e-Google anemisebenzi eminingi eyenza kube lula ukuthola amanye amanani ajwayelekile ajwayelekile asetshenziselwa. Lokhu kufaka:
- Umsebenzi we-AVERAGE - uthola incazelo ye-arithmetic ohlwini lwamanani.
- Umsebenzi we- MEDIAN - uthola inani eliphakathi ohlwini lwezinombolo.
- Umsebenzi we- MODE - uthola inani elivame ukwenzeka kakhulu ohlwini lwamanani.
I-Syntax Yesebenzayo Nokuphikisana
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I-syntax yomsebenzi we-AVERAGE yile:
= I-AVERAGE (inombolo_1, inombolo_2, ... inombolo_30)
- inombolo_1 - (edingekayo) idatha ezobekwa umsebenzi
- inombolo_2 ukufaka inombolo_30 - (ngokuzithandela) amanani wedatha angeziwe ukuze afakwe phakathi. Inombolo ephezulu yokufakwayo evunyelwe i-30
Izinombolo zezinombolo zingaqukatha:
- Uhla lwezinombolo ezizobekwa;
- Izinkomba zeselula endaweni yedatha kushidi lokusebenzela;
- Uhla lwezinkomba ezigciniwe;
- Ibanga elibizwe.
Inothi: Okufakwayo kombhalo namaseli aqukethe ama-Boolean values (TRUE noma FALSE) anqatshelwe umsebenzi njengoba kuboniswe emigqeni engu-8 no-9 esithombeni ngenhla.
Uma amangqamuzana angenalutho noma aqukethe umbhalo noma ama-boolean amanani ngokuhamba kwesikhathi ashintshwe ukuze abambe izinombolo, isilinganiso sizophinde senze kabusha ukuze senze izinguquko.
Amaseli angenalutho ahambisana ne-Zero
Uma kuziwa ekutholeni amanani ajwayelekile kumaSpredishithi e-Google, kukhona umehluko phakathi kwamangqamuzana angenalutho noma angenalutho nalabo abanesilinganiso senani.
Amangqamuzana angenalutho ayengayinaki umsebenzi we-AVERAGE, ongasetshenziswa kakhulu ngoba wenza ukuthi isilinganiso semininingwana engekho emithini yedatha elula kakhulu njengoba kuboniswe kulayini 6 ngenhla.
Amaseli aqukethe inani le-zero, noma kunjalo, afakwe ngokwesilinganiso njengoba kuboniswe kulayini 7.
Ukuthola umsebenzi we-AVERAGE
Njengamanye eminye imisebenzi eyakhelwe ku-Google Spreadsheet, umsebenzi we-AVERAGE ungafinyelelwa ngokuchofoza Faka > Umsebenzi kumamenyu ukuvula uhlu oludonsela phansi lwemisebenzi evame ukusetshenziswa ehlanganisa umsebenzi we-AVERAGE.
Ngaphandle kwalokho, ngoba isetshenziswe kakhulu, isinqamuleli somsebenzi singezwe kubha yamathuluzi yomsebenzi, ukwenza kube lula ukuthola nokusebenzisa.
Isithonjana kwibha yamathuluzi kwalokhu kanye neminye eminye imisebenzi ethandwayo yileligama lesiGreki Sigma ( Σ ).
Amapredishithi we-Google AVERAGE Function Isibonelo
Izinyathelo ezingezansi zihlanganisa ukuthi ungangena kanjani umsebenzi we-AVERAGE oboniswe emgqeni wesine kusibonelo esithombeni ngenhla usebenzisa isinqamuleli ku-AVERAGE umsebenzi okukhulunywe ngenhla.
Ukufaka i-AVERAGE Umsebenzi
- Chofoza kuseli D4 - indawo lapho imiphumela yefomula izoboniswa khona.
- Chofoza isithonjana seMisebenzi kubha yamathuluzi ngenhla kwekhasi lokusebenzela ukuze uvule uhlu olwehlisiwe lwemisebenzi.
- Khetha Isilinganiso kusuka kuhlu ukuze ufake ikhophi engenalutho yomsebenzi kuseli D4.
- Gqamisa amaseli A4 kuya ku-C4 ukuze ufake lezi zikhombo njengama-arguments for the function bese ucindezela ukhiye we- Enter kwikhibhodi.
- Inombolo engu-10 kufanele ivele kuseli D4. Lena isilinganiso samanani amathathu - 4, 20, no-6.
- Uma uchofoza kumakhalekhukhwini A8 umsebenzi ophelele = I-AVERAGE (A4: C4) ivela kubha yefomula ngaphezulu kwephepha lokusebenzela.
Amanothi:
- Amaseli ngabanye, kunokuba uhla oluqhubekayo linganezelwa njengezingxabano kodwa isithenjwa ngasinye se-cell kufanele sihlukaniswe nge-comma.
- Ngemuva kokungena kulo msebenzi, uma izinguquko zenziwa kudatha kumaseli akhethiwe, umsebenzi, ngokuzenzakalelayo, uvuselela ngokuzenzakalelayo ukukhombisa ushintsho.