Faka umbhalo esitokisini ngefomula ku-Microsoft Excel

Ngokuvamile, uma usebenza ku-Excel, kunesidingo sokufaka umbhalo ochazayo eduze komphumela wokubala ifomula, okusiza ukuqonda le datha. Yiqiniso, ungakhetha ikholomu ehlukile yezincazelo, kodwa hhayi kuzo zonke izimo ezengeze izakhi ezengeziwe zizwakalayo. Noma kunjalo, ku-Excel kunezindlela zokubeka ifomu kanye nombhalo kumakhalekhukhwini owodwa ndawonye. Ake sibone ukuthi lokhu kungenziwa kanjani ngosizo lwezinketho ezahlukene.

Inqubo yokufaka umbhalo eduze kwefomula

Uma uzama nje ukufaka umbhalo esitokisini esifanayo nomsebenzi, khona-ke kulo mzamo i-Excel izobonisa umlayezo wephutha kwifomula futhi ngeke ikuvumele ukuba ufake lokho. Kodwa kunezindlela ezimbili zokufaka umbhalo eceleni kwenkulumo yefomula. Owokuqala ukusebenzisa i-ampersand, kanti okwesibili ukuwusebenzisa Ukudonsa.

Indlela 1: Ukusebenzisa Ampersand

Indlela elula yokuxazulula le nkinga ukusebenzisa i-ampersand symbol (&). Lesi sibonakaliso sikhiqiza ukwahlukana okunengqondo kwedatha ifomula iqukethe kusuka enkulumweni yombhalo. Ake sibone ukuthi ungayisebenzisa kanjani le ndlela ngokusebenza.

Sinetafula elincane lapho amakholomu amabili akhombisa izindleko ezihleliwe nezingaguquguquki zebhizinisi. Ikholomu yesithathu iqukethe ifomula yokufaka elula, esifingqa futhi ibangele njengenani. Kudingeka sengeze igama elichazayo ngemuva kwefomula esitokisini esifanayo lapho inani lezindleko liboniswa. "ama-ruble".

1. Yenza kusebenze iseli eliqukethe inkulumo yefomula. Ukwenza lokhu, cindezela kabili kukho inkinobho yegundane lesokunxele, noma ukhethe bese uchofoza ukhiye womsebenzi. F2. Ungase futhi ukhethe ukhethe iseli, bese ufaka isikhombisi kubha yefomula.



2. Masinyane emva kwefomula, faka uphawu lwe-ampersand (&). Ngaphezu kwalokho, ngamacaphuno sibhala igama "ama-ruble". Kulesi simo, izingcaphuno ngeke ziboniswe esitokisini ngemuva kwenombolo eboniswe ifomula. Bavele bakhonze njenge-pointer ohlelweni ukuthi luyombhalo. Ukuze ubonise umphumela esitokisini, chofoza inkinobho Ngena kwikhibhodi.



3. Njengoba ubona, ngemuva kwalesi senzo, ngemuva kwenombolo ukuthi ifomula ibonisa, kunombhalo ochazayo "ama-ruble". Kodwa le nketho ine-backback eyodwa ebonakalayo: incazelo nenombolo yombhalo ihlangene ndawonye ngaphandle kwesikhala.

   

   Ngesikhathi esifanayo, uma sizama ukubeka isikhala ngesandla, ngeke sisebenze. Ngokushesha lapho inkinobho icindezelwe Ngena, umphumela uphinde "unamathele ndawonye."



4. Kodwa kukhona indlela yokuphuma kwimeko yamanje. Nalapha, cindezela iseli equkethe amafomula namagama wombhalo. Ngokushesha ngemva kwe-ampersand, vula izingcaphuno, bese usetha isikhala ngokuchofoza ukhiye ohambelana ekhibhodi, bese uvala izingcaphuno. Emva kwalokho, faka uphawu lwe-ampersand futhi (&). Bese uchofoza Ngena.



5. Njengoba ungabona, manje umphumela wokubala wefomu kanye nenkulumo yombhalo ihlukaniswe isikhala.

Ngokwemvelo, zonke lezi zenzo akusho neze. Sivele sibonise ukuthi ngesingeniso esivamile ngaphandle kwe-ampersand yesibili nokucaphuna isikhala, idatha yefomula kanye nedatha izohlangana. Ungasetha isikhala esifanele ngisho nalapho wenza isigaba sesibili sale ncwajana.

Uma ubhala umbhalo ngaphambi kwefomula, silandela i-syntax elandelayo. Ngokushesha ngemva kwesibonakaliso "=", vula izingcaphuno bese ubhala umbhalo. Ngemuva kwalokho, vala izingcaphuno. Sifaka uphawu lwe-ampersand. Khona-ke, uma kwenzeka udinga ukufaka isikhala, izingcaphuno ezivuliwe, faka isikhala namavesi aseduze. Chofoza inkinobho Ngena.

Ukuze ubhale umbhalo ngomsebenzi, kunokuba ifomula evamile, zonke izenzo zifana ncamashi nezichazwe ngenhla.

Umbhalo ungacaciswa njengesixhumanisi esitokisini lapho sitholakala khona. Kulesi simo, i-algorithm yezenzo ihlala ingalingani, kuphela akudingeki ukuthi uthathe izixhumanisi zeseli kumacaphuno.

Indlela 2: Ukusebenzisa umsebenzi we-CLUTCH

Ungasebenzisa futhi umsebenzi ukufaka umbhalo kanye nomphumela wefomula. Ukudonsa. Lo opharetha kuhloswe ukuhlanganisa amanani aboniswe ezinkathini ezimbalwa zeshidi kwelinye iseli. Yingxenye yesigaba semisebenzi yombhalo. I-syntax yayo ilandelayo:

= CLUTCH (umbhalo1; umbhalo2; ...)

Lo opharetha angase abe nesamba 1 kuze kube 255 yezimpikiswano. Ngamunye wabo umelela umbhalo (kufaka phakathi izinombolo kanye nanoma yiziphi ezinye izinhlamvu), noma izikhombisi zamaseli aqukethe.

Ake sibone ukuthi lo msebenzi usebenza kanjani ekusebenzeni. Isibonelo, ake sithathe itafula elifanayo, faka nje enye ikholomu kuso. "Izindleko Zonke" ngeseli elingenalutho.

1. Khetha i-cell column engenalutho. "Izindleko Zonke". Chofoza kusithonjana "Faka umsebenzi"itholakala ngakwesokunxele kwe-bar yefomula.



2. Ukuqaliswa kwenziwa Amakhosi omsebenzi. Hambisa kusigaba "Umbhalo". Okulandelayo, khetha igama "CLICK" bese uchofoza inkinobho "Kulungile".



3. Iwindi lezingxabano ze-opharetha liqalisiwe. Ukudonsa. Leli festile liqukethe amasimu ngaphansi kwegama "Umbhalo". Inani labo lifinyelela 255, kodwa ngesibonelo sethu sidinga kuphela amasimu amathathu. Eyokuqala, sizobeka umbhalo, okwesibili, isixhumanisi esitokisini esinefomula, futhi okwesithathu sizobeka umbhalo.

   Setha isikhombisi emkhakheni "Umbhalo1". Sibhala igama lapha "Ingqikithi". Ungabhala imibhalo yamagama ngaphandle kwamacaphuno, ngoba lolu hlelo luzowabeka phansi.

   Bese uye ensimini "Umbhalo2". Sabeka isikhombisi lapho. Sidinga ukucacisa lapha ukubaluleka okuboniswa ifomula, okusho ukuthi kufanele sikwazi ukunikeza isixhumanisi kuseli eliqukethe. Lokhu kungenziwa ngokungena nje ekhelini ngesandla, kodwa kungcono ukusetha isikhombisi endle bese uchofoza eselifomu eliqukethe ifomu kushidi. Ikheli lizovela ngokuzenzekelayo efasiteleni lemibono.

   Ensimini "Umbhalo3" faka igama elithi "rubles".

   Emva kwalokho chofoza inkinobho "Kulungile".



4. Umphumela uboniswa kuseli elanduliwe, kodwa, njengoba singabona, njengendlela yangaphambilini, wonke amanani abhaliwe ndawonye ngaphandle kwezikhala.



5. Ukuze sixazulule le nkinga, siphinde sikhethe iseli equkethe opharetha Ukudonsa bese uya kubha yefomula. Lapho emva kwempikiswano ngayinye, okungukuthi, emva kwe-semicolon ngayinye sengeza inkulumo elandelayo:

   " ";

   Kufanele kube khona isikhala phakathi kwamacaphuno. Ngokuvamile, inkulumo elandelayo kufanele ivele kumsebenzi wokusebenza:

   = CLUTCH ("inani"; ""; D2; ""; "ama-ruble")

   Chofoza inkinobho ENTER. Manje izindinganiso zethu zihlukaniswa izikhala.



6. Uma ufisa, ungafihla ikholomu yokuqala "Izindleko Zonke" ngefomula yokuqala, ukuze ingabi nesikhala esiningi kakhulu eshadini. Ukususa nje ngeke kusebenze, ngoba kuzophula umsebenzi Ukudonsa, kodwa kungenzeka ukuthi ususe isici. Chofoza inkinobho yegundane lesokunxele ku-panel yokuxhumanisa yekholomu okufanele ifihlwe. Emva kwalokho, lonke ikholomu ligqanyisiwe. Chofoza ekukhethweni ngenkinobho yegundane efanele. Iqala imenyu yokuqukethwe. Khetha into kuwo "Fihla".



7. Emva kwalokho, njengoba sibona, ikholomu engadingekile ifihliwe, kodwa idatha esitokisini lapho umsebenzi ukhona khona Ukudonsa iboniswe kahle.

Bheka futhi: Umsebenzi we-CLUTCH ku-Excel
Indlela yokufihla amakholomu ku-Excel

Ngakho-ke, kungashiwo ukuthi kunezindlela ezimbili zokufaka ifomu kanye nombhalo kumakhalekhukhwini owodwa: ngosizo lwama-ampersand nomsebenzi Ukudonsa. Indlela yokuqala ilula futhi elula kakhulu kubasebenzisi abaningi. Kodwa-ke, ezimweni ezithile, isibonelo uma ucubungula amafomula ahlangene, kungcono ukusebenzisa opharetha Ukudonsa.