01 na 01
Ayyukan INT na Excel
Lokacin da ya zo ga ƙidayar lambobi, Excel yana da ayyuka masu yawa don karɓa daga kuma aikin da ka zaɓa ya dogara da sakamakon da kake so.
A game da aikin INT, zai yi zagaye lamba har zuwa mai zuwa mafi ƙasƙanci yayin cire ɓangaren ƙididdiga na lamba.
Ba kamar tsarin tsarawa wanda ya ba ka damar canza yawan adadin ƙananan wurare da aka nuna ba tare da amfani da bayanan da aka ƙaddara ba, aikin INT yana canza bayanan a cikin aikinku. Yin amfani da wannan aikin zai iya, sabili da haka, ya shafi sakamakon lissafin.
Ƙungiyar ta INT da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Maganar aikin INT shine:
= INT (Lambar)
Lambar - (da ake buƙata) darajar da za a ɗaure. Wannan hujja zata iya ƙunsar:
- ainihin bayanai don zagaye - jere 2 a cikin hoto a sama;
- wani tantancewar salula akan wurin da aka sanya bayanai a cikin takardun aiki - jere 3 a sama.
Misali mai aiki na INT: Zagaye Zuwa zuwa Ƙungiyar da ke kusa
Wannan misali ya tsara matakan da ake amfani dashi don shigar da aikin INT zuwa cikin tantanin halitta B3 a cikin hoton da ke sama.
Shigar da aikin INT
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin: = INT (A3) cikin tantanin halitta B3;
- Zabi aikin da kuma muhawara ta amfani da akwatin maganganun INT.
Ko da yake yana yiwuwa don kawai shigar da cikakken aikin da hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu kamar yadda yake kula da shigar da haɗin aikin - irin su sakonni da rabuwa tsakanin ɓangarori tsakanin muhawarar.
Matakan da ke ƙasa ya rufe shigar da aikin INT ta amfani da akwatin maganganun aikin.
Ana buɗe akwatin zane-zane na PRODUCT
- Danna kan tantanin halitta B3 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon INT;
- Danna maɓallin Formulas na shafin ribbon ;
- Zaɓi Math & Trig daga rubutun don bude jerin abubuwan da aka sauke aikin;
- Danna INT cikin jerin don kawo akwatin maganganu na aikin;
- A cikin akwatin maganganu, danna kan Lambar waya;
- Danna kan A3 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu;
- Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki;
- Amsar 567 ya kamata ya bayyana a cell B3;
- Lokacin da ka danna kan tantanin B3 mai cikakke aikin = INT (B3) ya bayyana a cikin wannan tsari a sama da takardun aiki.
INT vs. TRUNC
Ayyukan INT sunyi kama da wani aiki na Excel - aikin TRUNC .
Dukansu suna dawo da haɓaka a sakamakon, amma sun cimma sakamakon sakamakon daban:
- Sakamakon lambobi zuwa lambar zuwa mafi kusa;
- TRUNC truncates (yanke kashe) sashi na ƙayyadaddun bayanai ba tare da tasowa ba.
Bambanci tsakanin ayyukan biyu yana samuwa tare da lambobin maɓallin. Don ƙididdiga masu kyau, kamar yadda aka nuna a cikin layuka 3 da 4 a sama, duka INT da TRUNC sun dawo darajar 567 a lokacin cire kashi na kashi decimal na lamba 567.96 a cikin cell A3,
A cikin layuka 5 da 6, duk da haka, dabi'un da aka dawo da ayyuka biyu sun bambanta: -568 vs. -567 saboda tayar da dabi'u mara kyau tare da INT yana nufin ɗauka daga zero, yayin da TRUNC aiki ke riƙe adadin daidai yayin cire bangaren ƙaddarawa na lambar.
Komawa Yanayin Ƙidaya
Don dawo da ƙaddarar kashi ko ɓangare na ɓangare na lamba, maimakon kashi ɗaya, ƙirƙira wata maƙira ta amfani da INT kamar yadda aka nuna a cell B7. Ta hanyar rabu da ɓangaren sashi na lamba daga lambar duka a cikin salula A7, kawai ƙimar ƙarancin 0.96.
Za'a iya ƙirƙira wata madadin ta hanyar amfani da aikin MOD kamar yadda aka nuna a jere na 8. Ayyukan MOD - gajeren lokaci don ƙaddamarwa - akai-akai ya dawo a kan sauran aikin aiki.
Sanya sashi zuwa ɗaya - mai raba shine aikin ta na biyu - yadda ya kawar da kashi ɗaya daga cikin kowane lamba, ya bar adadin decimal kamar saura.