Kusukela esandleni sale ndatshana, sizokunikeza isifinyezo esifushane mayelana ne Amaphutha we-Formula ku-Excel ezivame kakhulu namuhla ukuze wazi ukuthi ungazibona kanjani ngesikhathi sokuqala.
Konke odinga ukukwazi
Amaphutha we-Formula ku-Excel: Okuvame kakhulu
Ngokuqinisekile ube nethuba lokusebenzisa uhlelo oludumile lweMicrosoft Excel izikhathi ezingenakubalwa, ubona ukuthi lube, ngaphandle kokungabaza, olunye lwezinhlelo ezisebenza kakhulu kuyo yonke iminyaka. Kodwa-ke, ukusebenzisa kabi noma yimiphi imisebenzi yayo kungashintsha umphumela wokugcina ngokuphelele.
Uhlelo oludumile lusebenza namafomula asebenza ngamanani ahambisanayo noma amanani aphelele; kodwa-ke, kunezinye izinhlobo zamafomula ezenza ukusetshenziswa kwazo kube nzima, ngoba azisetshenziswa njalo.
Amanye Amaphutha we-Formula ku-Excel
Silungiselele uhlu olungakholeki lapho kuzovela khona amanye amaphutha we-Excel Formula ajwayelekile, ukuze ukwazi ukubona ukuthi ibiyini inkinga ebikuthinta ngezikhathi ezehlukene. Lapho sekucacile lokho, sizodlula kolunye uhlu lapho izixazululo zalezi zinkinga zizokhonjiswa khona.
Ukungasebenzisi uphawu lokulingana
Kukholwe noma ungakukholwa, kunabantu abakhohlwa ukusebenzisa uphawu olulinganayo oludumile lapho beqala ifomula. Lokhu kwenzeka ikakhulu ngenxa yokuthi uyashesha; yingakho lapho ufuna ukwenza ifomula, uhlelo lukuthatha njengokuqukethwe okujwayelekile noma ukukuguqula kube yidethi.
Shiya ngaphandle kwabakaki
Njengasesimweni esedlule, ukusebenza ngokubambisana nabakaki abathile kungadida kancane; lokhu akwenzeki kaningi ngamafomula alula. Kodwa-ke, kujwayelekile ukuthi abantu, lapho benza amafomula athe xaxa, bakhohlwe umzali oyedwa noma bobabili ngesikhathi esithile kwifomula.
Engazi ukuthi angalukhombisa kanjani uhla
Indlela eyiyo yokukhombisa ububanzi isebenzisa kuphela ikholoni edumile; isibonelo kungaba: C1: D1. Indlela engafanele (abantu abaningi abebengayenza benganakile) ukusebenzisa olunye uphawu noma uphawu noma ukufaka isikhala, ngaleyo ndlela, iRange izogcina ikhombisa njengoNull.
Izimpikiswano ezifakwe kabi
Leli elinye lamaphutha ajwayelekile lapho kwenziwa ifomula, lokhu kungenxa yobunzima obutholwa uhlobo oluthile lwazo. Ngenxa yezinga layo lokuxakaniseka, size sishiye eminye imininingwane edingeka kwifomula; noma singabuye sigxile ohlangothini oluphambene: faka imininingwane eminingi kakhulu kunalokho okuceliwe.
Kufanele sihlole amahlandla ambalwa ngaphambi kokwenza ifomula, ukuthi yakhiwe kanjani ukuze singaphinde senze iphutha elifanayo.
Izinombolo ezifakiwe
Into enhle ongayenza ukufaka izinombolo kwifomathi yezwi nezwi, kungafaki ukufomatha okuthile; Lokhu kungenxa yokuthi uma kufakwa uphawu olungafanele ukuba lapho, ifomula izothatha lelo phawu ngesihlukanisi. Isibonelo esivame kakhulu ukufuna ukumaka izinkulungwane ngamachashazi.
Hlanganisa amanye amaSpredishithi ngendlela engafanele
Lapho sifuna ukukhombisa umugqa, iseli noma ikholomu ngefomula, sizithola sijoyina ispredishithi esithile. Lokhu kufanele kwenziwe kusetshenziswa izingcaphuno.
Uma olunye uhlobo lophawu lusetshenziswa njengesihlukanisi, ifomula izothatha idatha njengephutha futhi ngeke ivumele umsebenzi ophambili ukuthi wenze kahle.
Ngakolunye uhlangothi, uma ufuna ukukhomba isihloko esithile eshidini, kufanele usebenzise iphuzu lokumemeza. Isibonelo kungaba ukuthi: 'Ishidi 3'! A1, ukukhombisa isihloko esitholakala kuseli A1 kushidi lokusebenzela leShidi 3.
Amaphutha we-Formula ku-Excel: Isixazululo sokuqala
Cishe ubungazi, kepha i-Excel inesici esimangazayo esaziwa ngokuthi yi-Error Checking, eyenziwe ngenhloso eyodwa: ukuqinisekisa ukuthi wonke amafomula asetshenziswe eshidini alungile.
Ukuya ku- "Ifayela", bese ku- "Izinketho ze-Excel" bese ku- "Amafomula", inketho izovela ngaphansi kwegama elithi "Vumela Ukuhlola Iphutha Langemuva". Le nketho izophatha ukukhombisa konke Amaphutha we-Formula ku-Excel ngunxantathu osendaweni engenhla kwesokunxele sebhokisi elinephutha.
Ngaphezu kwalokhu, kungenzeka ukwenza ngezifiso ukuqinisekiswa kwamafomula ngokwenza kusebenze noma kungasebenzi imithetho ethile efana nale: "Amafomula Okuhlanganayo namanye Amafomula Esifundeni", "Amaseli Aqukethe Amafomula aholela Kwiphutha", "Amafomula abhekisa ku Amaseli angenalutho "," Amafomula ashiya Amaseli esifundeni "noma" Idatha etafuleni ayivumelekile "ngaphezu kokuba nezinye izinketho eziningi.
Ngakolunye uhlangothi, kungenzeka ukuthola amaphutha ngesandla. Ngokuchofoza ku- «Amafomula» bese kuthi ku- «Formula Auditing», ukuze ukwazi ukuchofoza ku- «Error Checking». Kuzovela iwindi elibonisa iphutha elitholwe kushidi.
Amaphutha we-Formula ku-Excel: Isixazululo Sesibili
Ngakolunye uhlangothi, uma sifuna ukuhlaziya amaphutha efomula, kufanele sichofoze ku- «Start» bese ku- «Hlela», bese ku- «Search bese ukhetha», bese ku- «Go to Special» bese ekugcineni ku- «Formulas» futhi sizokhombisa ekuhloleni «Amaseli anamafomula».
Ngemuva kwalokho, chofoza ku-Formulas box bese ku- "Formula Audit", ukhethe "Ukuhlola" bese ufaka. Uhlu lwamafomula luzovela ukuze ukwazi ukuhlaziya ngayinye yazo bese uthola iphutha.
Uma uthole ukuthi le ndatshana ilusizo, sikunikeza enye ethakazelisayo mayelana nokuhle kakhulu Ezinye izindlela eziya ku-Google Drayivu zamafayela akho.