Namathisela umbhalo esitokisini ngefomula kuMicrosoft Excel

Kaningi, lapho usebenza e-Excel, kunesidingo sokufaka umbhalo ochazayo eduze komphumela wokubala ifomula, okwenza kube lula ukuqonda le datha. Vele, ungagqamisa ikholomu ehlukile yokucaciselwa, kepha hhayi kuzo zonke izimo ukwengezwa kwezinto ezingeziwe kunengqondo. Kodwa-ke, e-Excel kunezindlela zokufaka ifomula nombhalo kuseli elilodwa ndawonye. Ake sibheke ukuthi lokhu kungenziwa kanjani kusetshenziswa izinketho ezahlukahlukene.

Inqubo yokufaka umbhalo eduze nefomula

Uma uzama nje ukunamathisela umbhalo esitokisini esisodwa nomsebenzi, khona-ke ngomzamo onjalo, i-Excel izoveza umlayezo wephutha kwifomula futhi ngeke ivume ukufakwa okunjalo. Kepha kunezindlela ezimbili zokufaka umbhalo eduze kwenkulumo yefomula. Owokuqala ukusebenzisa i-ampersand, owesibili ukusebenzisa umsebenzi QHAFA.

Indlela yoku-1: sebenzisa i-ampersand

Indlela elula yokuxazulula le nkinga ukusebenzisa uphawu lwe-ampersand (&) Lo mlingisi uhlukanisa imininingwane ngokunembile idatha ifomula iqukethe kunkulumo yombhalo. Ake sibheke ukuthi ungayisebenzisa kanjani le ndlela ekwenzeni.

Sinethebula elincane lapho kuboniswa khona izindleko ezingaguquki nezingafani zebhizinisi kukholamu ezimbili. Ikholomu yesithathu iqukethe ifomula elula yokuhlanganisa eyifingqa bese ikhombisa umphumela ophelele. Sidinga ukwengeza igama elichazayo emva kwefomula esitokisini esifanayo lapho kuboniswa izindleko zizonke "ama-ruble".

1. Yenza kusebenze iseli eliqukethe inkulumo yefomula. Ukuze wenze lokhu, chofoza kabili kukho inkinobho yegundane kwesobunxele, noma ukhethe bese ucindezela inkinobho yokusebenza F2. Ungaphinde ukhethe iseli, bese ufaka isikhombisi kubha yefomula.



2. Ngokushesha ngemuva kwefomula, faka i-ampersand (&) Okulandelayo, bhala igama emamaki wokucaphuna "ama-ruble". Kulokhu, amamaki wokucaphuna ngeke aboniswe esitokisini ngemuva kwenombolo ekhonjiswe ifomula. Bavele bakhombisa njengophawu kuhlelo ukuthi lungumbhalo. Ukuze ubonise umphumela esitokisini, chofoza inkinobho Ngena kwikhibhodi.



3. Njengoba ukwazi ukubona, ngemuva kwalesi senzo, ngemuva kwenombolo eboniswa ifomula, kukhona umbhalo ochazayo "ama-ruble". Kepha le nketho inodonsa olulodwa olubonakalayo: inombolo nencazelo yombhalo ihlanganiswe ngaphandle kwesikhala.

   

   Kulokhu, uma sizama ukubeka isikhala ngesandla, ngeke sisebenze. Lapho nje inkinobho icindezelwa Ngena, umphumela "unamathela ndawonye" futhi.



4. Kepha kuseyindlela yokuphuma kulesi simo. Futhi, yenza iseli eliqukethe ifomula nezinkulumo zombhalo. Ngemuva nje kwe-amersand, vula amamaki wokucaphuna, bese usetha isikhala ngokuchofoza enkambini ehambelana nayo kukhibhodi, bese uvale amamaki wokucaphuna. Ngemuva kwalokho, phinda ubeke uphawu lwe-ampersand (&) Bese uchofoza inkinobho Ngena.



5. Njengoba ukwazi ukubona, manje umphumela wokubala ifomula nenkulumo yombhalo kuhlukaniswe isikhala.

Ngokwemvelo, zonke lezi zenzo azidingekile. Sisanda kukhombisa ukuthi ngesingeniso esijwayelekile ngaphandle kwamamaki wesibili nezimpawu zokucaphuna ezinesikhala, ifomula nedatha yombhalo izohlangana. Ungasetha isikhala esifanele lapho uqeda isigaba sesibili salo mhlahlandlela.

Lapho sibhala umbhalo ngaphambi kwefomula, sinamathela kwis syntax esilandelayo. Masinyane ngemuva kwesiginali "=", vula amamaki wokucaphuna bese ubhala umbhalo. Ngemuva kwalokho, vala amamaki wokucaphuna. Sibeka uphawu lwe-amersand. Ngemuva kwalokho, uma udinga ukufaka isikhala, vula amamaki wokucaphuna, ubeke isikhala bese uvale amamaki wokucaphuna. Chofoza inkinobho Ngena.

Ukubhala umbhalo uhambisana nomsebenzi, hhayi ifomula ejwayelekile, zonke izenzo ziyefana ngokuchazwe ngenhla.

Umbhalo ungacaciswa futhi njengesixhumanisi seseli elikuyo. Kulesi simo, i-algorithm yezenzo ihlala ifana, ama-cell axhumanisa ngokwawo awadingekile kumaki wokucaphuna.

Indlela 2: sebenzisa umsebenzi we-CLIP

Ungasebenzisa futhi umsebenzi ukufaka umbhalo kanye nemiphumela yokubala ifomula QHAFA. Lo opharetha wenzelwe ukuhlanganisa kuseli elilodwa amanani aboniswe kuzinto eziningana zeshidi. Kungokwesigaba semisebenzi yombhalo. I-syntax yayo imi ngolu hlobo:

= I-CONNECT (umbhalo1; umbhalo2; ...)

Sekukonke, lo opharetha angaba nakho 1 ngaphambili 255 ukuphikisana. Ngayinye yazo imelela noma imbhalo (kufaka phakathi izinombolo kanye nezinye izinhlamvu), noma izixhumanisi kumaseli aqukethe.

Ake sibheke ukuthi lo msebenzi usebenza kanjani ekusebenzeni. Isibonelo, ake sithathe itafula elifanayo, vele ufake enye ikholomu kulo "Izindleko Zonke" ngeseli elingenalutho.

1. Khetha iseli lekholomu engenalutho "Izindleko Zonke". Chofoza isithonjana. "Faka umsebenzi"etholakala kwesobunxele sebha yefomula.



2. Ukuqalisa kuyaqhubeka Umsebenzi Wizards. Siqhubekela esigabeni "Umbhalo". Okulandelayo, khetha igama Xhuma bese uchofoza inkinobho "Kulungile".



3. Iwindi lezimpikiswano zomsebenzisi liqala. QHAFA. Le windi liqukethe izinkambu ezingaphansi kwegama "Umbhalo". Inani labo liyafinyelela 255, kepha ngokwesibonelo sethu, izinkambu ezintathu kuphela ezidingekayo. Kweyokuqala sizofaka umbhalo, owesibili - isixhumanisi esitokisini esiqukethe ifomula, kuthi okwesithathu siphinde siwubeke lo mbhalo.

   Setha isikhombisi esigangeni "Umbhalo1". Faka igama lapho "Okuphelele". Ungabhala izinkulumo zombhalo ngaphandle kwezilinganiso, ngoba uhlelo luzowubeka wedwa.

   Ngemuva kwalokho uye ensimini "Umbhalo2". Setha isikhombisi lapho. Sidinga ukukhombisa lapha inani eliboniswa ifomula, okusho ukuthi kufanele sinikeze isixhumanisi esitokisini esiqukethe. Lokhu kungenziwa ngokumane ufake ikheli ngesandla, kepha kungcono ukubeka ikhesa enkundleni bese uchofoza kuseli equkethe ifomula eshidi. Ikheli lizoboniswa ngewindi lokuphikisana ngokuzenzakalelayo.

   Ensimini "Umbhalo3" faka igama elithi "rubles".

   Ngemuva kwalokho chofoza inkinobho "Kulungile".



4. Umphumela uboniswa kuseli elikhethwe ngaphambilini, kepha, njengoba sibona, njengakwindlela edlule, wonke amanani abhaliwe ndawonye ngaphandle kwezikhala.



5. Ukuze uxazulule le nkinga, khetha futhi iseli eliqukethe opharetha QHAFA bese uya emugqeni wamafomula. Lapho, ngemuva kwengxabano ngayinye, okungukuthi, ngemuva kwe-semicolon ngayinye, engeza le nkulumo elandelayo:

   " ";

   Kufanele kube nesikhala phakathi kwezimpawu zokucaphuna. Ngokuvamile, le nkulumo elandelayo kufanele ivele kulayini wokusebenza:

   = Xhumanisa ("Ingqikithi"; ""; D2; ""; "ama-ruble")

   Chofoza inkinobho ENTER. Manje amanani ethu ahlukaniswe izikhala.



6. Uma ufisa, ungafihla ikholamu lokuqala "Izindleko Zonke" nefomula yangempela ukuze ingathathi isikhala esengeziwe ephepheni. Ukuyisusa nje ngeke kusebenze, ngoba lokhu kuzokwephula umsebenzi QHAFA, kepha ukususa into kungenzeka. Qhafaza kwesobunxele emkhakheni wepaneli wokuhlanganisa wekholomu okufanele ufihlwe. Ngemuva kwalokho, kuqokonyiswa ikholamu yonke. Sichofoza kukhetho ngenkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Khetha into ekuyo Fihla.



7. Ngemuva kwalokho, njengoba ubona, ikholomu esingayidingi ifihliwe, kepha ngasikhathi sinye idatha esitokisini lapho kusebenza khona QHAFA kuboniswe kahle.

Ngakho-ke, singasho ukuthi kunezindlela ezimbili zokufaka ifomula nombhalo kuseli elilodwa: ukusebenzisa i-ampersand nomsebenzi QHAFA. Inketho yokuqala ilula futhi ilungele abasebenzisi abaningi. Kepha, noma kunjalo, ezimweni ezithile, ngokwesibonelo, lapho sicubungula amafomula ayinkimbinkimbi, kungcono ukusebenzisa opharetha QHAFA.