Umsebenti ifomula esethiwe ngaphambilini ku-Excel nama- Google AmaSpredishithi okuhloswe ukuba enze ukubalwa okuqondile esitokisini lapho utholakala khona.
Umsebenzi we-Syntax nama-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
Njengazo zonke amafomula, imisebenzi iqala ngesibonakaliso esifanayo ( = ) ilandelwa igama lomsebenzi nezimpikiswano zalo:
- Igama lomsebenzi litshela i-Excel ukuthi yiziphi izibalo zokwenza;
- Izimpikiswano ziqukethe phakathi kwabazali bamahhala noma amabakaki azungezile bese utshela umsebenzi ukuthi iyiphi idatha ongayisebenzisa kulawo mabalo.
Isibonelo, omunye wemisebenzi esetshenzisiwe kakhulu ku-Excel nama-Google AmaSpredishithi yi- SUM umsebenzi :
= SUM (D1: D6)
Kulesi sibonelo,
- igama litshela i-Excel ukuthi lengeze ndawonye idatha kumaseli akhethiwe;
- umsebenzi wokuphikisana (D1: D6) uneza okuqukethwe kwebala leseli D1 kuya ku-D6.
ImiSebenzi Yokuzijabulisa kumafomula
Ukubaluleka kwemisebenzi eyakhelwe ngaphakathi ku-Excel kunganwetshwa ngokukhipha eyodwa noma ngaphezulu imisebenzi ngaphakathi komunye umsebenzi kwifomula. Umphumela wemisebenzi yokudoba ukuvumela ukuthi izibalo eziningi zenzeke kumakhalekhukhwini owodwa weshidi.
Ukwenza lokhu, umsebenzi owakhiwe usebenza njengesinye sezimpikiswano zomsebenzi oyinhloko noma ongaphandle.
Isibonelo, kufomula elandelayo, umsebenzi we- SUM unamathele ngaphakathi komsebenzi we-ROUND .
Lokhu kufezwa ngokusebenzisa umsebenzi we-SUM njengengxabano yenombolo yoMsebenzi we-ROUND.
& # 61; I-ROUND (i-SUM (D1: D6), 2)
Uma uhlola imisebenzi eyakhiwe, i-Excel yenza umsebenzi ojulile, noma ngaphakathi, kuqala bese usebenza ngendlela yayo ngaphandle. Ngenxa yalokho, ifomula ngenhla manje izobe:
- thola inani lamanani kumaseli D1 kuya ku-D6;
- ukuzungeza lo mphumela kuya ezindaweni ezimbili zamadesimali.
Kusukela ku-Excel 2007, amazinga angama-64 wemisebenzi eyakhiwe avunyelwe. Ezinguqulo ngaphambi kwalokhu, amazinga angu-7 wemisebenzi eyakhiwe avunyelwe.
Ishidi lokusebenzela vs. Imisebenzi Yomkhuba
Kunezigaba ezimbili zemisebenzi ku-Excel nama-Google AmaSpredishithi:
- Imisebenzi Yokushicilela Umsebenzi
- Imisebenzi eyenziwe ngokwezifiso noma yomsebenzisi
Imisebenzi yesikhwama semisebenzi yilabo abazalelwa kulolu hlelo, njengemisebenzi ye-SUM ne-ROUND exoxwe ngenhla.
Imisebenzi yangokwezifiso, ngakolunye uhlangothi imisebenzi ebhaliwe, noma ichazwe , ngumsebenzisi.
Ku-Excel, imisebenzi yenkambiso ibhaliwe ngolimi oluhlelwe uhlelo lokuhlela: i- Visual Basic yezinhlelo zokusebenza noma i-VBA okwesikhashana. Imisebenzi idalwa ngokusebenzisa i-Visual Basic umhleli esekelwe kuthebhu yonjiniyela yebhoni .
Imisebenzi yesiko ye-Google AmaSpredishithi ibhaliwe ku- Apps Script - ifomu leJavaScript - futhi idalwe usebenzisa umhleli weskripthi esitholakala ngaphansi kwemenyu yamathuluzi .
Imisebenzi ngokwezifiso ngokuvamile, kodwa hhayi njalo, yamukela uhlobo oluthile lokufaka idatha futhi ubuyisele umphumela esitokisini lapho itholakala khona.
Ngezansi yisibonelo somsebenzi ochazwe ngumsebenzisi obala izaphulelo zomthengi ezibhalwe ku-VBA code. Imisebenzi yokuqala echazwe ngumsebenzisi, noma i- UDF ishicilelwe kwiwebhusayithi ye-Microsoft:
Isaphulelo somsebenzi (ubungako, intengo)
Uma ubuningi> = 100 Khona-ke
Isaphulelo = inani lamanani * 0.1
Okunye
Isaphulelo = 0
Qeda Uma
Isaphulelo = Isicelo.Kuphakanyiswa (Isaphulelo, 2)
Qeda Umsebenzi
Ukulinganiselwa
Ku-Excel, imisebenzi echazwe ngumsebenzisi ingabuyisa kuphela amanani kuseli (s) lapho bekhona khona. Ngokwenza kanjalo, abakwazi ukukhipha imiyalo ukuthi noma iyiphi indlela ishintshe imvelo yokusebenza ye-Excel - njengokuguqula okuqukethwe noma ukufometha kweseli.
Isizinda solwazi lwe-Microsoft sihlonza ukulinganiselwa okulandelayo kwemisebenzi echazwe ngumsebenzisi:
- Ukufaka, ukususa, noma ukufometha amaseli kwiphepha lokusebenzela;
- Ukushintsha inani lemininingwane kwelinye iseli;
- Ukuhambisa, ukuqamba kabusha, ukususa, noma ukwengeza amashidi encwadini yokusebenzela ;
- Ukushintsha noma yiziphi izinketho zemvelo - njengemodi yokubala noma ukubukwa kwesikrini;
- Ukubeka izakhiwo noma ukwenza izindlela eziningi.
Imisebenzi echazwe ngumsebenzisi ne-Macros ku-Excel
Ngesikhathi amaSpredishithi e-Google engabasekeli njengamanje, ku-Excel, i-macro iyinhlanganisela yezinyathelo ezirekhodiwe ezenza imisebenzi ephindaphindiwe yomsebenzi - njengokufometha idatha noma ukukopisha nokuhlanganisa imisebenzi - ngokulingisa izinkinobho noma izenzo zegundane.
Ngisho noma bobabili basebenzisa ulimi lwe-Microsoft lwe-VBA ulimi, bahlukile ngezindlela ezimbili:
- I-UDF yenza izibalo ngenkathi ama-macros enza izenzo. Njengoba kushiwo ngenhla, i-UDF ayikwazi ukwenza imisebenzi ethinta imvelo yenkathi ngenkathi ama-macros angakwazi.
- Esikrinini seView Basic editor, le mibini ingahlukaniswa ngoba:
- U-UDF uqala ngesitatimende soMsebenzi bese uphela ngomsebenzi wokuphela ;
- Ama-Macros aqala ngesitatimende Esincane bese aphela nge- End Sub .