I-Array ifomula mac - izisombululo ezijolise kwinto

Ndilwenza njani uluhlu lwe-Excel yeMac?

Khetha uluhlu, cinezela ULAWULO + U kwaye ucinezele ⌘ + BUYELA. CTRL + SHIFT + ENTER,UKUHLAWULAIFOMUNGOKUGQIBELELEYONgo-2016IMAC.28 Oktobha. Ngo-2014

- Into oza kuyibona iya kutshintsha yonke into.

Emva koko, ayisayi kuphinda ifane kwakhona. Makhe ndikucacisele. Xa ufunda ukusebenza ngeefomyula ezinqabileyo ezinje ngokunyaniseka.

Ababaninzi abantu abathanda ukuchitha ixesha ukubhala le nto kwasekuqaleni okanye ukukhathaza ukukhangela ifayile equlathe le fomyula. Kuthatha ixesha. Nantsi ingxaki.

Bayayidinga ngomsebenzi wabo. Kungenxa yoko le nto la manqaku mabini engamanqaku athandwayo kwisiteshi sam nangona enazo ezi fomula ziphambeneyo. Emva kweso siganeko, iMicrosoft Ignite 2018, yonke into yatshintsha.

Ukufakwa kwezinto ezinamandla kwaziswa. Ewe, nantsi into. Ayililo iqela lamafomula amatsha ongezwe kwi-Excel.

Olu lutshintsho kwinjini yokubala ye-Excel. Yenza yonke into ibe lula, kubandakanya nendlela ezisebenza ngayo iifomula. Ngoku ndifuna ukukubonisa into.

Ndiza kurekhoda la manqaku mabini. Ixesha lakho elipheleleyo liphelile kwimizuzu engama-30 kwaye ndiza kuqhuba ixesha. Ndizakusombulula la manqaku mabini ngokudweliswa okuguqukayo ukuze ndikunike umxholo.

Nalu uluhlu endinalo ukuba nizahlule, niyabona amagama awaqokelelwanga, asasazekile. Ngaphambi koko, ndaye ndasebenzisa usetyenziso olukwicandelo. Ngoku ndenze imenyu eyahlulayo eyahlukileyo kuqala.

Olu luhlu lwamagama amathathu. Phambi kokuba kuxhomekeke kuluhlu olwehlayo. Ke ezi ziapps ezikwisebe lezemidlalo.

Into oyibonayo apha ngezantsi yile tafile yolwazi lwedatha yoku ukuze isebenze. Oku kusinika uluhlu olwahlukileyo, oku kusinika isebe lokusebenza, kodwa jonga kule fomyula, iphambene! Nokuba iya kumgca olandelayo. Kwaye eyona nto iphambeneyo yifomula ye-offset endinayo apha, makhe siyijonge ngokukhawuleza phantsi koQinisekiso lweDatha, jonga oku.

Ngoku ndiyenzile le nto ukuze ndiqiniseke ukuba uluhlu lwam losetyenziso luyayeka ukuphela kwenkqubo yokugqibela. Ukuze ndingabinazo iiseli ezingenanto apho. Akumangalisi ukuba kwandithatha ixesha elide ukwenza.

Inqaku nje apha lokuba ngexesha lokufota, uluhlu olunamandla alufumaneki kuluntu ngokubanzi. Ziya kufumaneka kwixa elizayo. Nini? Ayikachazwa okwangoku.

Ngoku masenze ngale ndlela ngokudwelisa okunamandla. biza isibali xesha, qala ngoku. Ndisaya kwenza itafile yolwazi lwedatha kwaye ndisebenzise enye yeefomula zoluhlu ezinamandla ezibizwa ngokuba ngumsebenzi owahlukileyo, kuthatha ingxoxo yoluhlu Qaphela ukuba iimpikiswano ezimbini ezilandelayo ziyanyanzeleka.

Andizukukhathazeka nangoko. Ndiza kuvala isibiyeli kwaye ndibethe ukungena. Ngoku jonga kuloo nto.

Ifomula idlulela kwiiseli ezilandelayo, chwetheza nje. Ukwenza uluhlu lokuhla kuyeyona nto inomdla ngakumbi. Masibuyele ekuqinisekisweni kwedatha, khetha uluhlu, kodwa kumthombo andizukuyibalaselisa le nto njengoko uluhlu lwam lunokwandisa uluhlu lonke lokungcwatywa, kwaye kukho syntax entsha yento.

I-hotmail icotha

Beka uphawu lwe-hashtag ngqo emva kwesalathiso seseli. Oku kuthetha ukuba ubhekisa kuluhlu olupheleleyo. Jonga oku.

Inazo zonke phaya. Ngoku mhlawumbi uyabuza, 'Kuthekani ukuba ndongeza into entsha? Ngaba iya kuhlaziywa? Ndiyifomathile njenge-Excel ispredishithi ukuze ewe iya kuhlaziya. Ukuba awunayo i-spreadsheet ye-Excel, unokufuna ukongeza iiseli ezongezelelweyo kwifomula yakho eyahlukileyo kwaye ziya kuthathelwa ingqalelo xa sele zigcwalisiwe.

Masongeze apha apha. Icandelo elitsha liboniswa apha kwaye apha liyaboniswa. Masenze eyona ndawo inzima.

Olo yayiluluhlu lokuxhomekeka ezantsi. Ndiza kusebenzisa omnye umsebenzi omtsha onamandla obizwa ngokuba yiFilter Function. Ngokwenene icoca ifomula.

Akukho sidingo sokuhlaziya isihluzi ngesandla, sinamandla, yintoni oza kuyicoca? Ndifuna le ihluzwe. Yeyiphi ipharamitha yokucoca ngayo? Kuya kufuneka sihluze ukuba ukwahlulwa kweseli kuyalingana kubakaki okuvaliweyo kwaye kubetha ukungena. Kwaye kunjalo.

Masenze yesibini yethu yokwenza imenyu yokuhla, sibuyele ekuqinisekisweni kwedatha, uluhlu. Yayiyintoni isalathiso sokuphalaza? . Sinoluhlu lwethu olunamandla lokuhla.

Masitshintshe le intsha. Jonga le. Uluhlu lwethu lukhawulelwe kumalungu esebe elitsha.

Misa isibali xesha. Linda umzuzu! Njani ngokuhlela? Oku kwakunzima kakhulu ukwenza kwi-Excel yesiko. Hayi kwakhona.

Into ekufuneka ndiyenzile kukusebenzisa ifomula entsha yokuhlela uluhlu. Olu luluhlu lwam. Ndingachaza uhlobo lwesalathiso, indlela yokuhlela kunye nekholamu endifuna ukuhlela ngayo, zonke ezi zinokukhetha.

Ndiza kuhamba noseto olungagqibekanga. Hlela ngokufanelekileyo. Ndiza kwenza okufanayo nomsebenzi wam wokucoca ulwelo apha.

Oko nako kuzihlela. Jonga lonto. NdineMidlalo, eNtsha, iMveliso kunye nokuSebenza.

Nazi iinkalo ezintsha ngokulandelelana kwealfabhethi. Makhe sithelekise ezi fomula zimbini. (umculo omnandi) Ngaba ayisiyonto iphambeneyo leyo? Uninzi lwabantu luye lwashiya amagqabantshintshi amnandi phantsi kwala manqaku mde, kwaye nantsi eminye egaya inyani.

Kunzima ngenene. Ndiyifumana inzima kakhulu. Ewe kunzima.

Nantsi enye. Iluncedo kakhulu, ndicinga ukuba i-Excel ibikulungele oko njengoko kusenokwenzeka ukuba kusetyenziswe kakhulu, ayisiyonto ilungileyo ukuba ekugqibeleni sizakuyidibanisa? Nabani na osebenzisa i-Excel ukuhlalutya idatha kuya kuba lula kuba ayizizo nje ezi fomula. Kukho amawaka endibaniselwano yefomula eya kwenza imisebenzi enzima ngokulula.

Enkosi kakhulu kwiqela leMicrosoft Excel ngokwenza oku kube nokufumaneka kuthi. Ukuba unemincili ngale nto, kwaye kufuneka ubekhona, ukuba uyaqhubeka ubukele kude kube ngoku, phawula apha ngezantsi, ndazise ukuba ucinga ntoni. (umculo onesidima)

/ Uyifaka njani ifomula yoluhlu?

Mholweni.

Kule khokelo ye-Excel, siza kuhamba kwifomula ye-Excel, indlela yokuyisebenzisa, kwaye iphela ngezinye iingcebiso zokugcina engqondweni xa usebenzisa iifomula. Okokuqala, uluhlu kwi-Excel lubhekisa kwiqela lamaxabiso-banokuba kumqolo, kwikholamu, okanye zombini. Ifomula yoluhlu yifomula eyenza ukubala kuluhlu.

Oku kusenokwenzeka ukuba kuyavakala kungaqhelekanga kuba injongo yazo zonke iifomula kukubala into, ke makhe sijonge kuyo. Kwiskrini kukho idatha yokuthengisa ngenyanga. Masithi ndifuna ukufumanisa ukuba zingaphi iidola ezithengisiweyo zizonke ngaloo nyanga.

Ndingayiphinda-phinda idatha kumqolo ngamnye ngokwahlukeneyo okanye ndisebenzise ifomula yoluhlu. Ukwenza oku, kufuneka siqale sigqamise zonke iiseli esifuna ukuba zibe zizo kwifomula, emva koko ufake uphawu olulinganayo kwaye uqaqambise ikholamu yokuqala esifuna ukuyiphindaphinda- kwaye ndisebenzisa iikholamu apha, kodwa unga ngokulula ukwenza oku kwimiqolo- emva koko sibeka * ukuphindaphinda kunye nokuqaqambisa ikholamu elandelayo esifuna ukuyiphindaphinda kwaye ucinezele Ctrl + Shift + Enter. Ngolwazi lwakho, ukwenza uluhlu lwefomyula kufuneka ucinezele Ctrl + Shift + Enter.

Ngaphandle koko, yenza nje ifomula eqhelekileyo. Uyazi ukuba wakhe ifomula yoluhlu xa ubona ezi brace zincinci. Kwaye qaphela ukuba idatha yethu iphindaphindwa njani kwinyanga nganye.

Kwaye emva koko ukuyijonga, ungaphinda nje ubungakanani bakho obuthengiswe ngedola yakho ethengisiweyo. Kwaye uqaphele ukuba uluhlu lwefomula lwenze kanye loo nto, ngaphandle kokudibana okumbalwa. Masiyicime loo nto.

Kulungile, kutheni oku kuluncedo ukuba kunyanzelekile ukuba siphindaphinde iifomula sizikope? Ewe, ukuqala, usebenzisa ifomula enye endaweni ye-12. Ke ngalo lonke ixesha usongeza ifomula kwispredishithi sakho, kuthatha nje inkumbulo ethe kratya. Kwaye ukuba usebenza ngokuseta idatha enkulu, oku kunokuchaphazela ukuba lingakanani ixesha eliza kuthatha itafile yakho ukubala kwakhona kunye nokuhlaziya.

Kuba ufaka ifomula enye kuphela, ungonga ixesha emsebenzini wakho. Ngendlela, ukuba ufumanisa ukuba esi sifundo siluncedo, nceda usithande kwaye ubhalise kwisitishi ukuze ubone iitutorials ezintsha nje ukuba ziphume. Sinokusebenzisa eminye imisebenzi kuluhlu lweefomula ngokunjalo.

Ke sibeka nje kwifomula yoluhlu kwiiseli ezininzi ukufumana itotali iyonke ithengisiwe ngenyanga, kodwa kuya kuthini ukuba sifuna ukufumana itotali yonyaka? Ukwenza oku kufuneka siphindaphinde umqolo ngamnye kwaye sidibanise izibalo ...

OKANYE singazidibanisa ezi zibalo sisebenzisa ifomula yoluhlu. Ke masize apha ...

kwaye ukwenza oko sikunika = SUM (kwaye ukhethe inani elipheleleyo elithengisiweyo, liphindaphindwe ngeedola eziphakathi kwintengiso nganye, emva koko ucofe uCtrl + Shift + Ngena kwakhona, kwaye oku kusinika idola yethu ithengisiwe ngonyaka Fomatha zonke ezi zinto ...

Ke yintoni ebalulekileyo ekufuneka uyikhumbule? Uyakhumbula xa usebenza ngeefomula zoluhlu? Ewe, into yokuqala nguCtrl + Shift + Enter. Ukuba awucinezeli ifomula ukuphuma kwifomula yakho, awunayo ifomula yoluhlu. 2.

Xa ungena kwifomula yakho, njengoko wenzayo xa usebenzisa i-F2 kwaye ungacinezeli Ctrl + Shift + Enter ukuphuma, ucoca ifomula yoluhlu. Ukuba ubalo lwakho lukwiseli enye, njengakwisixa sethu apha, kwaye uphume ngempazamo ngaphandle kokubetha iCtrl + Shift +. Ngena, konke okufuneka ukwenze kukuphindela nje kwifomula kwaye ucinezele u-Ctrl + Shift + Enter ukuphuma, kwaye oku kuya kulungisa i-rmula kwiiseli ezininzi njengoko senzile apha ukubala iidola ngenyanga, awungekhe uhlele iseli enye.

Ndiqaphela impazamo xa ndizama ukungena kwiseli kwaye ndenze ukuhlela. Ngoku ungahlela indawo ...

masiphume kule nto ...

kwaye uqiniseke ukuba ubetha Ctrl + Shift + Enter xa ugqibile. Kwaye uqaphele ukuba oku kutshintshe uluhlu lomntu wonke olusinika impazamo apha ngezantsi njengoko oku kungaphandle kwoluhlu. Masiyibuyisele umva loo nto. 4.

Ukucima ifomula yoluhlu kwiiseli ezininzi, khetha zonke iiseli ezinoluhlu olunoluhlu kwaye ucofe u-Cima. Kwaye masikubuyise oko. 5.

qala i-chrome yenziwe nkulu

Ukuba unomdla, hayi, ngekhe usebenzise ikhibhodi ukuchwetheza kwii-curly brace, kuya kufuneka ucinezele Ctrl + Shift + Enter. Okokugqibela, cinga ngabaphulaphuli bakho. Ukuba wabelana ngetafile yakho nabanye abanokufuna ukwenza utshintsho kuyo, jonga ukuba ingaba bayazazi na iifomula zendlela kunye nendlela yokuzisebenzisa- kwaye ungabathumela nje ikhonkco kwesi sifundo naninina- kodwa ukuba abazi ukuba yintoni kunjalo, banokwaphula ngengozi ifomula, eya kuthi ichaphazele iziphumo ezibonisiweyo zedatha.

Ukuba ulonwabele olu qeqesho ngokusebenzisa iifomula zoluhlu kwiMicrosoft Excel, qiniseka ukuba uyayithanda inqaku kwaye ungalibali ukubhalisela eli jelo. Imibulelo emininzi!

Ithetha ntoni i- {} kwi-Excel?

Ukungena kwifomula yoluhlu

Cinezela CTRL + SHIFT + ENTER ukuqinisekisa le fomyula (endaweni yokucinezela nje ENTER). Oku kuya kuvelisa iibrakethi ezijijileyo{}malunga nefomula. Ezi zibiyeli zigobileyo zinjaniI-Excelyamkela uluhlu oluluhlu.9 kweyeThupha. Ngo-2017

Namhlanje siza kuthetha ngereferensi ye-hash kwi-Excel, umbuzo oqhelekileyo endiwufumanayo kukuba loluphi olu phawu lwe-hash ndihlala ndilisebenzisa kumanqaku am xa kubhekiswa kwiiseli? Ewe, ukuba unayo iMicrosoft 365 sele unayo uphawu lwe-hash kwaye kuya kufuneka uyisebenzise kuba iya kwenza ubomi bakho bube lula kakhulu.

Makhe ndikubonise ukuba ungayenza njani. Nantsi ndinedatha yesampulu engafomathiweyo njenge-Excel spreadsheet. Kuqala, mandikubonise apho ungenakho ukusebenzisa uphawu lwe-hash.

Ke ngekhe ubeke into enye, ireferensi A3, faka i-hash kwaye ulindele ukuba iziphumo zakho ziphuphume kwaye zibandakanya uluhlu oluvela kwi-A3 ukuya kwi-D18, ayizukwenzeka. Kwaye kutheni kungenzeki? kukuba ayisiyondawo ichithekileyo le. Ungasebenzisa kuphela uphawu lwe-hash xa ubhekisa kwindawo echithekileyo.

Ngoku uyiqonda njani indawo echithekileyo? Ewe, ndiza kukubonisa. Okokuqala, masenze indawo enye echithekileyo. Njani? yenza lonto? Ewe, imimandla eyahluliweyo iyenziwa ngokubanzi kusetyenziswa iifomula eziye ziphuphume.

Ke ukuba usebenzisa uhlobo lomsebenzi okanye umsebenzi owahlukileyo, umzekelo, le yimisebenzi echitheka. Ukuba ungathanda ukufunda ngakumbi ngezi zinto, ndinenqaku elahlukileyo malunga nalo kwaye ndiza kongeza ikhonkco kuyo kwinkcazo yale khosi yenqaku egubungela zonke izinto ezintsha kwi-Excel 365. Ndongeza nekhonkco .

Ekuphela kwento esiyifunayo kulo msebenzi ukhethekileyo luluhlu lwethu. Ke masithi ndifuna ukufumana ulwahlulo olwahlukileyo kunye nomdibaniso wengingqi. Ndibhekisa kule ndawo, vala isibiyeli kwaye ungene ungene kule ndawo ngoku ichithekileyo.

Ndibhale le fomyula nje ukuba ndingene kwaye isiphumo sidluliselwe kwiiseli ezilandelayo. Ke ngoku ungabona indawo ichithekileyo inesakhelo esizenzekelayo esizuba, ke ngalo lonke ixesha ndicofa kude, ihambile. Qho xa ndicofa, ikhona.

Kwaye inombolo yesibini kukuba ifomula ihlala kuphela kwiseli yokuqala. Ke le ikona ephezulu ngasekhohlo kwifomula yefomula, ifomula apha imnyama. Xa ndisiya kwiiseli ezilandelayo zingwevu, yile ndlela ungayichaza ngayo indawo echithekileyo.

Jonga le. Xa ndizama ukususa inxenye yale ndawo ndivele ndatshayisa umva apha ndaza ndangena, andinakuyenza le nto. Xa ndibetha isitshixo sokucima, ayizukundivumela ndiyenze.

Ifomula inokususwa kuphela apha. Ukuba ndibethe isitshixo sasemva apha kwaye ndibetha ukungena, ifomula yam ihambile. Ndizakubetha kulawulo ukuze ndibuyele umva.

Ngoku, endaweni yokubasusa, xa uchwetheza into malunga noku masithi ndiyachwetheza rhuma. Eli lixesha elifanelekileyo lokwazisa ukuba awuzange ubhalisele eli jelo, cinga ukubhalisa, ngakumbi ukuba ufunda izihloko ezitsha apha. Ukuba ndiyichwetheza ngaphakathi kwaye ndibetha ukungena ndifumana impazamo yokuchitheka apha, ngoba? Kuba ubisi olungumgubo lwam lufuna ukuchitheka kwaye kukho ukubhloka ukuba ndiyasusa oko kubhloka ndibuyise iziphumo zam.

Ngoku ekubeni sisazi ukuba yintoni indawo echithekileyo, singalusebenzisa njani uphawu lwe-hash? Ewe, ukuba ubhekisa kwindawo enepropathi ephuphumayo, ungasebenzisa uphawu lwe-hash, ke apha ukuba ndingena ndichwetheze = G3 kwaye ngoku ndibeka i-hash kwaye ndibetha ukungena, uluhlu lwam luzichithele ngokuzenzekelayo kwaye uchola yonke into. Uncedo lokusebenzisa uphawu lwe-hash kukuba mzuzu olu luhlu lokuqala luyanda, olu luhlu luyazenzekela. Umzekelo, ukuba ndibuyela kumzekelo wedatha yam apha kwaye ndenze indibaniselwano entsha yoPhuculo lwaseYurophu, siyayitshintsha ibe yiMveliso yaseOstreliya kwaye ndibetha u-Enter, kwaye ndifumana olu dibaniso luboniswa apha ngokuzenzekelayo.

Kwaye elo candelo, ireferensi yam ye-hash iyanda ngokuzenzekelayo Kulungile, ndiye ndayibetha iCtrl + Z ukubuyela umva. Ngoku, ukuba ujonga kwifomula yethu yokuqala, uya kuqaphela ukuba ndibhekisa kwi-A3 ukuya kwi-B18. Ke ndisebenzisa isalathiso esingqalileyo seseli.

Le ayisiyi-Excel ispredishithi. Oku kuthetha ukuba ngalo lonke ixesha ndongeza into entsha, xa ndongeza impilo kwaye ndongeza iYurophu, ngokucacileyo ayiyandisi loo ndawo. Kodwa ukuba ndingena ndiyikhulise ngesandla ndize ndibethe ukungena, indawo yesibini iya kwandisa ngokuzenzekelayo kuba ndisebenzisa i-hash sig n apha, ngoku eyona nto ilungileyo kukusebenzisa iipredishithi njengoko ungazukuba nale ngxaki. Ubungakanani buya kwandiswa ngokuzenzekelayo ukuba umthombo uyitafile kwaye ayisiyiyo kuba ndisebenzisa umsebenzi okhethekileyo onje ngeB.

Umahluko, oku kusebenza nangawo nawuphi na umsebenzi we-Excel yiyo loo nto kulungile ukusebenzisa iitafile njengomthombo. Ke ukuba siyiguqulela kwi-Excel ispredishithi, akufuneki ukuba sikhathazeke malunga nelaa nxalenye njengoko isibonelelo sethu siya kwandiswa ngokuzenzekelayo. Makhe ndicinezele Ctrl + Z ukubuyela umva.

Ngaphambi kokuba senze oko kwaye sikubonise indlela iindawo ezichithekileyo eziziphatha ngayo ngeetafile, mandikubonise enye into. Khumbula, xa ndingena kule fomyula, ndingenile kwi-G3 emva koko ndongeza i-hash ukungena kwi-hash. Apha, ukuba ubhekise nje kuloo ndawo ichithekileyo, iya kubekwa ngokuzenzekelayo kuwe.

Jonga loo nto kwaye uyisuse. Ngoku xa ndiyibhekisa, jonga kwifomula, iseyi-G3 ukuya kwi-H8. Ngoku ukuba ndiyayandisa kwaye ndiye ezantsi kumqolo omnye, jonga ukuba kwenzeka ntoni, ikwenzela uphawu oluphezulu.

Kulungile, ke ukuba ubhekisa kulo lonke uluhlu uya kulufumana olu phawu lwe-hash. Masithathe ikhefu kwaye sijonge ekusebenziseni umqondiso we-hash. Ngoku ukusebenzisa lo mzekelo ngokubanzi kwezinye iifomula apha, masithi ndifuna uluhlu olwahlukileyo loMmandla, iApp, okanye iCandelo kwaye ndifuna ukwenza olu khetho luphazamisayo.

Ke xa nditshintshela kwi-app apha ndifumana uluhlu olucacileyo lweeapps kwaye ndifumana iinombolo ezizenzekelayo kwiindawo. Xa nditshintshela kwisahlulo ndinamacandelo amabini ahlukeneyo. Ingena phi i-hash? Ulandelelwano kunye nemisebenzi yeCOUNTA.

Ukuba unomdla wokuba yeyiphi ifomula endiyisebenzisileyo apha, ngumdibaniso wesalathiso esahlukileyo kunye no-x umdlalo oluguqulelo olutsha lomsebenzi womdlalo. Ngoku masibuyele kumzekelo wethu wokuqala. Masiguqule oku kwi-spreadsheet esemthethweni ye-Excel kwaye sibone ukuba kwenzeka ntoni.

Ke ndibethe Ctrl + T, itafile inezihloko kwaye masihambe no-Ok, ke ngoku le yitafile, umzuzu ndiqala ukongeza into, jonga kuluhlu lwam apha. Ndongeza iMpilo neYurophu, iya kwandiswa ngokuzenzekelayo njengoko umthombo wam ngoku uyitafile. Ungasisebenzisa njani isikhombisi se-hash kwitafile? Ewe, iitafile sele zinendawo yokuziphatha kokuchitheka.

Jonga lonto. Umzekelo, ukuba ndongeze nje ikholamu entsha kule tafile kwaye ndifuna ukuthatha eli nani apha kwaye ndikhuphe enye kuyo. Ke ndenza thabatha enye.

Okwangoku ndibetha ukungena, iziphumo zam zichithekile, yonke into ibhekisiwe kwaye isebenzisa izingqinisiso ezihambelana netafile. Ngoku ukuba ndisebenzisa i-hash signor endaweni yoko, ndibhala ifomula ephuphumayo. Ndiza kubhekisa kule kholamu apha.

Xa ndivala isibiyeli kwaye ndibetha ukungena, ndifumana impazamo, ngoba? Ngenxa yokuba ifomula yam ichithekile. Xa ekule seli, uzama ukubhala umdlalo, imveliso, kunye nempilo. Kwaye xa sele ikwiseli izama ukubhala umdlalo ofanayo, imveliso kunye nokuphilisa kunokuthintana.

Ke uya kufumana impazamo 'yoPhalazo oluPhezulu'. Oku kuthetha ukuba ngekhe usebenzise naziphi na iindawo ezichithekileyo ngaphakathi kwetafile. Isizathu soku kukuba ugqibela ngento efana netafile ngaphakathi kwetafile, enokwenziwa yi-Excel.

Kule meko-mbini, sinemiqolo kunye neekholamu kuphela. Kuya kuba mnandi ukufumana i icon encinci yetafile apha kwaye sinokucofa kuloo nto kwaye siye kwitafile yesibini ebonisa kuphela ezi tafile zintathu zinokuba nazo kwiiseli. Ungacofa kuyo kwaye ufumane iinkcukacha.

Ngelishwa, le ndlela yokuziphatha ayinakuboniswa apha kwigridi. Ndicinga ukuba le yinto yokugcina engqondweni xa usebenza neetafile. Ngoku ndinencam yebhonasi yakho apha, ungathini ukuba ufuna ukubhekisa kwindawo echithekileyo kodwa ungafuni ukuba yonke loo ndawo ibuye.

Ufuna kuphela icandelo elithile lommandla. Ke masithi ndifuna ukufumana ikholamu ndibuyile kule ndawo ichithekileyo. Ngelixa kukho iindlela ezininzi zokwenza oku, enye indlela yokwenza oku: ukusebenzisa umsebenzi wesalathiso, uluhlu lwendawo yakho echithekileyo ke ndiza kuhamba ne-I3 #, ndifuna ukubandakanya yonke imiqolo ukuze ndiyifumane inye Tsiba impikiswano kunye nenombolo yekholamu ndibuyise inani lesalathiso lekholamu endifuna ukuyibuyisa.

Ke ukuba ndifuna ikholamu yokuqala ndiza kongeza enye, ndivale isibiyeli, hit hit kwaye ndiza kubuyisa ikholamu yokuqala, ukuba ndiyayifuna ndiza kufumana eyesibini Kulungile, ndiyathemba ukuba icacile ngoku ireferensi ye-hash kwaye singenza njani ukuba iingxelo zakho zibe namandla ngakumbi ngaphandle kokukhathazeka ngokuhlaziya imithombo yakho yemithombo njengoko zitshintsha, ndiyathemba ukuba ulifumene eli nqaku liluncedo, ke ngoko, linike isithupha kule jelo kwaye ubhalise kweli jelo ukuze uhlale usesikhathini izihloko zemveliso, cofa nje kwiqhosha lokubhalisa elingezantsi kwinqaku. Enkosi ngononophelo lwakho kwaye siza kubona kwinqaku elilandelayo. (umculo omncinci)

Ugcwalisa njani ngokuzenzekelayo ifomula yoluhlu kwi-Excel?

/ Uyifaka njani ifomula yoluhlu kwi-Excel Mac?

Fumana isisombululo kwi-Excel Mac2016 njengokuncamathisela ikhowudi kwiseli efanelekileyo, ngenisa, emva koko uye esiphelweni sefomula ngaphakathi kwebha yentloko kwaye ufake oku kulandelayo: Faka ifomula njengoluhlu lwefomula yomfanekiso + SHIFT + RETURN okanye CONTROL + SHIFT + BUYELA CTRL + SHIFT + ENTER, ULAWULA IFOMU EXCEL 2016 MAC.

eyam i-1.8.8 yengozi

/ Ungayifaka njani ifomula yokuGqibela kweMac kwi-Excel?

Khetha uluhlu, cinezela ULAWULO + U kwaye ucinezele ⌘ + BUYELA. Fumana isisombululo kwi-Excel Mac2016 njengokuncamathisela ikhowudi kwiseli efanelekileyo, ngenisa, emva koko uye esiphelweni sefomula ngaphakathi kwebha yentloko kwaye ufake oku kulandelayo:

Uludala njani uluhlu lwe-Excel?

Kwi-Excel yewebhu, unokujonga iifomula zoluhlu ukuba incwadi yomsebenzi oyivulayo sele inayo. Kodwa awuyi kuba nakho ukwenza ifomula yoluhlu kule nguqulo ye-Excel ngokucinezela u-Ctrl + Shift + Enter, ofaka ifomula phakathi kwezibini zokuvula nokuvala ().

/ Ukubala njani iziphumo ezininzi kuluhlu lwe-Excel?

Ukubala iziphumo ezininzi usebenzisa ifomula yoluhlu, faka uluhlu kuluhlu lweeseli ezinenani elifanayo lemiqolo kunye neekholamu oza kuzisebenzisa kwiingxoxo eziludinganayo. Khetha uluhlu lweeseli apho ufuna ukufaka ifomula yoluhlu. Ngenisa ifomula ofuna ukuyisebenzisa.