Imodyuli yinani elifanelekile lanoma iyiphi inombolo. Ngisho nenombolo engemihle izohlala ine-modulus eyakhayo. Ake sibheke ukuthi singabalwa kanjani usayizi wemodyuli kuMicrosoft Excel.
Umsebenzi we-ABS
Kunomsebenzi okhethekile obizwa nge-ABS wokubala usayizi wemodyuli ku-Excel. I-syntax yalomsebenzi ilula kakhulu: "ABS (inombolo)". Noma, ifomula ingathatha ifomu elithi "ABS (cell_address_with_number)".
Ukuze ukwazi ukubala, ngokwesibonelo, imodulus yenombolo -8, udinga ukushayela kumugqa wamafomula noma kunoma isiphi iseli eshidi, ifomula elandelayo: "= ABS (-8)".
Ukwenza ukubala, cindezela inkinobho ethi ENTER. Njengoba ukwazi ukubona, uhlelo luphendula ngenani elifanele lenombolo 8.
Kukhona enye indlela yokubala imodyuli. Ilungele labo abasebenzisi abangasetshenziswanga ukugcina amafomula ahlukahlukene emakhanda abo. Sichofoza kuseli lapho sifuna ukuthi umphumela ugcinwe khona. Chofoza inkinobho ethi "Faka Umsebenzi" etholakala kwesokunxele sebha lefomula.
Iwindows Workiz Wizard iyaqala. Uhlu olutholakala kulo, udinga ukuthola umsebenzi we-ABS, futhi uwugqamise. Bese uchofoza inkinobho "OK".
Iwindi lokuphikisana ngomsebenzi liyavula. Umsebenzi we-ABS unempikiswano eyodwa kuphela - inombolo. Sethula. Uma ufuna ukuthatha inombolo kusuka kudatha egcinwe kunoma yiliphi iseli ledokhumenti, chofoza inkinobho ebekwe ngakwesokudla kwefomu lokufaka.
Ngemuva kwalokho, iwindi liyancishiswa, futhi udinga uchofoza kuseli eliqukethe inombolo ofuna ukubala kuyo module. Ngemuva kokuthi inombolo ingeziwe, chofoza futhi inkinobho ngakwesokudla kwenkambu yokufaka.
Iwindi elinezimpikiswano zomsebenzi liqala futhi. Njengoba ukwazi ukubona, inkambu yenombolo igcwaliswa ngenani. Chofoza inkinobho ethi "Kulungile".
Ukulandela lokhu, kuseli elikhonjwe ngaphambili, inani lemodyuli yenombolo oyikhethile liyaboniswa.
Uma inani litholakala etafuleni, khona-ke ifomula yemoduli ingalandelwa kwamanye amaseli. Ukuze wenze lokhu, udinga ukuma ekhoneni elingezansi kwesobunxele seseli lapho sekuvele ifomula, bamba inkinobho yegundane, bese ulihudula laze ekugcineni kwetafula. Ngakho-ke, kule kholamu kumaseli ama-value modulo idatha yomthombo izovela.
Kubalulekile ukuqaphela ukuthi abanye abasebenzisi bazama ukubhala imodyuli, njengoba kuyisiko ngokwezibalo, okungukuthi, | (inombolo) |, ngokwesibonelo | -48 |. Kepha, ekuphenduleni, bathola iphutha, ngoba i-Excel ayiqondi lo mbhalo.
Njengoba ukwazi ukubona, akukho lutho oluyinkimbinkimbi ekubaleni imodyuli kusuka kunombolo eMicrosoft Excel, ngoba lesi senzo senziwa kusetshenziswa umsebenzi olula. Isimo kuphela ukuthi udinga ukwazi lo msebenzi.
