Susa ifomula ku-Microsoft Excel

Ukusebenza ngamafomula ku-Excel kukuvumela ukuthi wenze lula futhi ulungise izibalo ezihlukahlukene. Nokho, akudingeki ngaso sonke isikhathi ukuthi umphumela ufakwe enkulumweni. Isibonelo, uma ushintshe amanani kumaseli ahlobene, idatha ephumelayo izoshintsha, futhi kwezinye izimo lokhu akudingekile. Ngaphezu kwalokho, uma udlulisela ithebula elikopishiwe ngefomula kwenye indawo, amanani angase "alahleke". Esinye isizathu sokuzifihla kungaba isimo lapho ungafuni abanye abantu ukuba babone ukuthi izibalo zenziwa kanjani etafuleni. Ake sithole ukuthi yiziphi izindlela ongasusa ngayo ifomula emasethini, ushiye kuphela imiphumela yezibalo.

Inqubo yokususwa

Ngeshwa, ku-Excel akukho thuluzi elizosusa amafomula amasheya masinyane, kodwa ushiye amanani kuphela lapho. Ngakho-ke kubalulekile ukubheka izindlela eziyinkimbinkimbi zokuxazulula le nkinga.

Indlela 1: Kopisha Amanani Ukusebenzisa Izinketho Zokunamathisela

Ungakopisha idatha ngaphandle kwefomula kwenye indawo usebenzisa imingcele yokufaka.

1. Khetha ithebula noma ububanzi, esiphikisana nayo ngesikhombisi ngenkinobho yegundane lesokunxele egcinwe phansi. Ukuhlala kuthebhu "Ikhaya", chofoza kusithonjana "Kopisha"okuyinto ifakwe kwi-tape block "Ibhodi lokunamathisela".



2. Khetha iseli ezoba iseli eliphezulu lesokunxele etafuleni efakwe. Yenza ngokuchofoza kukho inkinobho yegundane efanele. Imenyu yesimo izosebenza. Ku-block "Izinketho zokufaka" yeka ukukhetha entweni "Amanani". Ivela ngesimo se-pictogram ngesithombe sezinombolo. "123".

Ngemuva kokusebenzisa le nqubo, ububanzi buzofakwa, kodwa kuphela njengamaxabiso ngaphandle kwamafomula. Yiqiniso, ukufometha kwasekuqaleni kuzolahleka. Ngakho-ke, kubalulekile ukufometha ithebula ngesandla.

Indlela 2: ukukopisha ukufakwa okukhethekile

Uma udinga ukugcina ukufometha kwasekuqaleni, kodwa awufuni ukuchitha isikhathi ekusebenziseni ithebula, bese kungenzeka ukuthi lezi zinhloso zisebenzise "Namathisela Okukhethekile".

1. Sikopisha ngendlela efanayo ekugcineni kokuqukethwe kwetafula noma ibanga.
2. Khetha yonke indawo yokufaka noma iseli layo eliphezulu elingakwesokunxele. Senza ukuchofoza kwesokudla kwegundane, ngaleyo ndlela sisha imenyu yesimo. Kulolu hlu oluvula, khetha into "Namathisela Okukhethekile". Ngaphezu kwalokho kwimenyu eyengeziwe chofoza inkinobho. "Izimiso nokufometha kwasekuqaleni"okubanjwe eqenjini "Faka amanani" futhi i-pictogram ngendlela yesigcawu, ekhombisa izinombolo kanye nebhashishi.

Ngemva kwalokhu kusebenza, idatha izokopishwa ngaphandle kwamafomula, kodwa ukufometha kwasekuqaleni kuzogcinwa.

Indlela yesithathu: Susa i-Formula kusuka kuthebula lomthombo

Ngaphambi kwalokho, sikhulume ukuthi singasusa kanjani ifomula uma sikopisha, futhi manje masithole ukuthi singakususa kanjani ebangeni lokuqala.

1. Senza itafula ukukopisha nganoma iyiphi yalezo zindlela, ezikhulunywe ngenhla, endaweni engenalutho lephepha. Ukuzikhethela indlela ethile kulokhu kungasabalulekile.
2. Khetha ibanga elikopishiwe. Chofoza inkinobho "Kopisha" kwi-tape.



3. Khetha ububanzi bokuqala. Chofoza kuso nge inkinobho yegundane kwesokudla. Kuhlu lomongo eqenjini "Izinketho zokufaka" khetha into "Amanani".



4. Ngemuva kwedatha efakiwe, ungasusa isigaba sokuhamba. Khetha it. Shayela imenyu yesimo ngokuchofoza inkinobho yesokudla yegundane. Khetha into kuwo "Susa ...".



5. Iwindi elincane livuleka lapho kudingeka khona ukuthi unqume ukuthi yikuphi okudingeka ukuthi kususwe. Esikhathini sethu esithile, ibanga lokuhamba lihamba ngaphansi kwetafula langempela, ngakho-ke sidinga ukususa imigqa. Kodwa uma ikhona eceleni kwayo, kuzodingeka ukuthi ususe amakholomu, kubalulekile ukuthi ungawudibanisi lapha, ngoba kungenzeka ukubhubhisa itafula eliyinhloko. Ngakho, setha izilungiselelo zokususa bese uchofoza inkinobho. "Kulungile".

Ngemva kokwenza lezi zinyathelo, zonke izakhi ezingadingekile zizosuswa, futhi amafomula avela kuthebula lomthombo ayophela.

Indlela 4: susa amafomu ngaphandle kokudala ibanga lokuhamba

Ungenza kube lula futhi ngokuvamile ungakha ibanga lokuhamba. Kodwa-ke, kulokhu, udinga ukwenza ngokucophelela ngokucophelela, ngoba zonke izenzo zizokwenziwa ngaphakathi kwetafula, okusho ukuthi noma yikuphi iphutha lingaphula ubuqotho bemininingwane.

1. Khetha ibanga ofuna ukususa ifomula. Chofoza inkinobho "Kopisha"efakwe kutheyipu noma ukuthayipha inhlanganisela eyinhloko ekhibhodi Ctrl + C. Lezi zenzo zilingana.



2. Khona-ke, ngaphandle kokukhipha ukhetho, chofoza ngakwesokudla. Iqala imenyu yokuqukethwe. Ku-block "Izinketho zokufaka" chofoza kusithonjana "Amanani".

Ngakho, yonke idatha izokopishwa futhi ifakwe ngokushesha njengamanani. Emva kwalezi zenzo, amafomula endaweni ekhethiwe ngeke ahlale.

Indlela 5: Ukusebenzisa i-Macro

Ungasebenzisa futhi ama-macros ukususa amafomula kusuka kumaseli. Kodwa ngenxa yalokhu, kumele uqale usebenze ithebhu yonjiniyela, futhi unike amandla umsebenzi we-macros ngokwayo, uma engasebenzi. Indlela yokwenza lokhu ingatholakala kusihloko esihlukile. Sizokhuluma ngokuqondile ngokufaka nokusebenzisa i-macro ukususa amafomula.

1. Iya kuthebhu "Unjiniyela". Chofoza inkinobho "Visual Basic"efakwe kutheyipu ebhodini lamathuluzi "Ikhodi".



2. Umhleli we-macro uqala. Namathisela ikhodi elandelayo kuyo:

   
Sub Susa amafomula ()
Ukukhetha.Value = Ukukhetha.Value
Qedela ngaphansi

   Ngemuva kwalokho, vala iwindi lomhleli ngendlela ejwayelekile ngokuchofoza inkinobho ekhoneni elingenhla elingakwesokudla.



3. Siphindela eshadini lapho ithebula lesithakazelo litholakala khona. Khetha isiqeshana lapho amafomula asuswe khona. Kuthebhu "Unjiniyela" cindezela inkinobho Macrosefakwe kutheyipu eqenjini "Ikhodi".



4. Iwindi lokuqalisa elikhulu livuleka. Sifuna isici esibizwa "Susa amafomula"ukhethe bese uchofoza inkinobho Qalisa.

Ngemuva kwalesi senzo, wonke amafomula endaweni ekhethiwe azosuswa, futhi kuphela imiphumela yokubala izosala.

Isifundo: Unganika amandla noma ukhubaza ama-macros ku-Excel

Isifundo: Indlela yokudala i-macro ku-Excel

Indlela 6: Susa ifomula ngomphumela

Noma kunjalo, kunezimo lapho kudingeka khona ukususa hhayi kuphela ifomula, kodwa futhi nomphumela. Yenza kube lula nakakhulu.

1. Khetha ibanga lapho amafomula atholakala khona. Chofoza inkinobho yesokudla yegundane. Emenyu yomongo, yeka ukukhethwa kwento "Sula okuqukethwe". Uma ungafuni ukubiza imenyu, ungamane ucindezele ukhiye ngemva kokukhethwa Susa kwikhibhodi.



2. Ngemva kwalezi zenzo, konke okuqukethwe kwamaseli, kufaka phakathi amafomula namagugu, kuzosuswa.

Njengoba ubona, kunezindlela eziningi ongasusa amafomula, kokubili uma ukopisha idatha, futhi ngqo etafuleni uqobo. Iqiniso, ithuluzi elivamile le-Excel elizosusa ngokuzenzekelayo inkulumo ngokuchofoza okukodwa, ngeshwa, ayisekho. Ngale ndlela, amafomula kuphela namanani angasuswa. Ngakho-ke, kufanele wenze ngezindlela ezihlukile ngokusebenzisa imingcele yokufaka noma ukusebenzisa ama-macros.