Nharo ndidzo mitemo inoshanda inoshandiswa kuita zviyero. Mune mapurogiramu epadheseti akadai seExcel neGoogle Sheets, mabasa akangovakwa-mumashandisirwo anoita maverengero akaiswa uye mazhinji emabasa aya anoda dheta kuti inyore, zvichida nemushandisi kana imwe nzvimbo, kuitira kuti adzorere mhinduro.
Basa reSintax
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mazera, mavheekeri, uye mazano ayo.
Nharo dzinogara dzakapoteredzwa nevabereki uye nharo dzemunhu mumwechete dzakaparadzaniswa nemagetsi.
Muenzaniso wakajeka, unoratidzwa mumufananidzo uri pamusoro, ndiro basa reSUM - iro rinogona kushandiswa kuvhara kana kuti yakazara mienzaniso yakareba kana mitsetse yenhamba. Izwi rechirevo chebasa iri nderokuti:
SUM (Nhamba1, Nhamba2, ... Nhamba255)
Mhedziso yebasa iri ndeye: Number1, Number2, ... Number255
Nhamba yeArguments
Nhamba yenharo dzokuti basa rinoda kusiyanana nebasa racho. Basa reSUM rinogona kusvika kusvika ma25 arguments, asi rinongodiwa chete - nhamba yeNhamba1 - zvakasara zvinosarudzwa.
IO OFFSET basa, panguva iyo, ine zvitatu zvinoda kupikisana uye zviviri zvingasarudzwa.
Zvimwe mabasa, zvakadai seZIMWE neZUVA nhasi , hazvina matanho, asi dhonza data yavo - nhamba ye serial kana kuti zuva-kubva pamakombiyuta emasikati. Kunyange zvazvo pasina nharo inotarisirwa nemabasa aya, mavabereki, ayo ari chikamu chechibvumirano chebasa, inofanira kunge ichibatanidzwa paanopinda mubasa.
Mhando dzeDhina muArguments
Kufanana nenhamba yepikisano, mhando dze data dzinogona kupinda mukati mharo dzichasiyana zvichienderana nebasa racho.
Muchiitiko chebasa reSUM, sezvakaratidzwa mumufananidzo uri pamusoro, mhedziso inofanira kuva nenhamba yedata - asi iyi dheta inogona kuva:
- iyo chaiyo data inopfupiswa - nhamba yeNhamba1 mumufananidzo uri pamusoro;
- imwe sero rinotarisa nzvimbo yekuverenga nhamba muhwhepa rekushanda - nhamba ye Number2;
- mhando kana uwandu hwemaferensi ezvinyorwa - nharo yeNhamba3;
Mimwe mhando yedata iyo inogona kushandiswa mukukakavara inosanganisira:
- text data;
- Boolean zvinokosha ;
- error error ;
- mamwe mabasa.
Nesting Mabasa
Zvinowanzoita kuti rimwe basa ripinde sechinhu chimwe chebasa. Kuvhiya uku kunozivikanwa sekugadzira nesting uye kunoitwa kuparidzira kukwanisa kwepurogiramu mukuita zviyero zvakaoma.
Semuenzaniso, hazvisi zvisinganzwisisiki kuti IF inoshanda kuti ive nenyuchi mukati memumwe seyakaratidzwa pasi apa.
= IF (A1> 50, IF (A2 <100, A1 * 10, A1 * 25)
Mumuenzaniso uyu, yechipiri kana nested IF inoshanda inoshandiswa seChirungu_Chi_ku_kukakavadzana kwekutanga kweAF uye inoshandiswa kuedza kwechipiri chechipiri - kana data iri muchitsetse A2 iri pasi pe100.
Kubvira paExcel 2007, 64 mazinga ekudyara anobvumirwa nemafomu. Tisati tadaro, maitiro manomwe chete ekugadzira dendere aitsigirwa.
Kuwana Basa & # 39; s Arguments
Nzira mbiri dzekuwana nharo dzemakakatanwa kune mabasa ega ndeaya:
- Vhura bhokisi rebasa rebhokisi iri mu Excel;
- Zita rekushandisa muItcel neGoogle Spreadsheets.
Excel Function Mabhokisi ekukurukurirana
Izvo zvakawanda zvemashoko muEexcel zvine bhokisi rekukurukurirana - sekuratidzwa kwebasa reSUM mumufananidzo wepamusoro - iyo inonyora zvikonzero zvinodiwa uye zvinosarudzwa zvebasa racho.
Kuvhura bhokisi rebasa rebasa rinogona kuitwa ne:
- kutsvaga nekudhonza pazita rebasa pasi peTramula tab yebhoni ;
- kutarisa pamusoro peKuisa Kushanda Kushandiswa iri pedyo nebar bar - sezvinoratidzwa mumufananidzo uri pamusoro.
Tooltips: Typing Function & # 39; s Zita
Imwe nzira yekuwana nharo dzebasa mu Excel uye muGoogle Spreadsheets ndedzekuti:
- Dzvanya pane imwe kero,
- Pinda chiratidzo chakaenzana - kuzivisa purogiramu kuti fomu iri kuiswa;
- Ita zita rebasa - apo iwe unyoresa, mazita emabasa ose anotanga neye tsamba iyo inowanikwa mubhuku rinoshandiswa pasi pechikamu chinoshanda;
- Pinda mubereki wakasununguka - basa rakanzwisiswa uye nharo dzaro dzakanyorwa mu tooltip.
MuExpcel, hwindo rekushandisa rakapoteredza nharo dzekuzvisarudzira nemakona mabheji ([]). Vamwe vose vakanyora nharo dzinodiwa.
MuGoogle Spreadsheets, hwindo rekushandisa harina kusiyanisa pakati pezvinodiwa uye zvingasarudzwa. Pane kudaro, inosanganisira muenzaniso pamwe nechidimbu chekushanda kwebasa uye tsanangudzo yemashoko ose.