Sebenzisa izinkomba zeseli bese ukhomba ukuphindaphinda ku-Excel
Njengazo zonke izibalo zokusebenza eziyisisekelo ku-Excel, ukwandisa izinombolo ezimbili noma ngaphezulu kuhilela ukudala ifomula.
Amaphoyinti abalulekile okufanele akhumbule ngamafomula e-Excel:
- Amafomula e-Excel aqala ngaso sonke isibonakaliso esifanayo ( = ).
- Uphawu olulinganayo luya njalo esitokisini lapho ufuna impendulo iboniswe khona.
- Uphawu lokuphindaphinda noma opharetha elisetshenziselwa amafomu e-Excel yisimboli se-asterisk ( * ).
Ukusebenzisa Ukubhekisela Kwezingqimba Ngamafomula
Nakuba kungenzeka ukufaka izinombolo ngqo kwifomula, kungcono kakhulu ukufaka idatha kumaseli okusebenzela bese usebenzisa amakheli noma izinkomba zalawo maseli kufomula.
Inzuzo eyinhloko yokusebenzisa izingqikithi zamangqamuzana kwifomula, kunokuba idatha yangempela, yilokho, uma kwenzeka ngemuva kwesikhathi, kuyadingeka ukuthi ushintshe idatha, kuyindaba elula yokufaka idatha kumaseli athile kunokuba kubhale phansi ifomula.
Imiphumela yefomula izovuselela ngokuzenzekelayo uma idatha kumaseli athile ashintsha.
Ukufaka Izingcingo Zamaselula Ukusebenzisa Ukuveza
Futhi, yize kungenzeka ukuthi uthayiphe izingqikithi zeseli okufanele zisetshenziswe kwifomula, indlela engcono yokusebenzisa ikhomba ukufaka izinkomba zeseli.
Ukukhomba kuhilela ukuchofoza amaseli alitshekile aqukethe idatha nge-pointer yegundane ukufaka ireferensi yeseli kwifomula. Izinzuzo zokusebenzisa le ndlela ukuthi ukunciphisa amathuba okuba amaphutha adalwe ngokuthayipha kusithenjwa esingalungile se-cell.
I-Formula Yokuphindaphinda Isibonelo
Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sidala ifomula ku-cell C1 ezokwenza ukuthi iningi lenze idatha ku-cell A1 ngemininingwane ku-A2.
Ifomula eliqediwe ku-cell E1 kuyoba:
= A1 * A2
Ukufaka idatha
- Thayipha inombolo engu- 10 kuseli ye-A1 bese ucindezela ukhiye we- Enter kukhibhodi,
- Thayipha inombolo engu- 20 kuseli A2 bese ucindezela ukhiye we- Enter ,
Ukufaka iFomula
- Chofoza kuseli C1 ukuze wenze iseli elisebenzayo - yilapho imiphumela yefomula izoboniswa khona.
- Thayipha = ( uphawu olulinganayo ) kuseli C1.
- Chofoza ku- cell A1 ngesinathisi segundane ukuze ufake leyo reference yocingo kwifomula.
- Thayipha * ( uphawu lwe-asterisk ) emva kwe-A1.
- Chofoza kuseli ye-A2 ngesininathisi segundane ukuze ufake leyo reference yeselula.
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula.
- Impendulo engu-200 kufanele ibe khona esitokisini C1.
- Ngisho noma impendulo iboniswa esitokisini C1, ukuchofoza kulelo seli kuzobonisa ifomula langempela = A1 * A2 ebhafini yefomula ngaphezulu kwephepha lokusebenzela.
Ukushintsha idatha yefomula
Ukuhlola ukubaluleka kokusebenzisa izingqikithi zeseli kwifomula:
- Shintsha inombolo ku- cell A2 kusuka ku-20 ukuya ku-5 bese ucindezela ukhiye we- Enter ekhibhodi.
Impendulo kuseli C1 kufanele ivuselelwe ngokuzenzakalelayo ibe ngu-50 ukuze ibonise ushintsho kwedatha kuseli A2.
Ukushintsha ifomu
Uma kudingekile ukulungisa noma ukushintsha ifomula, izinketho ezimbili ezinhle kakhulu ziyi:
- Chofoza kabili ifomula ekhasini lokusebenzela ukuze ubeke i-Excel ku- Hlela imodi bese wenza izinguquko kwifomula. Lokhu kusebenza kangcono izinguquko ezincane.
- Chofoza kanye esitokisini esinefomula bese ubhala kabusha yonke ifomula. Le ndlela ingcono kakhulu ekushintsheni okukhulu.
Ukwakha amafomula amaningi anzima
Ukubhala amafomula amaningi adidayo afaka imisebenzi eminingi - njengokukhipha, ukuhlanganisa, nokuhlukanisa, nokuphindaphinda - faka nje opharetha abalingani bezibalo ngokulandelana okulungile okulandelwa izinkomba ezigciniwe eziqukethe idatha.
Ngaphambi kokuxuba imisebenzi ehlukene yezibalo ndawonye kwifomula, noma kunjalo, kubalulekile ukuqonda ukulandelana kwemisebenzi eyenziwa yi-Excel uma kuhlolwa ifomula.
Ukuze wenze umkhuba, zama lesi sinyathelo nesinyathelo sesiteleka sefomula eyinkimbinkimbi .