Enye yezona zinto zithandwa kakhulu zisebenza ngefomula. Ngenxa yomsebenzi, inkqubo ngokuzimeleyo ivelisa ukubalwa okwahlukeneyo kwiitheyibhile. Kodwa ngamanye amaxesha kuyenzeka ukuba umsebenzisi ungena kwifomula esiseleni, kodwa akakufezekisi indawo yalo ethe ngqo - ukubala iziphumo. Masijongane nantoni na enokuqhagamshelwa kunye nendlela yokusombulula le ngxaki.
Ukupheliswa kweengxaki zekhompyuter
Unobangela weengxaki ekubalweni kwefomula e-Excel kungahluke ngokupheleleyo. Banokubakho ngenxa yeesetingi zencwadi ezithile okanye uluhlu lweeseli kunye neempazamo ezahlukeneyo kwi-syntax.Indlela yoku-1: Utshintsho kwifomathi yeselfowuni
Enye yezizathu eziqhelekileyo zokuba uninzi lwe-Explil lungaqwalaseli okanye aliqwalaseli ngokuchanekileyo ifomula, yindlela ecacileyo yeeseli. Ukuba uluhlu lunefomathi yesicatshulwa, ubalo lwamabinzana owenziweyo akwenziwanga konke konke, oko kukuthi, zibonisiwe njengombhalo oqhelekileyo. Ngamanye amaxesha, ukuba ifomathi ayihambelani nedatha ebaliweyo, isiphumo esisuswe kwiseli asinakuboniswa ngokuchanekileyo. Masifumanise ukuba ungayisombulula njani le ngxaki.
- Ukuze ubone ukuba yeyiphi ifomati iseli ethile okanye uluhlu, yiya kwithebhu "yasekhaya". Kwiteyiphu kwi "Inombolo" yesixhobo sebloko kukho intsimi yokubonisa ifomathi yangoku. Ukuba kukho intsingiselo "yesicatshulwa", ke ifomula ayizukufumana ngokuchanekileyo.
- Ukwenzela ukutshintsha ifomathi ukuze ucofe kule ntsimi. Uluhlu lokukhetha ukufomatha luya kuvulwa, apho ungakhetha ixabiso elihambelana nomxholo wefomula.
- Kodwa ukhetho lwefomathi yefomathi ngeteyipi ayisibanzi kakhulu ngefestile ekhethekileyo. Ke ngoko, kungcono ukusebenzisa ukhetho lwesibini lokufomatha. Khetha uluhlu lwethagethi. Cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yokujonga umxholo, khetha into "yefomathi". Unako kwakhona emva kokuhlukanisa, cofa i-CTRL + 1 Indibaniselwano ephambili.
- Ifestile yokufomatha ivuliwe. Yiya kwi-theb "yenombolo". Kwi "fomus" zamanani ", khetha ifomathi esiyifunayo. Ukongeza, kwicala lasekunene lefestile, kunokwenzeka ukuba ukhethe uhlobo lwefomathi ethile. Emva kokhetho lwenziwe, cofa kwiqhosha "Kulungile", ibekwe ezantsi.
- Khetha iiseli ngenye indlela ebengakhange ithathelwe ingqalelo, kwaye ukuphindaphinda, cinezela iqhosha le-F2 umsebenzi.
Ngoku ifomula iya kubalwa kwi-oda emiselweyo kunye nemveliso yesiphumo kwiseli echaziweyo.
Indlela yesi-2: Ukuhambisa imowudi "yoBoniso yeFomulas"
Kodwa kunokwenzeka ukuba endaweni yokubala iziphumo, ubonakalise amabinzana, kukuba inkqubo "yobonise ifomula" ibandakanyiwe kwinkqubo.
- Ukwenza umboniso wesiphumo, yiya kwi "formou" ithebhu. Kwiteyiphu kwibhloko "yokuxhomekeka", ukuba iqhosha elithi "Demigu" liyasebenza, emva koko ucofe kuyo.
- Emva kwezi zenzo kwiiseli kwakhona, isiphumo siya kuboniswa endaweni yemisebenzi.
Indlela 3: Ukulungiswa kwempazamo kwi-syntax
Ifomula inokuboniswa njengesicatshulwa ukuba iimpazamo zenziwe kwi-syntax yayo, umzekelo, ileta idluliselwe okanye itshintshiwe. Ukuba ungene kuwo ngesandla, kwaye hayi ngemisebenzi ye-Master, ke ngokunjalo. Impazamo eqhelekileyo kakhulu ehambelana nokuboniswa kwentetho, njengombhalo, bubukho besithuba ngaphambi komqondiso "=".
Kwiimeko ezinjalo, kunyanzelekile ukuba kuphononongwe ngononophelo i-syntax yezo foryas eziboniswe ngokuchanekileyo kwaye zenze uhlengahlengiso olufanelekileyo.
Indlela yesi-4: Ukubandakanya ukuphindaphinda kwefomula
Kukho imeko enjalo apho ifomula ibonakala ibonakala kwaye ibonisa ixabiso, kodwa xa itshintsha iiseli ezinxulunyaniswa nayo ngokwayo ayitshintshi, oko kukuthi, isiphumo asiphinde saphinda saphinda saphinda siphinde saphinde. Oku kuthetha ukuba ungacwangciswanga kakuhle iiparameter zokubala kule ncwadi.
- Yiya kwi "Ifayile" yethebhu. Ukuba kuko, kuya kufuneka ucofe into "ye-parameters".
- Ifestile yeparamitha ivula. Kuya kufuneka uye kwicandelo "yefomulas". Kwi-"ye-Compmation" ibhloko, ekho ngaphezulu kwefestile, ukuba kwi "Ibalwa kwincwadi ethi" Ipharamitha, i-Switch "isikhundla se- Ukubala akunamsebenzi. Phinda uhlengahlengise ukutshintshela kwisikhundla esifunayo. Emva kokwenza useto olungentla ukuba lusindise ezantsi kwefestile, cofa iqhosha u- "Kulungile".
Ngoku zonke iinkcazo kule ncwadi ziya kuphinda ziphinde ziphinde ziphinde ziphinde ziphinde zenzeke ngokuzenzekelayo xa kukho naluphi na utshintsho olunxulumene noko.
Indlela yesi-5: Impazamo kwifomula
Ukuba le nkqubo isenza ukubala, kodwa ngenxa yoko ibonisa impazamo, ke imeko inokuba ngumsebenzisi ophosakeleyo xa ungena kwintetho. Iifomula eziphosakeleyo ngabo xa zibalwa ezixabiso zilandelayo kwiseli:
- #Umber!;
- # Kuthetha!;
- # Ingenanto !;
- # Del / 0!;
- # N / d.
Kule meko, kuya kufuneka ujonge ukuba idatha irekhodiweyo irekhodiwe kwi-Cells ithwalwe libinzana, nokuba akukho zimpazamo kwi-syntax okanye azibekwe kwifomula ye-Syntax okanye ayibekwanga naliphi na inyathelo elichanekileyo (umzekelo, iCandelo ngo-0).
Ukuba umsebenzi unzima, unenani elikhulu leeseli ezinxulumene nazo, kulula ukulandelela ukubala usebenzisa isixhobo esikhethekileyo.
- Khetha iseli ngempazamo. Yiya kwi "formoulas" ithebhu. Kwiteyiphu kwi-Tool "yokuxhomekeka" kwibloko ngokunqakraza kwi "Ukubala iFomyula".
- Ifestile ivula, ebonakala ibalo elipheleleyo. Cofa kwindawo ethi "Bala" kwaye ujonge ukubalwa kwenyathelo ngenyathelo. Sikhangela impazamo kwaye siyiphelise.
Njengoko sibona, izizathu zokuba i-Excel ayiqwalaseli okanye ayiqwalaseli ngokuchanekileyo ifomula, inokuba yahluke ngokupheleleyo. Ukuba umsebenzisi uyaboniswa endaweni yokubala umsebenzisi, lo msebenzi ngokwawo uyaboniswa, kule meko, kunokwenzeka, okanye iseli ifomathiwe itekisi, okanye i-ufmili yembono icinyiwe. Kwakhona, kunokwenzeka ukuba impazamo kwi-syntax (umzekelo, ubukho besithuba ngaphambi kwe "=" uphawu). Ukuba emva kokutshintsha idatha kwiiseli ezinxulumene noko, isiphumo asihlaziywa, ke kufuneka ubone ukuba uhlaziyo lwe-Auto lucwangciswe njani kwiiparameter zencwadi. Kwakhona, rhoqo endaweni yesiphumo esichanekileyo kwiselfowuni iboniswa impazamo. Apha kufuneka ujonge onke amaxabiso abhekiswa kulo msebenzi. Kwimeko yokufunyanwa kwempazamo, kufuneka isuswe.