Indlela yokubala inani lamagugu kukholamu ye-Excel

Kwezinye izimo, umsebenzisi usethelwe emsebenzini wokungabala inani lamanani kwikholamu, kepha abala ubungako bawo. Lokho wukuthi, ukumane nje ukhulume, udinga ukubala ukuthi amaseli amangaki kule kholamu agcwele ngenombolo ethile yezinombolo noma yombhalo. Ku-Excel, kunamathuluzi amaningi akwazi ukuxazulula inkinga ecacisiwe. Cabanga ngawo ngawodwana.

Njengoba sibona, ngokungafani nendlela edlule, le ndlela iphakamisa ukukhipha umphumela ibe yinto ethile yeshidi ngokugcina lapho. Kepha, ngeshwa, umsebenzi we-akhawunti akavumeli ukubeka imibandela yokukhethwa kwamanani.

Isifundo: Imisebenzi yeWizard ku-Excel

Indlela 3: I-ACCOUNT

Usebenzisa opharetha, i-akhawunti ingabalwa kuphela ngamanani wezinombolo kwikholamu ekhethiwe. Akunaki amanani wombhalo futhi akubafaki kubo ngomphumela ojwayelekile. Lesi sici futhi sibhekisela esigabeni sabasebenza bezibalo, kanye nesokuqala. Umsebenzi wayo ukubala amaseli ebangeni elizinikezele, futhi kithi kukholamu, okuqukethe amanani ezinombolo. I-syntax yalesi sici icishe ifane no-opharetha wangaphambilini:

= I-akhawunti (i-value1; i-value2; ...)

Njengoba ubona, izimpikiswano zenkokhelo kanye ne-akhawunti ziyefana ngokuphelele futhi zimelela izinkomba kumaseli noma amabanga. Umehluko ku-syntax usegameni lo opharetha uqobo.

1. Sigqamisa into ephepheni lapho umphumela uzoboniswa khona. Chofoza isijwayele isithonjana se- "Insert Function".



2. Ngemuva kokuqala iwizadi yemisebenzi, futhi dlulela esigabeni "sezibalo". Ngemuva kwalokho sigqamisa igama elithi "akhawunti" bese uqhafaza inkinobho ethi "KULUNGILE".



3. Ngemuva kokuthi iwindi lokuphikisana le-opharetha lisebenza, i-akhawunti kufanele iqoshwe enkombeni yayo. Kuleli windi, njengasewindini lomsebenzi owedlule, kungavezwa futhi kumasimu angama-255, kepha, njengoba okokugcina, sizodinga eyodwa kuphela yazo ezibizwa ngokuthi "Inani1". Sifaka ikholomu ukuxhumanisa kulo mkhakha, lapho kudingeka sisebenze khona. Sikwenza ngendlela efanayo naleyo nqubo eyenzelwe umsebenzi we-akhawunti: Faka isikhombisi enkundleni bese ukhetha ikholomu yetafula. Ngemuva kokuthi ikheli lekholomu lalibhalwe ensimini, chofoza inkinobho ethi "Kulungile".



4. Umphumela uzokhishwa ngokushesha esitokisini, esasichaza ngokuqukethwe komsebenzi. Njengoba ukwazi ukubona, uhlelo lubalwa kuphela amaseli aqukethe amanani ezinombolo. Amangqamuzana angenalutho nezinto eziqukethe idatha yombhalo azibamba iqhaza ekubalweni.

Isifundo: I-Akhawunti Yomsebenzi ku-Excel

Indlela 4: Umkhandlu we-Operator

Ngokuphikisana nezindlela zangaphambilini, ukusetshenziswa ko-opharetha wesevisi kukuvumela ukuthi ucacise imibandela ehlangabezana namanani azobamba iqhaza ekubalweni. Onke amanye amaseli azonakwa.

U-opharetha welungu ubuye wabalwa njengeqembu le-Excel Statistical Group. Kuwukuphela komsebenzi ukubala izinto ezingezona ezingezinhle ebangeni, futhi kithi kukholamu ehlangabezana nesimo esibekiwe. I-syntax yalo opharetha ihlukile ngokumakiwe emisebenzini emibili edlule:

= Amashejuli (ibanga; inqubomgomo)

Ingxabano "Uhla" lwethulwa ngendlela yokubhekisela kuhlu oluthile lwamaseli, futhi kithi kwikholamu.

Ingxabano "yokuphikisana" iqukethe isimo esinikeziwe. Lokhu kungaba yinhlangano eqondile noma yombhalo kanye nenani elishiwo yizimpawu "ezinkulu" (>), "ngaphansi" (

Sibala ukuthi mangaki amaseli anegama elithi "inyama" atholakala kwikholamu lokuqala etafuleni.

1. Sigqamisa into eshidini lapho kukhonjiswa khona idatha eyenziwe ngomumo. Chofoza isithonjana se- "Insert Function".



2. Emisebenzini Wizard, senza ukuguqukela esigabeni "sezibalo", sabela igama le-celtekenele bese sichofoza inkinobho ethi "KULUNGILE".



3. Ukwenza kusebenze kwezimpikiswano zezimpikiswano zomsebenzi we-metha kwenziwa. Njengoba ubona, iwindi linamasimu amabili ahambelana nokuphikisana komsebenzi.

   Ensimini "ibanga" ngendlela efanayo, esivele sichaze kaninginingi, sethula izixhumanisi zekholomu yokuqala yetafula.

   Ensimini ethi "Criterion", sidinga ukucacisa isimo sokubala. Faka igama elithi "inyama" lapho.

   Ngemuva kokuthi izilungiselelo ezingenhla zenziwe, chofoza inkinobho ethi "Kulungile".



4. U-opharetha wenza ukubala futhi anikeze umphumela esikrinini. Njengoba ukwazi ukubona, kukholamu ekhethiwe kumaseli angama-63, igama elithi "inyama" liqukethe.

Ake sishintshe umsebenzi kancane. Manje sibheka inani lamaseli kwikholomu efanayo engaqukethe igama elithi "inyama".

1. Sikhetha iseli lapho sizokhipha khona, kanye nendlela echazwe ngaphambilini esiyibiza ngokuthi izimpikiswano ze-opharetha.

   Ensimini ethi "Range", sethula izixhumanisi zekholomu efanayo yetafula, eyayicutshungulwa ngaphambili.

   Ensimini ethi "Criterion", sethula le nkulumo elandelayo:

   Inyama

   Okusho ukuthi, le nqubo icacisa isimo sokuthi sibala zonke izinto ezigcwele idatha engekho igama elithi "inyama". Isibonakaliso "" sisho ukuthi ku-Effelle "akulingani."

   Ngemuva kokufaka lezi zilungiselelo ewindini lokuphikisana, cindezela inkinobho ethi "Kulungile".



2. Esitokisini esethiwe ngokushesha kubonisa umphumela. Ubika ukuthi kwikholamu egqanyisiwe Kunezinto eziyi-190 nedatha engekho igama elithi "inyama".

Manje ake sikhiqize kwikholamu yesithathu yaleli thebula libala wonke amanani angaphezu kwenombolo 150.

1. Sigqamisa iseli ukukhombisa umphumela futhi senze ushintsho ezimpikiswaneni zomsebenzi womsebenzi.

   Ensimini ethi "Range", sethula izixhumanisi zekholamu yesithathu yetafula lethu.

   Ensimini ethi "Criterion", bhala lesi simo esilandelayo:

   > 150.

   Lokhu kusho ukuthi uhlelo luzobala kuphela izinto zekholomu eziqukethe izinombolo ezidlula ezi-150.

   Ngaphezu kwalokho, njengoba kwenzeka njalo, cindezela inkinobho ethi "Kulungile".



2. Ngemuva kokubala i-Excel kukhombisa umphumela osesitokisini esinqunyelwe kusengaphambili. Njengoba sibona, ikholomu ekhethiwe iqukethe amanani angama-82 adlula inombolo engu-150.

Ngakho-ke, siyakubona lokho ku-Excel kunezindlela eziningi zokubala inani lamagugu kukholamu. Ukukhetha inketho ethile kuya ngezinhloso ezithile zomsebenzisi. Ngakho-ke, inkomba kubha yesimo ivumela ukubona inani lawo wonke amanani kukholamu ngaphandle kokulungisa umphumela; Umsebenzi we-akhawunti unikeza amandla okuzilungisa esitokisini esihlukile; I-akhawunti opharetha ibala kuphela izinto eziqukethe idatha yezinombolo; Futhi ngomsebenzi wosizo, ungasetha izimo zokubala eziyinkimbinkimbi zezakhi.