Isigaba sezibalo kanye ne-trigonometric siqukethe cishe imisebenzi engama-80 ehlukene ye-Excel, kusukela ekuhlanganiseni okubalulekile nokuzungezisa, ukuya enanini elaziwa kancane lemisebenzi ye-trigonometric. Njengengxenye yalesi sifundo, sizobuyekeza kuphela imisebenzi yezibalo ewusizo kakhulu ku-Excel.
Mayelana nemisebenzi yezibalo ISUM и I-SUMMESLI Ungafunda kulesi sifundo.
UMQEPHU()
umsebenzi wezibalo I-ROUNDWOOD ikuvumela ukuthi ufinyeze ivelu enanini elidingekayo lezindawo zamadesimali. Ungacacisa inani lezindawo zamadesimali ku-agumenti yesibili. Emfanekisweni ongezansi, ifomula izungeza inani endaweni eyodwa yedesimali:
Uma i-agumenti yesibili inguziro, khona-ke umsebenzi uzungeza inani libe inombolo ephelele eseduze:
I-agumenti yesibili ingase ibe negethivu, lapho inani lifinyezwa endaweni yedesimali edingekayo:
Inombolo efana no-231,5 ingumsebenzi I-ROUNDWOOD imizuliswano ukusuka ku-zero:
Uma udinga ukuzungezisa inombolo phezulu noma phansi ngenani eliphelele, ungasebenzisa imisebenzi I-KRUGLVVERH и ZUZA PHANSI.
PRODUCT()
umsebenzi wezibalo UMKHIQIZO ibala umkhiqizo wazo zonke izimpikiswano zayo.
Ngeke sixoxe kabanzi ngalo msebenzi, ngoba ufana kakhulu nomsebenzi ISUM, umehluko usenhloso kuphela, omunye uyafingqa, owesibili uyaphindaphindeka. Imininingwane eyengeziwe mayelana ISUM Ungafunda Isamba sendatshana ku-Excel usebenzisa imisebenzi ye-SUM ne-SUMIF.
I-ABS()
umsebenzi wezibalo ABS ibuyisela inani eliphelele lenombolo, okungukuthi imojula yayo.
Umsebenzi ABS kungaba usizo lapho kubalwa inani lezinsuku phakathi kwamadethi amabili, lapho ingekho indlela yokunquma ukuthi iyiphi idethi eyisiqalo nesiphetho.
Emfanekisweni ongezansi, amakholomu A no-B amelela izinsuku, futhi iyiphi kuzo ewukuqala nokuthi iluphi usuku lokugcina akwaziwa. Kudingeka ukubala inani lezinsuku phakathi kwalezi zinsuku. Uma uvele ukhiphe enye idethi osukwini olulodwa, inani lezinsuku lingase libe negethivu, okungalungile ngokuphelele:
Ukugwema lokhu, sisebenzisa umsebenzi ABS:
Ukucindezela Faka, sithola inani elilungile lezinsuku:
impande()
Ibuyisela impande eyisikwele yenombolo. Inombolo akumele ibe negethivu.
Ungakwazi futhi ukukhipha impande yesikwele ku-Excel usebenzisa i-exponentiation operator:
ISIQEPHU()
Ikuvumela ukuthi ukhuphule inombolo emandleni anikeziwe.
Ku-Excel, ngaphezu kwalo msebenzi wezibalo, ungasebenzisa i-exponentiation operator:
I-CASEBETWEEN()
Ibuyisela inombolo engahleliwe phakathi kwamanani amabili anikezwe njengama-agumenti. Ngaso sonke isikhathi lapho ishidi libalwa kabusha, amanani ayabuyekezwa.
Nakuba kunemisebenzi eminingi yezibalo ku-Excel, embalwa kuphela yayo enenani langempela. Asikho isidingo sokufunda yonke into ngesikhathi esisodwa, ngoba eziningi zingase zingabi nalusizo. Imisebenzi yezibalo echazwe kulesi sifundo incane kakhulu ezoqinisekisa ukusebenza ngokuzethemba ku-Excel futhi ngeke igcwalise inkumbulo yakho ngolwazi olungadingekile. Inhlanhla nempumelelo ekufundeni i-Excel!