01 ngo 01
Umsebenzi we-INT osebenzayo
Xa kuziwa kumanani okujikeleza, i-Excel inomsebenzi wokujikeleza ukukhetha kunye nomsebenzi oyikhethayo kuxhomekeke kwiziphumo ozifunayo.
Kwimeko yomsebenzi we-intanethi, iya kuhlala ijikeleze inamba ukuya kwi-integer ephezulu elandelayo ngelixa isusa isahlulo sokugqibela senani.
Ngokungafani neendlela zokufomathiza ezivumela ukuba utshintshe inani leendawo zokugqibela eziboniswe ngaphandle kokuchaphazela idatha engezantsi, umsebenzi we-INT utshintsha idatha kwiphepha lakho lokusebenzela . Ukusebenzisa lo msebenzi, ngoko, kunokuchaphazela iziphumo zokubala.
I-syntax yeeNtsebenzo kunye neengxoxo
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .
I-syntax yomsebenzi we-INT ngu:
= INT (Inombolo)
Inombolo - (efunekayo) ixabiso lokuhlaziywa. Le ngxabano ingaquletheka:
- idatha yangempela yokujikeleza - umgca 2 kumfanekiso ongentla;
- iselferensi yeseli kwindawo yendawo kwiphepha lokusebenzela - umgca 3 ngasentla.
UmSebenzi we-INT Umsebenzi: Ujikeleze ukuya kwi-Integer e kufuphi
Lo mzekelo ukhankanya amanyathelo asetyenziswa ukufaka umsebenzi we-INT kwiseli B3 kumfanekiso ongentla.
Ukungena kwi-INT Umsebenzi
Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:
- Ukuthayipha umsebenzi opheleleyo: = INT (A3) kwisisele B3;
- Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yomsebenzi we-INT.
Nangona kunokwenzeka ukufaka umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukuyisebenzisa ibhokisi yencoko njengoko kuthatha ukunakekelwa kokungena kwi-syntax yomsebenzi - njengabakaki kunye nabahluli be-comma phakathi kweengxabano.
Amanyathelo angezantsi angena kwi-INT umsebenzi usebenzisa ibhokisi yencoko yencoko yomsebenzi.
Ukuvula ibhokisi yeNtetho ye-PRODUCT
- Cofa kwifowuni B3 ukwenza i- cell esebenzayo- yilapho iziphumo zomsebenzi we-INT ziya kuboniswa;
- Cofa kwiThebhu yefomula yemenyu yebhondi ;
- Khetha Math & Trig kwi-Ribbon ukuvula uluhlu lwehla lokuhla;
- Cofa kwi- INT kule uluhlu ukuzisa ibhokisi yencoko yencoko yomsebenzi;
- Kwibhokisi yencoko, nqakraza kumgca weNombolo ;
- Cofa kwiseli A3 kwiphepha lokusebenzela ukufaka loo ntetho yeselenki kwibhokisi yencoko;
- Cofa u-OK ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela;
- Impendulo 567 ifanele ivele kwiseli B3;
- Xa ucofa kwi-cell B3 umsebenzi opheleleyo = INT (B3) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
INT vs. TRUNC
Umsebenzi we-INT ufana kakhulu nomnye umsebenzi ojikelezayo we- Excel - umsebenzi we-TRUNC .
Bobabini babuyela i-integers ngenxa yoko, kodwa bafezekisa umphumo ngokwahlukileyo:
- Iinqwelo ze-INT zihla ukuya kwinani elikufutshane;
- I-TRUNC ithatha i-truncates (ikhupha) inxalenye yeshumi yedatha ngaphandle kokujikeleza.
Ukwahlukana phakathi kwemisebenzi emibini kubonakala ngeenombolo ezimbi. Ngeempawu ezintle, njengoko kuboniswe kumqolo 3 no-4 ngasentla, zombini INT kunye ne-TRUNC babuyisela ixabiso le-567 xa ususa isahlulo sokugqibela kwinombolo 567.96 kwiseli A3,
Kwimiqolo yesi-5 no-6, nangona kunjalo, ixabiso elibuyiselwe yimisebenzi emibili ehlukileyo: -568 vs -567 kuba ukujikeleza ixabiso elingenanto kunye ne-INT lithetha ukujikeleza kude ne-zero, ngelixa umsebenzi we-TRUNC ugcina inamba ngexesha elifanayo ukususa isahlulo sokugqibela yenani.
Ukubuyela kwiiMilinganiselo eziMisiweyo
Ukubuyisela i-decimal okanye isahlulo esahlukileyo senani, kunokuba inxalenye ebanzi, yenze ifomula isebenzisa INT njengokuba kuboniswe kwiseli B7. Ngokukhupha inxalenye ye-integer yenani ukusuka kwinani elipheleleyo kwiseli ye-A7, kuphela i-decimal decimal 0.96 ihleli.
Ifom enye ingadalwa ngokusebenzisa umsebenzi we-MOD njengoko kuboniswe kumqolo 8. Umsebenzi we-MOD-mfutshane kwi- modulus - ngokuphindaphindiweyo ubuyisele kwintsalela yecandelo lolwahlulo.
Ukubeka umcebisi kumntu omnye - umcebisi-mbono wesibini yomsebenzi - ususa ngokuphumelelayo inxalenye ebanzi yenani na, ushiya kuphela isahlulo sokugqibela njengesisele.