Nigute wahisha formula muri excel

Rimwe na rimwe, iyo bikora inyandiko hamwe no kubara, umukoresha akeneye guhisha formula kuva mumaso yamahanga. Mbere ya byose, ibikenewe nkibi biterwa no kwanga umukoresha, kugirango umuntu utazi yumva imiterere yinyandiko. Gahunda ya Excel ifite amahirwe yo guhisha amarendi. Tuzumva uburyo ibi bishobora gukorwa muburyo butandukanye.

Inzira zo guhisha formula

Ntabwo ibanga niba niba hari formula iri mumeza ya Excel, irashobora kugaragara mumurongo wa formula igaragaza gusa iyi selire. Mubibazo bimwe, ibi birafunzwe. Kurugero, niba umukoresha ashaka guhisha amakuru kubyerekeye imiterere yo kubara cyangwa gusa ntabwo ushaka ko iyi mibare ihinduka. Muri iki kibazo, ibikorwa byumvikana bizahisha imikorere.

Hariho inzira ebyiri zingenzi zo kubikora. Iya mbere muribo ni uguhisha ibikubiyemo, inzira ya kabiri irakabije. Iyo uyikoresha, kubuza gutoranya selile.

Uburyo 1: Guhisha ibirimo

Ubu buryo buhuye neza nimirimo yatanzwe muri iyi ngingo. Iyo uyikoresha, gusa ibikubiye muri selile birahishe, ariko nta yindi mbogamizi zashyizweho.

1. Turagaragaza intera, ibikubiyemo ukeneye kwihisha. Kanda iburyo ahanditse. Ibikubiyemo bifungura. Hitamo ikintu "imiterere ingirabuzimafatizo". Urashobora gukora ukundi. Nyuma yo guhitamo intera, gusa na ctrl + 1 urufunguzo kuri clavier. Igisubizo kizaba kimwe.



2. Idirishya "selire" rifungura. Jya kuri "Kurinda". Shyiramo amatiku hafi ya "Hisha formulaire". Tike kuva kuri "Cell Coxt" irashobora gukurwaho niba udateganya guhagarika incamake. Ariko, kenshi, kurinda impinduka ni umurimo w'ingenzi, kandi kwihisha formulaire birashoboka. Kubwibyo, mubihe byinshi, amatiku yombi asigaye akora. Kanda kuri buto ya "OK".



3. Nyuma yidirishya rifunze, jya kuri tab "isubiramo". Tugasinda kuri buto "Kurinda Urupapuro" muri "Guhindura ibikoresho" kuri kaseti.
4. Idirishya rifungura, mu murima ushaka kwinjira ijambo ryibanga ridasanzwe. Bizatera niba ushaka gukuraho uburinzi mugihe kizaza. Ibindi bikoresho byose birasabwa kuva muri decial. Noneho ugomba gukanda kuri buto "OK".



5. Irindi idirishya rifungura, aho ijambo ryibanga ryakozwe mbere rigomba kongera guhamagara. Ibi bikorwa kugirango uyikoresha, kubera gutangiza ijambo ryibanga ritari ryo (urugero, mu miterere yahinduwe), ntabwo yatakaje uburyo bwo guhindura urupapuro. Kandi, nyuma yo kwinjira mumvugo y'ingenzi, kanda buto "OK".

Nyuma yibi bikorwa, formula izahishwa. Muburyo bwumurongo wurwego rurinzwe, mugihe cyo kugatana kwabo, ntakintu kizerekanwa.

Uburyo 2: Kubuza guhitamo selile

Ubu ni inzira ikomeye. Gusaba kwayo gushiraho kutabuza gusa ibitekerezo cyangwa guhinduranya selile, ahubwo no kugatangwa.

1. Mbere ya byose, ugomba kugenzura niba agasanduku kashyizwe hafi ya "Celld" muri "Kurinda" bya tab ya mbere yurwego rwatoranijwe rwatoranijwe. Mburabuzi, ibi bigize byagombaga gufungurwa, ariko ntibibuza imiterere. Niba bikiri muri iki gika ntakimenyetso, noneho bigomba gushyirwa. Niba byose ari byiza, kandi byashyizweho, hanyuma ukande buto "OK" hepfo yidirishya.



2. Byongeye kandi, nkuko bimeze mu rubanza rwabanje, twongeyeho "kurinda urupapuro" ruherereye kuri tab.
3. Mu buryo nk'ubwo, idirishya ryibanga ryibanga rifungura inzira ibanza. Ariko iki gihe dukeneye kuvana agasanduku kuva "kugenera ingirabuzimafatizo zahagaritswe" ibipimo. Rero, tuzabuza kurangiza ubu buryo ku buryo bwihariye. Nyuma yibyo, andika ijambo ryibanga hanyuma ukande buto "OK".



4. Mu idirishya rikurikira, nkigihe cyanyuma, subiramo ijambo ryibanga hanyuma ukande buto ya "OK".

Noneho, ku gice cyatoranijwe mbere cyurupapuro, ntituzashobora gusa kureba ibiri mumikorere muri selile, ahubwo birabatanga. Iyo ugerageje guhitamo, ubutumwa buzagaragara ko intera irinzwe guhinduka.

Noneho, twasanze tuzimya kwerekana imirimo muri formula kumurongo no mu kagari mugari muburyo bubiri. Hamwe nibikoresho bisanzwe, formulane gusa byihishe, nkikintu cyinyongera, urashobora gushiraho kubuza. Uburyo bwa kabiri bisobanura kuba haribira bikabije. Iyo ikoreshwa, ntabwo yahagaritswe gusa ubushobozi bwo kureba ibiri cyangwa guhindura, ahubwo ni uguhitamo selile. Ninde muri aba mahitamo yombi biterwa, mbere ya byose, uhereye kubikorwa byashyizweho. Ariko, mubihe byinshi, ihitamo ryambere ryemeza urwego rwizewe ruhagije rwo kurinda, kandi guhagarika isohoka akenshi ni urugero rukabije.