Ungawalungisa kanjani amaphutha efomula ye-Excel avamile
Kunamaphutha amabili efomula ahlukene ongawabona ku-Excel. Nakhu ukubheka ezinye ezivame kakhulu nokuthi ungazilungisa kanjani.
- #Inani : Zama ukususa izikhala kufomula noma idatha kushidi leselula, futhi uhlole umbhalo ukuze uthole izinhlamvu ezikhethekile. Kufanele futhi uzame ukusebenzisa imisebenzi esikhundleni semisebenzi.
- Igama# : Sebenzisa isibambi somsebenzi ukuze ugweme amaphutha egrama. Khetha iseli eliqukethe ifomula, nakuthebhu ifomula , Chofoza faka umsebenzi .
- #####: Chofoza kabili isihloko esingenhla kweseli noma uhlangothi lwekholomu ukuze uyinwebe ngokuzenzakalelayo ukuze ilingane nedatha.
- #NUM: Hlola amanani ezinombolo nezinhlobo zedatha ukuze ulungise lokhu. Leli phutha lenzeka lapho kufakwa inani lezinombolo ngohlobo lwedatha olungasekelwe noma ifomethi yezinombolo esigabeni sokungqubuzana sefomula.
Njengomuntu osebenza ebhizinisini elincane noma kwenye indawo, ngenkathi usebenza kuspredishithi se-Excel, ungagcina uhlangabezana nekhodi yephutha ngezinye izikhathi. Lokhu kungaba ngenxa yezizathu ezahlukahlukene, noma ngabe iphutha kudatha yakho, noma iphutha kufomula yakho. Kunamaphutha amabili ahlukene amele lokhu, futhi kumhlahlandlela wakamuva we-Microsoft 365, sizochaza ukuthi ungawalungisa kanjani.
Indlela yokugwema amaphutha
Ngaphambi kokuthi singene emaphutheni efomula, sizobheka ukuthi singawagwema kanjani ngokuphelele. Amafomula kufanele ngaso sonke isikhathi aqale ngophawu olulinganayo, futhi uqiniseke ukuthi usebenzisa u-“*” ukuze uphindaphinde esikhundleni sika-“x.” Ukwengeza, bheka ukuthi ubasebenzisa kanjani abakaki kumafomula akho. Okokugcina, qiniseka ukuthi usebenzisa izingcaphuno ezizungeze umbhalo kumafomula akho. Ngalawa macebiso ayisisekelo, cishe ngeke uhlangabezane nezindaba esizoxoxa ngazo. Kodwa, uma usekhona, sinomhlane wakho.
Iphutha (#Value!)
Leli phutha lefomula elivamile ku-Excel lenzeka lapho kukhona okungalungile ngendlela obhala ngayo ifomula yakho. Ingase futhi ibonise isimo lapho okuthile okungalungile ngamaseli obhekisela kuwo. I-Microsoft iphawula ukuthi leli iphutha elijwayelekile ku-Excel, ngakho-ke kunzima ukuthola imbangela efanele yalokhu. Ezimweni eziningi, kuyinkinga yokukhipha noma izikhala nombhalo.
Njengokulungisa, kufanele uzame ukususa izikhala kufomula noma idatha kushidi leseli, futhi uhlole umbhalo ukuze uthole izinhlamvu ezikhethekile. Kufanele futhi uzame ukusebenzisa imisebenzi esikhundleni semisebenzi, noma uzame ukuhlola umthombo wephutha lakho ngokuchofoza amafomula Ngemuva kwalokho Ukuhlolwa kwefomula Ngemuva kwalokho Ukuhlola. Uma konke kwehluleka, siphakamisa ukuthi uhlole ikhasi lokusekela le-Microsoft, Lapha Ukuze uthole amathiphu engeziwe.
Iphutha (#Igama)
Elinye iphutha elivamile ngu-#Name . Lokhu kwenzeka uma ufaka igama elingalungile ohlelweni noma ifomula. Lokhu kusho ukuthi kukhona okumele kulungiswe ku-syntax. Ukuze ugweme leli phutha, kuphakanyiswa ukusebenzisa iwizadi yefomula ku-Excel. Uma uqala ukuthayipha igama lefomula kuseli noma kubha yefomula, uhlu lwamafomula afana namagama owafakile luvela ohlwini lokudonsela phansi. Khetha ifomethi lapha ukuze ugweme izinkinga.
Ngenye indlela, iMicrosoft iphakamisa ukusebenzisa i-Function Wizard ukugwema amaphutha egrama. Khetha iseli eliqukethe ifomula, nakuthebhu ifomula , Chofoza faka umsebenzi . I-Excel izobe izokulayishela iwizadi.
Iphutha #####
Okwesithathu ohlwini lwethu yinye okungenzeka ukuthi uyibone kakhulu. Ngephutha elithi #####, izinto zingalungiswa kalula. Lokhu kwenzeka uma kukhona okungalungile ngokubuka kwesipredishithi, futhi i-Excel ayikwazi ukubonisa idatha noma izinhlamvu kukholomu noma ukubuka komugqa njengoba unayo. Ukuze ulungise le nkinga, mane uchofoze kabili unhlokweni phezulu kweseli noma ohlangothini lwekholomu ukuze uyinwebe ukuze ilingane idatha ngokuzenzakalelayo. Noma hudula amabha aleyo kholomu noma umugqa uye ngaphandle uze ubone idatha ivela ngaphakathi.
Iphutha #NUM
Okulandelayo ngu-#NUM. Kulokhu, i-Excel izobonisa leli phutha lapho ifomula noma umsebenzi uqukethe amanani ezinombolo angavumelekile. Lokhu kwenzeka uma ubeka inani lezinombolo usebenzisa uhlobo lwedatha olungasekelwe noma ifomethi yenombolo esigabeni sokungqubuzana sefomula.
Isibonelo, u-$1000 awukwazi ukusetshenziswa njengenani ngefomethi yohlobo lwemali.
Lokhu kungenxa yokuthi, kufomula, izimpawu zedola zisetshenziswa njengezikhombi eziphelele zereferensi namakhoma njengezihlukanisi ezimaphakathi kumafomula.
Hlola amanani ezinombolo nezinhlobo zedatha ukuze ulungise lokhu.
Amanye amaphutha
Sithinte kuphela amanye amaphutha avamile, kodwa kukhona amanye ambalwa esifuna ukuwasho ngokushesha. Enye yalezi #DIV/0 . Lokhu kwenzeka uma inombolo ekuseli ihlukaniswa ngoziro noma uma kukhona inani elingenalutho kuseli.
Kukhona, futhi #N/A , okusho ukuthi ifomula ayikwazi ukuthola lokho ebicelwe ukuthi yiseshe.
enye i #Ngeke. Lokhu kubonakala lapho kusetshenziswa u-opharetha wobubanzi obungalungile kufomula.
Ekugcineni, kukhona #REF . Lokhu kuvame ukwenzeka uma ususa noma unamathisela amaseli akhonjwe amafomula.
Amathiphu namaqhinga aphezulu we-Microsoft Excel ku-Office 5
