Iziphakamiso yizilinganiso ezisebenzisayo ukwenza izibalo. Kuzinhlelo zesipredishithi ezifana ne-Excel nama-Google AmaSpredishithi, imisebenzi yilezi zindlela ezakhelwe ngaphakathi ezenza izibalo ezibekiwe futhi iningi lalemisebenzi idinga idatha ukuthi ingeniswe, kungaba ngumsebenzisi noma omunye umthombo, ukuze ubuyele umphumela.
Umsebenzi we-Syntax
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, ama-parenthesis, ama-separator ama-comma, nezimpikiswano zalo.
Lezi zizathu zihlala zizungezwe ngabazali kanye neziphakamiso ngabanye zihlukaniswa ngama-commas.
Isibonelo esilula, esiboniswe esithombeni esingenhla, isenzo se-SUM - esingasetshenziselwa ukuhlanganisa noma amakholomu amaningi amade noma imigqa yezinombolo. I-syntax yalo msebenzi yilezi:
I-SUM (Inombolo1, Inombolo2, ... Inamba255)
Izimpendulo zalolu msebenzi ziyi: Number1, Number2, ... Number255
Inombolo yezimpikiswano
Inombolo yezimpikiswano ukuthi umsebenzi udinga ukuhluka nomsebenzi. Umsebenzi we-SUM ungaba nezimpikiswano ezingafika ku-255, kodwa eyodwa kuphela edingekayo - ingxabano yeNombolo1 - okusele kungakhetha.
Umsebenzi we-OFFSET, okwamanje, unezimpikiswano ezintathu ezidingekayo kanye nezibili zokuzikhethela.
Eminye imisebenzi, efana nemisebenzi NOW ne- TODAY , ayinayo imibono, kodwa udwebe idatha yabo - inombolo ye - serial noma idethi - kusukela kweso lesistimu yekhompiyutha. Ngisho noma kungabikho izingxabano ezidingekayo ngalezi zenzo, ama-parentheses, ayingxenye ye-syntax yomsebenzi, kumele ahlanganiswe uma engena emsebenzini.
Izinhlobo Zedata ngezimpikiswano
Njengenombolo yezimpikiswano, izinhlobo zedatha ezingangeniswa ngxabano ziyahlukahluka kuye ngokuthi umsebenzi.
Endabeni yomsebenzi we-SUM, njengoba kuboniswe esithombeni ngenhla, izimpikiswano kufanele zibe nombolo yenombolo - kodwa le datha ingaba:
- idatha yangempela ifingqa - ingxabano yeNombolo1 esithombeni ngenhla;
- ireferensi yeselula ngayinye endaweni yedatha yenombolo ekhasini lokusebenzela - ingxabano yeNombolo2;
- i-array noma ububanzi bezinkomba zocingo - ingxabano yeNombolo3;
Ezinye izinhlobo zedatha ezingasetshenziselwa iziphakamiso zithi:
- idatha yombhalo;
- Amanani we-Boolean ;
- amaphutha wephutha ;
- eminye imisebenzi.
ImiSebenzi Yokuzijabulisa
Kuvamile ukuthi umsebenzi owodwa ungene njengengxabano yomunye umsebenzi. Lo msebenzi uyaziwa ngokuthi imisebenzi yokudoba futhi kwenziwa ukwandisa amandla okwenza lolu hlelo ekusebenzeni izibalo eziyinkimbinkimbi.
Isibonelo, akuyona into engavamile ukuthi imisebenzi ye- IF ifakwe ngaphakathi ngaphakathi komunye njengoba kuboniswe ngezansi.
= IF (A1> 50, IF (A2 <100, A1 * 10, A1 * 25)
Kulesi sibonelo, umsebenzi we-IF wesibili noma owembulukile usetshenziswa njengengxabano ye- Value_if_yiqiniso yenqubo yokuqala ye-IF futhi isetshenziselwa ukuvivinya isimo sesibili - uma idatha e-cell A2 ingaphansi kwezingu-100.
Kusuka ku-Excel 2007, amazinga angu-64 wokuhlala avunyelwe emafomulini. Ngaphambi kwalokho, amazinga ayisishiyagalombili kuphela wokusekela asekelwa.
Ukuthola i-Function & # 39; s Izimpendulo
Izindlela ezimbili zokuthola izidingo zokuphikisana kwemisebenzi ngayinye yizi:
- Vula ibhokisi lengxoxo lomsebenzi ku-Excel;
- Amawindi we-Tooltip ku-Excel nama-Google Spreadsheets.
Ama-Box Box Dialog Boxing
Iningi lemisebenzi e-Excel linobhokisi lengxoxo - njengoba kuboniswe umsebenzi we-SUM esithombeni ngenhla - obala iziphakamiso ezidingekayo nezizikhethela zomsebenzi.
Ukuvula ibhokisi lengxoxo lomsebenzi kungenziwa ngu:
- ukuthola nokuchofoza igama lomsebenzi ngaphansi kwethebhu yeForomu yebhebhoni ;
- ngokuchofoza inketho ye- Function Faka efakwe kwibha yefomula - njengoba kuboniswe esithombeni ngenhla.
Amathiphu: Ukuthayipha igama lomsebenzi & # 39; s
Enye indlela yokuthola izimpendulo zomsebenzi ku-Excel naku-Google Spreadsheets ku:
- Chofoza kuseli,
- Faka uphawu olulinganayo - ukwazisa uhlelo olufakwe ifomula;
- Faka igama lomsebenzi - njengoba uthayipha, amagama azo yonke imisebenzi eqala ngaleyo ncwadi avela esitokisini samathuluzi ngaphansi kweseli esebenzayo;
- Faka i-parenthesis evulekile - umsebenzi ocacisiwe kanye neziphakamiso zawo zihlelwe ku-tooltip.
Ku-Excel, iwindi le-tooltip lizungeze izingxabano ozikhethela nabakaki abesikwele ([]). Zonke ezinye iziphakamiso ezibalwe zidingekile.
Ku-Google Spreadsheets, iwindi le-tooltip alihlukanisi phakathi kwezingxoxo ezidingekayo nezokuzikhethela. Esikhundleni salokho, kufaka isibonelo kanye nesifinyeto sokusetshenziswa komsebenzi kanye nencazelo yenkambinkimbi ngayinye.