Basa rinotangira mazano mu Excel neGoogle Sheets iyo inotarisirwa kuita zviyero zvakananga mune sero iyo iripo.
Basa Rinoshandiswa Sendikiti uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Kufanana nemamwe mazano, basa rinotanga nechiratidzo chakaenzana ( = ) chinoteverwa nezita remabasa uye mazano aro:
- Izwi rinoshanda rinoudza Excel kuti zviyero zvipi kuti zviite;
- Nharo dzinowanikwa mukati mababarese kana mabheji akapoteredza uye taurira basa basa rekushandisa mune izvo zviyero.
Somuenzaniso, rimwe remabasa akashandiswa zvikuru muExcel neGoogle Sheets ndeye SUM basa :
= SUM (D1: D6)
Mumuenzaniso uyu,
- zita rinoudza Excel kuwedzera pamwe chete data mumasero akasarudzwa;
- iyo nharo (D1: D6) basa inowedzera zviri mukati yesero riri D1 kusvika D6.
Nesting Mabasa muFomu
Kubatsira kweExcel yakagadzirirwa mukati memabasa kunogona kuwedzerwa nekugadzira imwe kana mamwe mabasa mukati meimwe basa mubasa. Mhedzisiro yekuita nesting mabasa ndeyekubvumira kuverenga kwakawanda kuti kuitwe mune imwe sero sepaesepa.
Kuti uite izvi, chinhu chakasvibiswa chinoshanda sechimwe chezvikonzero zvekutanga kana kwekunze.
Semuenzaniso, mumutsetse unotevera, basa reSUM rakasvibiswa mukati meROUND basa .
Izvi zvinoitwa kuburikidza uchishandisa basa reSUM seMushandi weROUND's Number argument.
& # 61; ROUND (SUM (D1: D6), 2)
Kana uchitarisa zvinhu zvakasvibiswa, Excel inoita yakadzika, kana kuti mukati-kati, inotanga uye inoshanda nzira yayo kunze. Somugumisiro, chirevo pamusoro apa chichave zvino:
- tsvaka huwandu hwehutano mumasero D1 kusvika kuD6;
- zvakakomberedza chigumisiro ichi kusvika kune mbiri mbiri.
Kubvira paExcel 2007, kusvika kumatanho makumi matanhatu emabasa akavakwa anobvumidzwa. Muzvinyorwa izvi zvisati zvaitika, maitiro manomwe ematendere akashandiswa.
Pepa Rokushandura vs. Zvimwe Zvemitambo
Pane makirasi maviri emabasa muExcel neGoogle Sheets:
- Pepa Rokushanda
- Tsika kana Basa Rakatsanangurwa Nomudzidzi
Dhesi rekushandira ndiro ndiyo inowanikwa pachirongwa, zvakadai semabasa eSUM uye ROUND zvinokurukurwa pamusoro apa.
Maitiro echimiro, kune rumwe rutivi ndidzo zvakanyorwa zvakanyorwa, kana zvinotsanangurwa , nemushandisi.
MuchiExcel, tsika dzetsika dzakanyorwa mune rakagadzirwa-in programming language: Visual Basic ye Applications kana VBA kwenguva pfupi. Mabasa acho anoshandiswa achishandisa Visual Basic editor iri paKusvitsa tabu rebhoni .
Maitiro eGoogle Sheets 'akanyorwa muGoogle Script - chimiro cheJavaScript - uye anoshandiswa achishandisa script editor iri pasi peMathuluzi menu.
Mitambo yemitambo kakawanda, asi kwete nguva dzose, kugamuchira imwe nzira yekuisa mazano uye kudzorera mhinduro mune sero iyo iripo.
Pasi pane muenzaniso wemushandisi wakatsanangurwa basa unoverenga mutengi zvidhese zvakanyorwa muVBA code. Mushandisi wepakutanga anotsanangurwa mabasa, kana UDF yakabudiswa pawebsite yeMicrosoft:
Basa Remutengo (yakawanda, mutengo)
Kana yakawanda> = 100 Ipapo
Discount = kuwanda * mutengo * 0.1
Zvimwe
Discount = 0
Endai Kana
Discount = Kushanda.Round (Discount, 2)
Pedza Basa
Zvikanganiso
MuExcel, kushandiswa kwevashandisi mabasa kunongodzorera maitiro kune sero (s) mavari. Mukuita kudaro, havakwanisi kuita mirairo iyo nenzira ipi zvayo inoshandura mamiriro ekushanda eExcel - sekushandura zviri mukati kana kuumbwa kwesero.
Tsanangudzo yeMicrosoft inorondedzera kukanganisa kunotevera kwemabasa anotsanangurwa:
- Kuisa, kubvisa, kana kuumba masero mupepaiti;
- Kuchinja kukosha kwe data mune imwe sero;
- Kufamba, kutumidzazve, kubvisa, kana kuwedzera mapepa kubhuku rebhuku ;
- Kuchinja chero zvingasarudzwa nemamiriro okunze - zvakadai semamiriro ekuverenga kana kuonekwa kwechiso;
- Kuchengetedza dzimba kana kuisa nzira dzakawanda.
Mushandisirwo Mabasa Akatsanangurwa vs. Macros mu Excel
Kunyange zvazvo maSpredishiti eGoogle asiri kuvatsigira panguva ino, muExcel, macro inotora matanho akarembedzwa anoshandura mafambiro ekudzokorora mapepa - zvakadai sekufambisa data kana kukopa nekugadzirisa mabasa - nekutevedzera zvinyorwa kana maitiro maitiro.
Kunyange zvazvo vose vari kushandisa shanduro yemitauro yeVBA yeMicrosoft, ivo vakasiyana nenzira mbiri:
- UDF inotora zviyero apo macros inoita zviito. Sezvambotaurwa pamusoro apa, UDF haigoni kuita zvigaro zvinokonzera mamiriro epurogiramu apo macros inokwanisa.
- Mune Visual Basic editor window, izvi zviviri zvinogona kusiyaniswa nokuti:
- UDF inotanga neshoko reMabasa uye inoguma neKupedzisira Kushanda ;
- Macros inotanga neChirevo cheS Sub uye inoguma ne End Sub .