Okuqukethwe
Elinye lamathuluzi anamandla ku-Excel yikhono lokwenza amafomula. Ungasebenzisa amafomula ukuze ubale amanani amasha, uhlaziye idatha, nokuningi. Kodwa ukusebenza ngamafomula kunobubi bakho - iphutha elincane lanele ukuthi ifomula inikeze umphumela ongalungile.
Okubi kunakho konke, i-Excel ayihlali ibika iphutha kufomula. Njengomthetho, ifomula enjalo iyaqhubeka nokusebenza futhi yenza izibalo, inikeze umphumela oyiphutha. Isibopho sokuthi uphinde uvilaphe kakhulu ukuhlola ifomula ukuwe ngokuphelele.
Sihlanganise uhlu lweziqondiso ongazisebenzisa ukuze uhlole ukufaneleka kwamafomula adaliwe. Lawa macebiso ngeke axazulule zonke izinkinga ozohlangabezana nazo, kodwa azokunikeza ithuluzi lokuhlonza amaphutha amaningi avamile.
Hlola izixhumanisi
Amafomula amaningi asebenzisa okungenani ireferensi yeseli eyodwa. Uma uchofoza kabili kufomula, imingcele yawo wonke amaseli abaluliwe izogqanyiswa. Ungaphinda uhlole isixhumanisi ngasinye ukuze uqiniseke ukuthi silungile.
Bheka izimvume
Iphutha elivamile ukusebenzisa izinkomba zeseli ezifanele kodwa ngokulandelana okungalungile. Isibonelo, uma ufuna ukususa C2 of C3, ifomula kufanele ibe: =C3-C2, hhayi kanje: =C2-C3.
Ihlukanise
Uma ifomula iyinkimbinkimbi kakhulu ukuthi ungayihlola, zama ukuyihlukanisa ibe amafomula ambalwa alula. Ngakho-ke, ungabheka ukunemba kwefomula ngayinye, futhi uma kuphakama izinkinga, uzokwazi kahle ukuthi kuphi.
Cabanga ngokuthi umphumela kufanele ube yini
Ungasebenzisa isipiliyoni sakho siqu, ukucabanga okujulile kanye ne-intuition ukuze unqume ukuthi umphumela kufanele ube yini. Uma umphumela ku-Excel umkhulu kakhulu noma umncane kunokulindelekile, kungase kube namaphutha kufomula (noma idatha engalungile kumaseli).
Isibonelo, uma ubala izindleko eziphelele 8 amayunithi wezimpahla 98 amasenti ngayinye, umphumela kufanele ube ngaphansi kancane $8. Esibonelweni esingezansi, ifomula inikeza umphumela oyiphutha. $ 784,00. Isizathu siwukuthi kuseli A2 intengo ifakwa njenge 98, futhi kufanele kube 0,98. Njengoba ubona, imininingwane emincane ingenza umehluko omkhulu.
Khumbula ukuthi leli qhinga alisebenzi ngaso sonke isikhathi. Kwezinye izimo, impendulo engalungile ingaba eduze ngokuphawulekayo kwelungile. Nokho, ezimweni eziningi, ukuhlola okusheshayo okunjalo kuveza iphutha kufomula.
Hlola Izimpikiswano
Uma usebenza ngomsebenzi, qiniseka ukuthi zonke izimpikiswano ezidingekayo zinikeziwe. Lapho ufaka umsebenzi, ithiphu elincane lamathuluzi elinama-agumenti adingekayo kufanele liboniswe.
Ithiphu yamathuluzi iwusizo ikakhulukazi uma uzama ukulungisa isici esingasebenzi kahle. Isibonelo, bheka umsebenzi ongezansi:
Esibonelweni esikumfanekiso ongenhla, umsebenzi IZINSUKU ZEnethiwekhi (NETWORKDAYS) ibuyisela iphutha. Uma sethula umsebenzi IZINSUKU ZEnethiwekhi (NETWORKDAYS) kwenye iseli, isizathu siba sobala:
Umsebenzi IZINSUKU ZEnethiwekhi (NETWORKDAYS) idinga ubuncane bezimpikiswano ezimbili − usuku okuqalwa ngalo (usuku_lokuqala) kanye idethi_yokuphela (idethi_yokuphela). Esibonelweni sangaphambilini, i-agumenti eyodwa kuphela inikezwe, ngakho-ke masilungise umsebenzi ngokungeza i-agumenti engekho:
Manje ifomula yethu isebenza kahle!
Hlola lonke uchungechunge lwemisebenzi (ukulandelana)
Khumbula ngezibalo zesikole ithini i-oda lokusebenza kwezibalo? Uma kungenjalo (noma uma ufuna ukuvuselela inkumbulo yakho), ungafunda isifundo sokwakha amafomula ayinkimbinkimbi. I-Excel isebenzisa le oda njalo, okungukuthi, imisebenzi ayenzi nje ngokushintshana ukusuka kwesokunxele kuye kwesokudla. Esibonelweni esilandelayo, isinyathelo sokuqala ukuphindaphinda, okungekona kanye lokhu ebesikufuna. Ake silungise le fomula ngokuphetha I-D2+D3 kubakaki:
Vula isibonisi sefomula
Uma kunamafomula nemisebenzi eminingi eshidini le-Excel, kungase kube lula kakhulu kuwe ukuthi ushintshele kumodi yokubonisa ifomula ukuze ubone wonke amafomula ngesikhathi esisodwa. Ukuze wenze lokhu, udinga ukusebenzisa umyalo Ukubuka kwefomula (Bonisa amafomula), ekuthebhu amafomula (Amafomula) isigaba Ukuhlolwa kwefomula (Okuncike kufomula).
Ukuze ubuyele emuva ekubukeni okuvamile, chofoza lo myalo futhi.
Khumbula, ukwazi kahle kwamafomula kufinyelelwa ngokuzijwayeza njalo. Ngisho nabasebenzisi be-Excel abanolwazi kakhulu benza amaphutha kumafomula. Uma ifomula yakho ingasebenzi noma ikunikeza inani elingalungile, ungathuki! Ezimweni eziningi, kunencazelo elula yokuthi kungani ifomula yehluleka. Uma usulitholile leli phutha, ungenza ifomula isebenze ngendlela efanele.