Mubipimo byinshi bikoreshwa mumibare, birakenewe guhitamo kubara. Twabibutsa ko gucwa intoki iyi mibare ari umwuga urambye. Kubwamahirwe, porogaramu ya Excel ifite imikorere yemerera kwinjiza uburyo bwo kubara. Turashaka algorithm yo gukorana nibikoresho.
Kubara gutatanya
Gutatanya ni ikimenyetso cyo gutandukana, nikihe kigereranyo cyo gutandukana mubiteganijwe mumibare. Rero, igaragaza gutatanya imibare ugereranije n'agaciro. Kubara kabiri birashobora gukorwa haba kubaturage rusange nicyitegererezo.Uburyo 1: Kubara n'Ubuhinzi rusange
Kubara iki kimenyetso muri Excel, ishyirahamwe rusange rikoresha imikorere yerekana. Syntax yiyi mvugo ifite uburyo bukurikira:
= D.G (Umubare1; Umubare2; ...)
Impaka 1 kugeza 255 zirashobora gukoreshwa. Nkimpaka bashobora gukora nkindangagaciro zikoreshwa hamwe nibisobanuro bigera kuri selile zirimo.
Reka turebe uburyo bwo kubara agaciro kurwego hamwe namakuru yumubare.
- Dutanga guhitamo selile kurupapuro aho ibisubizo byo kubara bizerekanwa. Kanda kuri buto "Shyiramo Imikorere", shyirwa ibumoso bwumugozi wa formula.
- Inshingano nyamukuru iratangira. Mu cyiciro cya "staristi" cyangwa "Urutonde rwuzuye rwinyuguti", dukora ubushakashatsi ku gutongana nizina "ukuguru". Nyuma yo kuyisanga, tuyitanga hanyuma ukande kuri buto "OK".
- Kwerekana kwerekana kwerekana imikorere ni kwiruka. Shyira indanga muri "Umubare1". Tugenera intera ya selile kurupapuro, irimo umurongo. Niba hari byinshi nkibyo, noneho urashobora kandi gukoresha imirongo ya "Umubare" "," Nyuma yamakuru yose akorwa, kanda kuri buto "OK".
- Nkuko mubibona, nyuma yibi bikorwa bibarwa. Ibisubizo byo kubara ingano ya itandukaniro na serishi nkuru irerekanwa mu kagari kateganijwe mbere. Ubu ni selile aho formula yishami iri.
Isomo: Master of Imikorere muri Excel
Uburyo 2: Icyitegererezo cyo kubara
Bitandukanye no kubara agaciro ukurikije rusange, murwego rwo kubara icyitegererezo, ntabwo ari umubare wimibare, ariko imwe cyane. Ibi bikorwa kugirango ukosore amakosa. Excel azirikana uyu mutungo mubikorwa bidasanzwe, bigenewe ubu bwoko bwo kubara - Dis.v. Syntax yayo ihagarariwe na formula ikurikira:
= D (Umubare1; Umubare2; ...)
Umubare w'impaka, nko mu mirimo ibanza, nazo zishobora guhinduka kuva 1 kugeza 255.
- Turagaragaza selile kandi muburyo bumwe nkigihe cyashize, dushyize mu bikorwa imirimo yimikorere.
- Mu cyiciro "Urutonde rw'Imyandikire yuzuye" cyangwa "imibare" bashaka izina "Dis.v.". Nyuma ya formula iraboneka, tuyitanga kandi tukakanda kuri buto "OK".
- Imikorere yimikorere yatangijwe. Ibikurikira, dukora byuzuye muburyo busa, nkigihe ukoresheje umukoresha wabanjirije: Twashizeho indanga muri "Umubare wo gutongana" no guhitamo agace kirimo umurongo ku rupapuro. Hanyuma ukande kuri buto "OK".
- Ibisubizo byo kubara bizakurwaho mu kagari gatandukanye.
Isomo: Ibindi bikorwa byibarurishamibare muri Excel
Nkuko mubibona, gahunda ya Excel irashobora koroshya kubara kubirata. Agaciro kabarurishamibare karashobora kubarwa na porogaramu, haba kubaturage muri rusange nicyitegererezo. Muri iki kibazo, ibikorwa byose byabakoresha biragabanuka gusa byerekana gusa umubare wimibare itunganijwe, kandi umurimo nyamukuru wa Excel ukora. Birumvikana, bizarokora umubare munini wumukoresha.