Ukukhipha izinombolo ezimbili noma ngaphezulu ku-Excel ngefomula
Ukukhipha izinombolo ezimbili noma ngaphezulu ku-Excel udinga ukwakha ifomula .
Amaphuzu abalulekile okufanele akhumbule mayelana namafomu e-Excel afaka:
- Amafomula e-Excel aqala ngaso sonke isibonakaliso esilinganayo ( = );
- Ifomula idluliswa njalo esitokisini lapho ufuna impendulo ivele khona;
- Uphawu lokukhipha ku-Excel yidash (-);
- Ifomula igcwaliswe ngokucindezela ukhiye wokungena kwikhibhodi.
Ukusebenzisa Ukubhekisela Kwezingqimba Ngamafomula
Nakuba kungenzeka ukungena izinombolo ngqo kwifomula (njengoba kuboniswe kumugqa wesibili wesibonelo), ngokuvamile kungcono kakhulu ukufaka idatha kumaseli okusebenza bese usebenzisa amakheli noma izinkomba zalawo maseli kufomula (umugqa 3 kwesibonelo).
Ngokusebenzisa izingqikithi zeseli kunokuba idatha yangempela kwifomu, kamuva, uma kudingekile ukushintsha idatha , kuyindaba elula yokufaka idatha kumaseli esikhundleni sokuphinda ubhale kabusha ifomula.
Imiphumela yefomula izovuselela ngokuzenzekelayo uma idatha ishintsha.
Enye indlela ukuhlanganisa izingqikithi zeseli kanye nedatha yangempela (umugqa wesi-4 wesibonelo).
Ukungeza i-Parenthesis
I-Excel inomyalelo wokusebenza okulandelayo uma uhlola ukuthi yimiphi imisebenzi yezibalo okumele ifeze kuqala kwifomula.
Njengoba nje esiklasini sezibalo, ukuhleleka kokusebenza kungashintshwa ngokusebenzisa i-parenthesis njengezibonelo eziboniswe emigqeni emihlanu nangesithupha ngaphezulu.
Isibonelo seFomula yefomula
Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sidala ifomu ku-cell D3 ezosusa idatha ku-cell A3 kusuka kudatha ku-B3.
Ifomula eqediwe kuseli D3 kuyoba:
= A3 - B3
Iphuzu bese uchofoze ku-References yeselula
Yize kungenzeka ukuthi uthayiphe ifomula engenhla ibe yiseli D3 futhi uphendule impendulo efanele, kungcono ukusebenzisa iphuzu bese uchofoze ukufaka izingcingo zeseli kumafomula ukuze unciphise amathuba okuba amaphutha adalwe ngokuthayipha esitokisini esingalungile inkomba.
Iphoyinti nokuchofoza kuhilela ukuchofoza amangqamuzana aqukethe idatha nge-pointer yegundane ukufaka ireferensi yeseli kwifomula.
- Thayipha uphawu olulinganayo ( = ) esitokisini D3 ukuze uqale ifomula.
- Chofoza kuseli le-A3 nge-pointer yegundane ukuze ungeze ukuthi ireferensi yeselula kwifomu ngemuva kwesibonakaliso esifanayo.
- Thayipha uphawu lokususa ( - ) ngemuva kokubhekisela kweseli.
- Chofoza kuseli B3 ukuze ungeze ukuthi ireferensi yeseli kwifomula ngemuva kwesignali encane.
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula.
- Impendulo 10 kufanele ibe khona esitokisini E3.
- Ngisho noma impendulo yefomula iboniswa esitokisini se-E3, ukuchofoza kulelo seli kuzobonisa ifomula ebhafini lefomula ngaphezu kwephepha lokusebenzela.
Ukushintsha idatha yefomula
Ukuze uhlole ukubaluleka kokusebenzisa izingqikithi zeseli kwifomula, yenza ushintsho kwinombolo esitokisini B3 (njengokuya kusuka ku-5 ukuya ku-4) bese ucindezela ukhiye we- Enter ekhibhodi. Impendulo ku-cell D3 kufanele ivuselelwe ngokuzenzakalelayo ukuze ibonise ushintsho kwedatha esitokisini B3.
Ukwakha amafomula amaningi anzima
Ukwandisa ifomula ukufaka imisebenzi eyengeziwe (njengokuhlukaniswa noma ukuhlanganisa) njengoba kuboniswe kumugqa wesikhombisa, qhubeka uqhubeka ukwengeza umsebenzisi ohambelana nezibalo olandelwa uchungechunge lweseli equkethe idatha entsha.
Ukuze wenze umkhuba, zama lesi sinyathelo nesinyathelo sesiteleka sefomula eyinkimbinkimbi .