Imvamisa, phambi kwabasebenzisi bomhleli wethebula, umbuzo uphakama okuhlobene nokubala inani lezinkomba kwikholamu. Ngamanye amagama, kuyadingeka ukubala inani lamasimu kwikholamu eligcwele umbhalo othize noma imininingwane yezinombolo. Isihleli setafula sinokuhlukahluka okuningi okuvumela ukuthi wenze lesi sici.
Inqubo yokubala kwikholamu
Ngokuya ngezinhloso zomsebenzisi esihlotsheni setafula, ungasebenzisa ukubala kwayo yonke imininingwane kwikholomu. Sizohlaziya indlela ngayinye ngemininingwane eminingi.
Indlela 1: Ibonisa inani lamanani kubha yesimoLe ndlela ilula ukuyisebenzisa. Isebenzisa ukubala imininingwane yezinombolo kanye nemibhalo, kepha ayikwazi ukusetshenziswa lapho usebenza nemibandela. I-General Action algorithm:
- Khetha indawo edingekayo yedatha.
- Sibheke emugqeni wombuso.
- Sifunda inani lamagugu.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_1](/userfiles/21/11232_1.webp)
Indlela elula ukuyisebenzisa kuphela uma usebenza nge-aughtage yedatha, uma kungenjalo udinga ukusebenzisa ezinye izinketho. Enye indlela yendlela - umphumela ubonakala kuphela ngesikhathi sokuhlukaniswa, ngakho-ke udinga ukususwa noma ngekhanda noma ukulungiswa kwenye indawo. Umhlahlandlela wesinyathelo ngesinyathelo sokufaka inkomba "yenombolo":
- Chofoza i-PCM kubha yesimo.
- Isikrini sibonisa uhlu. Lapha kubalulekile ukubheka ukuthi ngabe uphawu lumayelana nepharamitha "yenani". Uma kungenjalo, khona-ke kufanele kufakwe ngokuchofoza inkinobho yegundane kwesobunxele.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_2](/userfiles/21/11232_2.webp)
- Silungele! Manje inkomba "yenombolo" isendaweni yesimo se-processor yetafula.
Lo opharetha ufaka into efanayo nendlela edlule, kepha ngasikhathi sinye ngaphezu kwalokho alungisa umphumela. Amanye amaphutha asele, ngoba ukusebenza kwe-invoice akunakusebenza nemibandela.
Kunezinhlobo ezimbili ezivamile zo-opharetha:
- = Ibha (cell1; cell2; ... iseli).
- = Blossom (cell1: iseli).
Ngefomu le-1, opharetha abalwa iseli ngalinye elikhethiwe. Ngefomu lesi-2, inani lezinkambu ezigcwalisiwe libalwa ebangeni kusuka kwinombolo yeseli 1 kuya esitokisini ngenombolo N. Isinyathelo ngesinyathelo ngesinyathelo:
- Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
- Ukuhamba esigatshaneni "amafomula". Chofoza u- "Faka umsebenzi."
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_3](/userfiles/21/11232_3.webp)
- Inketho ehlukile - Ukucindezela isithonjana esithi "Insert Function", esitholakala eduze komugqa weqoqo lamafomula.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_4](/userfiles/21/11232_4.webp)
- Imisebenzi emincane "yokufaka" yavela esikrinini. Vula uhlu olutholakala eduze kwesigaba "sesigaba" esibhaliwe. Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha Umsebenzi:" Insimu, sithola opharetha we-invoice bese uchofoza kuwo yi-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_5](/userfiles/21/11232_5.webp)
- Isibonisi sibonisa iwindi ukubhala ama-opharetha okuphikisana. Lapha kuyadingeka ngokudlulisa amaseli noma ibanga lokufaka ukusetha izimpikiswano. Kuyaqapheleka ukuthi ibanga lingasethwa ngesihloko. Ngemuva kwakho konke ukukhohlisa, chofoza entweni ethi "Kulungile", etholakala ezansi kwewindi.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_6](/userfiles/21/11232_6.webp)
- Silungele! Ngenxa yalokho, sathola umphumela wokubala esitokisini esinqunyelwe kusengaphambili. Kucatshangelwe ngokuphelele sonke iseli eligcwele eligcwele.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_7](/userfiles/21/11232_7.webp)
I-akhawunti ilungele ukusebenza ngezinkomba zamanani. Kunezinhlobo ezimbili ezivamile zo-opharetha:
- = I-akhawunti (cell1; cell2; ... iseli).
- = I-Akhawunti (iseli1: iseli).
Isiqondisi Sokuma kwesinyathelo:
- Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
- Ukuhamba esigatshaneni "amafomula". Chofoza entweni ethi "Faka umsebenzi". Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba esithi "isigaba" esibhaliwe. Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha Umsebenzi:" Insimu, sithola i-akhawunti opharetha bese sichofoza kuwo nge-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_8](/userfiles/21/11232_8.webp)
- Iwindi lezimpikiswano ligcwalisa izixhumanisi zamaseli adingekayo. Ngemuva kwakho konke ukukhohlisa, chofoza entweni ethi "Kulungile", etholakala ezansi kwewindi.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_9](/userfiles/21/11232_9.webp)
- Silungele! Ngenxa yalokho, sathola umphumela wokubala esitokisini esinqunyelwe kusengaphambili. Lapha kubhekwa amaseli agcwele ama-akhawunti, ngaphandle kokungenalutho naleyo lapho imininingwane yombhalo itholakala khona.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_10](/userfiles/21/11232_10.webp)
Lo osebenza ngo-opharetha ukuvumela ukubala inani lamanani wemibandela ethile. Ukubukwa okujwayelekile kopharetha: = 8 (Range; inqubomgomo).
- Ububanzi - Lokhu kukhombisa indawo okudingeka ukubala inani lenhlamvu ngesimo esithile.
- Isikhombisi yisimo lapho okwenzeka khona okuzohlukaniswa khona.
Sizohlaziya konke esibonelweni esithile. Isiqondisi Sokuma kwesinyathelo:
- Isibonelo, sizonquma inani legama elithi "Running" kwikholamu nezemidlalo. Ukuhamba emkhakheni ozowubonisa kuyo.
- Ukuhamba esigatshaneni "amafomula". Chofoza entweni ethi "Faka umsebenzi". Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba "Sokubhaliwe:". Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha umsebenzi:" Insimu, sithola opharetha bese sichofoza kuwo nge-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_11](/userfiles/21/11232_11.webp)
- Isikrini sivela "izimpikiswano zomsebenzi". Kulayini wobubanzi, sethula izixhumanisi zamaseli abambe iqhaza ekubalweni. Emgqeni "Criterion" sibuza isimo uqobo. Shayela lapha: "Run". Ngemuva kokwenza konke ukusebenzisana, chofoza kwinto ethi "Kulungile".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_12](/userfiles/21/11232_12.webp)
- I-opharetha ibalwe futhi ikhombise inani lenhlamvu ensimini egqanyisiwe ngegama elithi "run". Sinezinhlobonhlobo eziyishumi nesithupha.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_13](/userfiles/21/11232_13.webp)
Ake sizame ukuhlela isimo ukuze siqonde kangcono umsebenzi we-opharetha. Isiqondisi Sokuma kwesinyathelo:
- Masenze ukubala amanye amanani kule kholamu, ngaphandle kwenani elithi "Run".
- Siphinda iphuzu lesibili kusuka ekufundisweni okungenhla.
- Emgqeni wobubanzi, sifaka amakheli afanayo nakulesi sibonelo esingenhla. Kulayini "Criterion" Sishayela uphawu lokungalingani "" ngaphambi kwenani elithi "run". Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_14](/userfiles/21/11232_14.webp)
- Ngenxa yalokho, sathola inqwaba yakwa-Seven - inani lamagama kwikholamu elikhethiwe ngaphandle kokucabanga igama elithi "Running".
Ekupheleni kokucatshangelwa kwendlela, sithola ukuthi opharetha basebenza kanjani nemibandela lapho izinhlamvu ">" kanye "
- Usebenzisa imiyalo engenhla, faka opharetha ukubheka iseli elidingekayo.
- Kulayini wobubanzi, sifaka izixhumanisi ezidingekayo zamaseli kaSomlomo. Emugqeni we- "Criterion", faka inani "> 350". Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_15](/userfiles/21/11232_15.webp)
- Ngenxa yalokhu, sathola inani leshumi - inani lezinombolo likhulu kune-350 kukholamu ekhethiwe.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_16](/userfiles/21/11232_16.webp)
Sizohlaziya esinye isibonelo sokuqonda okuphelele komsebenzi we-opharetha. Isibonelo, sinamamaki alandelayo anemininingwane yokuthengisa:
17.Injongo: Thola ukuthi zingaki izimpahla ezithengiswayo ziyimikhiqizo evela kwa-Samsung. Sisebenzisa ifomula elandelayo: = C3: C17; "Samsung") / A17. Ngenxa yalokho, sithola umphumela ka-40%:
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_17](/userfiles/21/11232_17.webp)
Khuluma ngezinye izici zo-opharetha:
- Irejista yezimpawu ayinandaba ukuthi ngabe umugqa wezinhlobo zemibhalo wahlelwa njengendlela yokufunda;
- Umphumela wokubala uzoba zero uma kubhekiswa kwiseli elingenalutho noma kulayini ongenalutho kuzokwethulwa njengesikhombisi;
- U-opharetha ungafakwa njengefomula yamalungu, lapho inani lamaseli anolwazi oluhambisana nemibandela eminingana luzokwenzeka.
I-opharetha iyafana nomsebenzi oshiwo ngenhla. Kuhluka ngoba kukuvumela ukuthi ungeze inombolo ethile yamabanga anezimo ezahlukahlukene noma ezifanayo. Isibonelo, kudingeka sibala inani lemikhiqizo ethengiswa ngenani lezingcezu ezingaphezu kwamakhulu amathathu. Ngokwengeziwe, kuyadingeka ukubala ukuthi intengo yomkhiqizo idlula inani lama-ruble ayizinkulungwane eziyisithupha. Isiqondisi Sokuma kwesinyathelo:
- Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
- Ukuhamba esigatshaneni "amafomula". Chofoza u- "Faka umsebenzi." Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba esithi "isigaba" esibhaliwe. Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha umsebenzi:" Insimu, sithola isinali opharetha bese sichofoza kukho nge-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_18](/userfiles/21/11232_18.webp)
- Iwindi elisijwayele ngaphansi kwegama elithi "Izimpikiswano Zokusebenza" kwavela. Lapha, lapho ungena esimweni esisodwa, kuvela umugqa omusha ngokushesha ukugcwalisa esinye isimo. Kulayini "Range 1", sishayela ikheli lekholomu lapho imininingwane yokuthengisa itholakala khona. Emugqeni "Isimo 1", sishayela inkomba "> 300". Kulayini "Range 2", shayela ikheli lekholomu lapho imininingwane yezindleko itholakala khona. Emugqeni we- "Isimo 2", engeza inani "> 6000". Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_19](/userfiles/21/11232_19.webp)
- Ngenxa yalokhu, sathola umphumela okhombisa ukuthi yimaphi amaseli alungele ukwakheka kwezimo ezifakiwe. Sithole inani leshumi nane.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_20](/userfiles/21/11232_20.webp)
Inketho elandelayo ikuvumela ukubala inani lamaseli angenalutho. Ukusebenzisa le nqubo, kulungele ngokuphelele. Ukubukwa okujwayelekile kopharetha: = Ukuhlanza (ibanga). Isiqondisi Sokuma kwesinyathelo:
- Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
- Ukuhamba esigatshaneni "amafomula". Chofoza entweni ethi "Faka umsebenzi". Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba "Sokubhaliwe:". Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha umsebenzi:" Insimu, sithola opharetha ukuze ahlanze futhi achofoze kuyo yi-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_21](/userfiles/21/11232_21.webp)
- E "Ukuphikisana komsebenzi" kwavela, sishayela izixhumanisi ezidingekayo zamaseli, bese uqhafaza kwinto ethi "Kulungile".
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_22](/userfiles/21/11232_22.webp)
- Ngenxa yalokho, sathola umphumela lapho inani lamaseli angenalutho lizokhonjiswa.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_23](/userfiles/21/11232_23.webp)
Ukubala Amanani Emibhalo Ehlukile ku-MS Excel
Isibonelo, cabanga ngesibonakaliso esilandelayo:25.Injongo: Bala inani lamapharamitha wombhalo ahlukile ku-A7: A15. Ukuze wenze lokhu, sisebenzisa ifomula: = i-sumpy ((A7: A15 "") / 8: A7: A15; A15)).
Ungawathola kanjani amanani aphindaphindayo ku-Excel.
Isibonelo, sinepuleti elilandelayo:
26.Ukubala amanani aphindaphindwayo, kuyadingeka ukwethula ifomula elandelayo ku-G5: = Uma (ne- $ 5: a5: A5)> A5; A5; A5); 1). Ngemuva kwalokho udinga ukukopisha le formula kuyo yonke ikholomu.
Bala inani lamanani aphindaphindwayo kwikholomu
Ukuze ubale inani elidingekayo lokuphindwa kabili kukholamu, kufanele wenze okulandelayo:
- Sebenzisa sonke isibonakaliso esifanayo esibonelweni esingenhla. Sikhiqiza ukukhethwa kwamangqamuzana ekholomu.
- Hlanganisa ngendlela yokufometha.
- Ku- "Khetha Indlela Yesici:" Inkambu, chofoza into "Sebenzisa ifomula ukuthola amaseli aphathelene".
- Emgqeni "format formula ukunquma amaseli ezinsizakusebenza", drive = 8 ($ a: $ a5 a; A5)> 1.
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_24](/userfiles/21/11232_24.webp)
- Silungele! Sisebenzise ukubalwa kwezinkomba ezifanayo kwikholamu, futhi sabela kabusha imininingwane ephindaphindwayo kweminye imibala.
Kubalwa inani lenani elithile leseli ku-Excel enikeziwe
Cabanga ngalesi sikhathi esibonelweni esithile. Ake sithi sinalo ipuleti lethebula elilandelayo:
28.Sabela i-E2: E5 Range futhi wethula ifomula: = 8: B3: B19; D2: D5). B3: B19 - Amaseli aqukethe izilinganiso, kanye ne-D2: D5 - amaseli, lapho inqubo itholakala ngokubala inani lezincwadi. Ngenxa yalokho, sithola umphumela onjalo:
![Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel 11232_25](/userfiles/21/11232_25.webp)
Ukugcina
Isihleli sethebula le-Exel wuhlelo olusebenzayo olukuvumela ukuthi uxazulule inani elikhulu lemisebenzi ehlukahlukene. Uhlelo luhlinzeka ngemisebenzi eminingana evumela ukuba ubale inani lamanani kububanzi obucacisiwe. Umsebenzisi ngamunye uzokwazi ukukhetha ngokuzimela indlela elula elungele imisebenzi yakhe.
Umlayezo wokuthi ubala kanjani inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-eksel yavela kuqala kubuchwepheshe bolwazi.