Kungani i-Excel ingabheki ifomula: izixazululo ezi-5 zenkinga

Enye yezinto ezithandwa kakhulu ama-Excel zisebenza ngamafomula. Ngenxa yalo msebenzi, uhlelo ngokuzimela lukhiqiza izibalo ezahlukahlukene kumatafula. Kepha kwesinye isikhathi kwenzeka ukuthi umsebenzisi ungena kwifomula esitokisini, kepha akukufezi indawo yayo eqondile - ukubala umphumela. Masibhekane nalokho okungaxhunyaniswa nendlela yokuxazulula le nkinga.

Ukuqedwa kwezinkinga zekhompyutha

Izimbangela zezinkinga ngokubala amafomula ku-Excel zingahluka ngokuphelele. Zingabangelwa yizilungiselelo zezincwadi ezithile noma uhla oluhlukile lwamaseli namaphutha ahlukile kwi-syntax.

Indlela 1: Izinguquko ngefomethi yeselula

Enye yezizathu ezivame kakhulu zokuthi kungani i-Excel ingacabangi noma ingabhekisi kahle ifomula, ifomethi evezwe ngokungalungile yamaseli. Uma uhla lunefomethi yombhalo, ukubalwa kwezinkulumo kuyo akwenziwa nhlobo, okungukuthi, ziboniswa njengombhalo ojwayelekile. Kwezinye izimo, uma ifomethi ingahambelani nomongo wedatha ebaliwe, umphumela ohanjiswa esitokisini kungenzeka ungakhonjiswa kahle. Ake sibheke ukuthi ungayixazulula kanjani le nkinga.

1. Ukuze ubone ukuthi iyiphi ifomethi iseli noma ibanga elithile, iya kuthebhu "Yasekhaya". Ethepheni ku-Tool "Numbe" Block Block kukhona inkambu yokubonisa ifomethi yamanje. Uma kunencazelo "yombhalo", indlela ifomula ngeke ibalwe.



2. Ukuze ushintshe ifomethi ukuze uchofoze kulo mkhakha. Uhlu lokukhethwa kokufomatha luzovulwa, lapho ungakhetha khona inani elihambelana nomongo wefomula.



3. Kepha ukukhethwa kwezinhlobo zezinhlobo zefomethi ngetheyiphu akubanzi kabanzi ngewindi elikhethekile. Ngakho-ke, kungcono ukusebenzisa inketho yesibili yokufometha. Khetha ibanga eliqondiwe. Chofoza inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe, khetha into ethi "Ifomethi ye-Cell". Ungase futhi ngemuva kwebanga ukuhlukaniswa, chofoza inhlanganisela ye-CTRL + 1.



4. Iwindi lokufometha livula. Iya kuthebhu "Yenombolo". Evikini le-lea "Numeric" block, khetha ifomethi esiyidingayo. Ngaphezu kwalokho, ngakwesokunene sewindows, kungenzeka ukuthi ukhethe uhlobo lokwethulwa kwefomethi ethile. Ngemuva kokukhethwa kwenziwa, chofoza inkinobho ethi "Kulungile", ibekwe ezansi.



5. Khetha amaseli ngokuhlukile lapho umsebenzi wawungabhekwa khona, futhi ukuphindisela kabusha, cindezela inkinobho yokusebenza kwe-F2.

Manje ifomula lizobalwa ngokulandelana okujwayelekile ngokukhishwa komphumela kwiseli elishiwo.

Indlela 2: Ukunqamula imodi ye- "Show formulas"

Kepha kungenzeka ukuthi esikhundleni semiphumela yokubala, ukhonjiswa izinkulumo, ukuthi uhlelo "lukhombisa amafomula" kulolu hlelo.

1. Ukunika amandla ukubonisa kwemiphumela, iya kuthebhu "formula". Etheyipini "ekuthembekeni kokuxhomekeka kokuxhomekeka kwe-" Ukuthembela Ukuthembela "Ithuluzi, uma inkinobho" yokubonisa ifomula "iyasebenza, bese uchofoza kukho.



2. Ngemuva kwalezi zenzo kumaseli futhi, umphumela uzoboniswa esikhundleni se-syntax yemisebenzi.

Indlela 3: Ukulungiswa kwephutha ku-syntax

Ifomula nayo ingakhonjiswa njengombhalo uma kwenziwa amaphutha ku-syntax yayo, ngokwesibonelo, incwadi idluliswa noma ishintshiwe. Uma uyifaka ngesandla, hhayi ngemisebenzi master, khona-ke lokho kungenzeka. Iphutha elivame kakhulu elihambisana nokuboniswa kwenkulumo, njengombhalo, ukuba khona kwesikhala ngaphambi kwesibonakaliso "=".

Ezimweni ezinjalo, kuyadingeka ukubukeza ngokucophelela i-syntax yalawo mafomula aboniswe ngokungafanele futhi enze ushintsho olufanele.

Indlela 4: Ukufakwa kokubuyiselwa kabusha kwefomula

Kunesimo esinjalo sokuthi ifomula esibonakala ngayo futhi sibonisa inani, kepha lapho kushintsha amaseli ahambisana nakho akuguquki, okungukuthi, umphumela awukhokhiwe kabusha. Lokhu kusho ukuthi ulungiselele ngokungafanele amapharamitha wokubala kule ncwadi.

1. Iya kuthebhu ethi "File". Ukuba kuyo, kufanele uchofoze entweni ethi "parameters".



2. Iwindi lepharamitha liyavula. Udinga ukuya esigabeni "sefomula". Ku-block "yokukhangisa" i-block, etholakala phezulu kwewindi, uma ekubalweni "encwadini ethi" Ipharamitha, i-switch ayisethelwanga isikhundla se- "ngokuzenzakalelayo", lokhu kuyisizathu Izibalo azisebenzi. Hlela kabusha ukushintshela endaweni oyifunayo. Ngemuva kokukhipha lezi zilungiselelo ezingenhla ukuze uzigcine ezansi kwewindi, cindezela inkinobho ethi "KULUNGILE".

Manje zonke izinkulumo ezikule ncwadi zizophinde ziphinde ziphinde ziphinde ziphinde ziguquke lapho noma yiluphi uhlobo lwenani elihlobene.

Indlela 5: Iphutha kwifomula

Uma uhlelo lusabala ukubalwa, kepha ngenxa yalokho libonisa iphutha, khona-ke lesi simo kungenzeka ukuthi umsebenzisi umane nje unephutha lapho efaka le nkulumo. Amafomula ayiphutha yilawo lapho kubalwa ukuthi amanani alandelayo avela esitokisini:

• #Number!;
• # Kusho!;
• # Kungenalutho!;
• # Del / 0!;
• # N / d.

Kulokhu, udinga ukubheka ukuthi ngabe idatha iqoshwe kahle kumaseli abhekiswe yi-expression, noma ngabe awekho amaphutha ku-syntax noma ayibekwa efomula ngokwawo noma yisiphi isenzo esingalungile (ngokwesibonelo, ukuhlukaniswa ngo-0).

Uma umsebenzi uyinkimbinkimbi, ngenombolo enkulu yamaseli ahlobene, kulula ukulandelela ukubala usebenzisa ithuluzi elikhethekile.

1. Khetha iseli ngephutha. Iya kuthebhu "yefomula". Ethepheni ithuluzi "lokuncika kuncike ekuthembekeni" kwe-block block block ngokuchofoza inkinobho ethi "Bala formula".



2. Iwindi livula, okubonakala kubalwa okuphelele. Chofoza inkinobho ethi "Bala" bese ubuka ukubalwa kwesinyathelo ngesinyathelo. Sifuna iphutha futhi sikuqede.

Njengoba sibona, izizathu zeqiniso lokuthi i-Excel ayicabangi noma ayibheki kahle ifomula, ingahluka ngokuphelele. Uma umsebenzisi ekhonjiswa esikhundleni sokubala umsebenzisi, umsebenzi uqobo uyakhonjiswa, kulokhu, kungenzeka, noma iseli lihlelwe ngombhalo, noma imodi yokubuka inkulumo ivuliwe. Futhi, kungenzeka kube yiphutha kwi-syntax (ngokwesibonelo, ukuba khona kwesikhala ngaphambi kwesibonakaliso se- "="). Uma ngemuva kokushintsha idatha kumaseli ahlobene, umphumela awuvuselelwa, khona-ke udinga ukubona ukuthi ukuvuselelwa okuzenzakalelayo kulungiselelwe kanjani kumapharamitha wencwadi. Futhi, imvamisa esikhundleni somphumela ofanele kuseli Kuboniswa iphutha. Lapha udinga ukubuka wonke amanani abhekiswe umsebenzi. Uma kwenzeka ukutholwa kwephutha, kufanele kuqedwe.