Amaya Toman Izinombolo ku-Mac azizona nje ezokufaka umbhalo ongenalutho kumaseli espredishithi—ungakha futhi amaseli ngefomula noma umsebenzi owenza ukubala okuzenzakalelayo kube lula futhi kusebenze kahle kakhudlwana. Ukudala amafomula nemisebenzi kokuthi Izinombolo kuyinkimbinkimbi kakhulu, kodwa akukho okunzima kakhulu. Izinombolo zinikeza ngokoqobo amakhulu emisebenzi kusukela kokulula kuye kwezibalo, ubunjiniyela noma ezezimali.
Kungaba njalo okuthakaselayo
Ukufaka ifomula, chofoza kuseli ofuna ukwengeza ifomula kulo bese ufaka uphawu oluthi “=". Kumhleli wefomula ovela kuphaneli engakwesokudla, chofoza ukuze ukhethe umsebenzi owufunayo futhi uqinisekise ngokuchofoza okuthi Faka umsebenzi. Umhleli wefomula ovela eduze kweseli elikhethiwe uyahudulwa ngemva kokuchofoza ohlangothini lwaso kwesokunxele. Ngokuchofoza uphawu lwe-fX ohlangothini lwesobunxele lomhleli, ungasetha ukuthi uyafuna yini ukubonisa ifomula njengombhalo noma uyiguqule ibe umbhalo. Bese ukhetha i-agumenti yomsebenzi bese ufaka inani layo - usizo lokufaka luzovela ngezansi kwephaneli kwesokudla. Ungaphinda uchofoze ukuze ukhethe amaseli ofuna ukusebenzisa umsebenzi kuwo. Ukuze ufake amanani ekholomu yonke noma umugqa kufomula, chofoza ibha phezulu kwekholomu noma kwesokunxele somugqa, noma khetha wonke amaseli kukholamu noma umugqa. Ngemva kokwenza izinguquko ezidingekayo, chofoza inkinobho eluhlaza kwesokudla somhleli womsebenzi noma cindezela u-Enter/Return.
Uma ubona unxantathu obomvu onephuzu lesibabazo kuseli, kusho ukuthi kunephutha kufomula. Ngokuchofoza unxantathu, ungabona umlayezo wephutha ohambisanayo. Ukuze ubuke ukubala okusheshayo kohlu oluthile lwamaseli, khetha ikholomu, umugqa, noma uhla oluthile lwamaseli ofuna ukubuka izibalo zalo. Kuphaneli engezansi kwewindi lohlelo lokusebenza, ungabuka izinhlobo ezahlukahlukene zokubala (bona igalari yezithombe).
Igalari yezithombe
Kuzinombolo ku-Mac, ungasebenzisa lokho okubizwa ngokuthi imisebenzi ye-opharetha kumathebula - lezi zisetshenziselwa ukuhlola ukuthi amanani kumaseli amabili ayafana noma inani elilodwa likhulu noma lingaphansi kwelinye. Okokuqala, udinga ukusetha isitatimende sohlobo A1 > A2 esitokisini - opharetha uzokutshela uma isitatimende siyiqiniso. Chofoza iseli lapho ufuna ukubeka khona umphumela wokuqhathanisa bese ufaka uphawu lokulinganisa (=). Hudula bese udedela umhleli wefomula ovela eduze kweseli ngaphandle kweseli. Bese uchofoza iseli ofuna ukuliqhathanisa nenani lalo bese ufaka u-opharetha wokuqhathanisa (>, <, <>, = njll.) bese ukhetha iseli lesibili ozoliqhathanisa.
