Izinkinga ngamafomula kusipredishithi se-Excel

Izici ze-Excel zikuvumela ukuthi wenze izibalo cishe zanoma ibuphi ubunkimbinkimbi ngenxa yamafomula nemisebenzi. Nokho, ngezinye izikhathi abasebenzisi bangase bahlangabezane neqiniso lokuthi ifomula yenqaba ukusebenza noma inikeza iphutha esikhundleni somphumela abawufunayo. Kulesi sihloko, sizobheka ukuthi kungani lokhu kwenzeka, nokuthi yiziphi izinyathelo okufanele zithathwe ukuxazulula inkinga.

Isixazululo 1: Shintsha ifomethi yeseli

Kaningi, i-Excel iyenqaba ukwenza izibalo ngenxa yokuthi kukhethwa ifomethi yeseli engalungile.

Isibonelo, uma kucacisiwe ifomethi yombhalo, esikhundleni somphumela sizobona ifomula ngokwayo ngendlela yombhalo ongenalutho.

Kwezinye izimo, lapho ifomethi engalungile ikhethiwe, umphumela ungabalwa, kodwa uzoboniswa ngendlela ehluke ngokuphelele kunalokho esingathanda.

Ngokusobala, ifomethi yeseli idinga ukushintshwa, futhi lokhu kwenziwa kanje:

1. Ukuze unqume ifomethi yeseli yamanje (ububanzi bamaseli), yikhethe futhi, ngokuba kuthebhu "Ekhaya", qaphela iqembu lamathuluzi "Inombolo". Kunenkambu ekhethekile lapha ebonisa ifomethi esetshenziswayo njengamanje.
2. Ungakhetha enye ifomethi ohlwini ezovuleka ngemva kokuchofoza umcibisholo oya phansi eduze nenani lamanje.

Ifomethi yeseli ingashintshwa usebenzisa elinye ithuluzi elikuvumela ukuthi usethe izilungiselelo ezithuthuke kakhulu.

1. Ngemva kokukhetha iseli (noma ukhethe uhla lwamaseli), chofoza kwesokudla kulo futhi ohlwini oluvulayo, chofoza umyalo. "Ifomethi Yeseli". Noma esikhundleni salokho, ngemva kokukhetha, cindezela inhlanganisela Ctrl + 1.
2. Efasiteleni elivulekayo, sizozithola sikuthebhu "Inombolo". Lapha ohlwini olungakwesokunxele kukhona wonke amafomethi atholakalayo esingakhetha kuwo. Ngakwesokunxele, izilungiselelo zenketho ekhethiwe ziyaboniswa, esingazishintsha ngokubona kwethu. Cindezela uma usulungile OK.
3. Ukuze izinguquko zibonakale kuthebula, senza kusebenze imodi yokuhlela ngayinye ngayinye kuwo wonke amaseli lapho ifomula ingasebenzi khona. Ngemva kokukhetha into oyifunayo, ungaqhubeka nokuhlela ngokucindezela inkinobho F2, ngokuchofoza kabili kuyo, noma ngokuchofoza ngaphakathi kwebha yefomula. Ngemuva kwalokho, ngaphandle kokushintsha noma yini, chofoza Faka

Qaphela: Uma kunedatha eningi, kuzothatha isikhathi eside ukuqedela mathupha isinyathelo sokugcina. Kulokhu, ungenza okuhlukile - sebenzisa gcwalisa umaka. Kodwa lena isebenza kuphela uma ifomula efanayo isetshenziswa kuwo wonke amaseli.

1. Senza isinyathelo sokugcina kuphela seseli ephezulu kakhulu. Bese sihambisa i-pointer yegundane ekhoneni laso elingezansi kwesokudla, ngokushesha nje lapho kuvela uphawu olumnyama lokuhlanganisa, cindezela inkinobho yegundane kwesokunxele bese uyihudulela ekupheleni kwetafula.
2. Sithola ikholomu enemiphumela ebalwa kusetshenziswa amafomula.

Isixazululo 2: cisha imodi "Bonisa amafomula".

Uma sibona amafomula ngokwawo esikhundleni semiphumela, lokhu kungase kube ngenxa yokuthi imodi yokubonisa ifomula yenziwe yasebenza, futhi idinga ukuvalwa.

1. Shintshela kuthebhu "Amafomula". Eqenjini lamathuluzi "Ukuncika kufomula" chofoza inkinobho “Bonisa Amafomula”uma iyasebenza.
2. Ngenxa yalokho, amaseli anamafomula manje azobonisa imiphumela yezibalo. Yiqiniso, ngenxa yalokhu, imingcele yamakholomu ingashintsha, kodwa lokhu kuyalungiswa.

Isixazululo sesi-3: Cupha ukubala kabusha okuzenzakalelayo kwamafomula

Kwesinye isikhathi isimo singase sivele lapho ifomula ibala umphumela othile, nokho, uma sinquma ukushintsha inani kwelinye lamaseli lapho ifomula libhekisela khona, ukubala kabusha ngeke kwenziwe. Lokhu kulungisiwe ezinkethweni zohlelo.

1. Iya kumenyu "Fayela".
2. Khetha isigaba ohlwini olungakwesokunxele "Amapharamitha".
3. Efasiteleni elivelayo, shintshela esigatshaneni "Amafomula". Ngakwesokudla sewindi eqenjini "Izinketho Zekhompyutha" maka ibhokisi eduze kwenketho “ngokuzenzakalelayo”uma enye inketho ikhethiwe. Chofoza uma usulungile OK.
4. Konke sekumi ngomumo, kusukela manje yonke imiphumela yefomula izobalwa kabusha ngokuzenzakalelayo.

Isixazululo 4: ukulungisa amaphutha kufomula

Uma amaphutha enziwa kufomula, uhlelo lungayibona njengenani lombhalo elilula, ngakho-ke, izibalo kulo ngeke zenziwe. Isibonelo, elinye lamaphutha adume kakhulu isikhala esibekwe ngaphambi kophawu "kuyalingana". Ngesikhathi esifanayo, khumbula ukuthi isibonakaliso "=" kufanele njalo ize ngaphambi kwanoma iyiphi ifomula.

Futhi, ngokuvamile amaphutha enziwa kuma-syntaxes okusebenza, njengoba ukuwagcwalisa akulula ngaso sonke isikhathi, ikakhulukazi uma kusetshenziswa izimpikiswano eziningi. Ngakho-ke, sincoma ukusebenzisa Isilekeleli somsebenzi ukufaka umsebenzi kuseli.

Ukuze wenze ifomula isebenze, okudingeka ukwenze nje ukuyihlola ngokucophelela bese ulungisa noma imaphi amaphutha atholakele. Esimweni sethu, udinga nje ukususa isikhala ekuqaleni, okungadingeki.

Kwesinye isikhathi kulula ukususa ifomula bese uyibhala futhi kunokuzama ukubheka iphutha kweyovele ibhaliwe. Okufanayo kuya emisebenzini kanye nezimpikiswano zayo.

Amaphutha avamile

Kwezinye izimo, lapho umsebenzisi enza iphutha lapho efaka ifomula, amanani alandelayo angase aboniswe kuseli:

• #DIV/0! kuwumphumela wokuhlukaniswa ngoziro;
• #N/A – okokufaka kwamanani angavumelekile;
• #INOMBOLO! - inani lenombolo elingalungile;
• #INANI! - uhlobo olungalungile lwempikiswano lusetshenziswe emsebenzini;
• #AKUNALUTHO! - ikheli lebanga elingalungile;
• #XHUMANA! – iseli okukhulunywa ngalo ifomula lisusiwe;
• #IGAMA? – igama elingavumelekile kufomula.

Uma sibona elinye lamaphutha angenhla, okokuqala sibheka ukuthi yonke idatha kumaseli abamba iqhaza kufomula igcwaliswe ngendlela efanele yini. Bese sihlola ifomula ngokwayo kanye nokuba khona kwamaphutha kuyo, kuhlanganise nalawo aphikisana nemithetho yezibalo. Isibonelo, ukuhlukaniswa ngoziro akuvunyelwe (iphutha #DEL/0!).

Ezimeni lapho kufanele ubhekane nemisebenzi eyinkimbinkimbi ebhekisela kumaseli amaningi, ungasebenzisa amathuluzi okuqinisekisa.

1. Simaka iseli eliqukethe iphutha. Kuthebhu "Amafomula" eqenjini lamathuluzi "Okuncike kufomula" cindezela inkinobho "Bala ifomula".
2. Ewindini elivulayo, imininingwane yesinyathelo nesinyathelo ekubaleni izovezwa. Ukuze wenze lokhu, cindezela inkinobho “Bala” (umshini ngamunye uthuthukela esinyathelweni esilandelayo).
3. Ngakho, ungakwazi ukulandelela isinyathelo ngasinye, uthole iphutha futhi ulilungise.

Ungasebenzisa futhi eziwusizo ithuluzi "Iphutha Lokuhlola", etholakala endaweni efanayo.

Iwindi lizovuleka lapho imbangela yephutha izochazwa khona, kanye nenani lezenzo eziphathelene nalo, kuhlanganisa. ukulungiswa kwebha yefomula.

Isiphetho

Ukusebenza ngamafomula nemisebenzi kungenye yezici eziyinhloko ze-Excel, futhi, yiqiniso, enye yezindawo eziyinhloko zokusetshenziswa kohlelo. Ngakho-ke, kubaluleke kakhulu ukwazi ukuthi yiziphi izinkinga ezingavela lapho usebenza namafomula, nokuthi zingalungiswa kanjani.