Sebenzisa umsebenzi we-Int ukuze ujikeleze ku-Integer eseduzane ku-Excel

01 ka 01

Umsebenzi we-INT we-Excel

Ukususa Zonke Izinqununu nge-INT Function ku-Excel. © Ted French

Uma kuziwa ekubumbeni izinombolo, i-Excel inemisebenzi eminingi yokuqoqa okumele uyikhethe futhi umsebenzi owukhethayo kuncike kwimiphumela oyifunayo.

Endabeni yomsebenzi we-INT, izohlale ijikeleza inombolo kuze kube yilapho inamba ephansi kunazo zonke ngenkathi isusa ingxenye yesimangadi yenombolo.

Ngokungafani nezinketho zokufometha ezivumela ukuthi ushintshe inombolo yezindawo zamadesimali eziboniswa ngaphandle kokuphazamisa idatha engaphansi, umsebenzi we-INT uguqulela idatha kushidi lakho lokusebenzela . Ukusebenzisa lo msebenzi kungabathinta imiphumela yezibalo.

I-Syntax ye-Int Function kanye nama-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-INT yilezi:

= INT (Inombolo)

Inombolo - (edingekayo) inani elizoguqulwa. Le mpikiswano ingaqukatha:

INT Function Example: Round Round kuya Integer eseduze

Lesi sibonelo sichaza izinyathelo ezisetshenziselwa ukungena umsebenzi we-INT esitokisini B3 esithombeni ngenhla.

Ukufaka umsebenzi we-Int

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

  1. Ukuthayipha umsebenzi ophelele: = INT (A3) ibe esitokisini B3;
  2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lebhokisi le-INT function.

Nakuba kungenzeka nje ukufaka umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lebhokisi njengoba kuqapha ukungena kwe-syntax yomsebenzi - njengabakaki kanye nabahlukanisi be-comma phakathi kwama-arguments.

Izinyathelo ezingezansi kwekhava zingena ku-INT umsebenzi usebenzisa ibhokisi lengxoxo lomsebenzi.

Ukuvula ibhokisi le-PRODUCT Dialog

  1. Chofoza esitokisini B3 ukuze ukwenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-INT izoboniswa;
  2. Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
  3. Khetha I-Math & Trig kusuka ku-Ribbon ukuvula uhlu lwehla lokusebenza;
  4. Chofoza ku- INT ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
  5. Ebhokisini lengxoxo, chofoza kulayini lombhalo;
  6. Chofoza ku-cell A3 kushidi lokusebenzela ukuze ufake leyo reference reference ebhokisini lengxoxo;
  7. Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela;
  8. Impendulo 567 kufanele ivele esitokisini B3;
  9. Uma uchofoza ku-cell B3 umsebenzi ophelele = INT (B3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

INT vs. TRUNC

Umsebenzi we-INT ufana kakhulu nomunye umsebenzi we-Excel ojikelezayo - umsebenzi we-TRUNC .

Zombili zibuyela ezinkampanini ngenxa yalokho, kodwa zifezekisa umphumela ngokuhlukile:

Umehluko phakathi kwemisebenzi emibili uyabonakala ngezinombolo ezingalungile. Ukuze uthole amanani afanele, njengoba kuboniswe emigqeni engu-3 no-4 ngenhla, kokubili INT kanye ne-TRUNC babuyisa inani lika-567 uma kususwa ingxenye yesimanje yedenzana inombolo 567.96 kuseli A3,

Emigqeni engu-5 no-6, noma kunjalo, amanani abuyelwe yimisebenzi emibili ihlukile: -568 vs. -567 ngoba ukugoqa phansi amanani angalungile nge-INT kusho ukujikeleza kusuka ku-zero, kanti umsebenzi we-TRUNC ugcina inamba ngesikhathi esifanayo ngenkathi isusa ingxenye yesimanje yenombolo.

Ukubuyisa izimiso ezinqunyiwe

Ukuze ubuyisele ingxenye yedesimali noma ingxenye engxenyeni yenombolo, kunokuba ingxenye enkulu, yakha ifomula usebenzisa INT njengoba kuboniswa esitokisini B7. Ngokukhipha ingxenye ephelele yenombolo kusuka kwinombolo yonke esitokisini A7, kuphela idesimali 0.96 ehlala.

Ifomula ehlukile ingadalwa besebenzisa umsebenzi we-MOD njengoba kuboniswe emgqeni 8. Umsebenzi we-MOD - omfushane we- modulus - evame ukubuyela emsebenzini osuke wehlukana.

Ukubeka umshayeli kumuntu oyedwa - umshayeli wempikiswano yomsebenzi wesibili - ususa ngempumelelo ingxenye yenani lenoma iyiphi inombolo, ushiya ingxenye yesimanje kuphela njengensalela.