Gwiritsani ntchito Funsiti ya INT kuti mupite Kumalo Ofupikira ku Excel

01 ya 01

Ntchito ya INT int

Pankhani yowombera manambala, Excel ili ndi ntchito zingapo zomwe zimasankhidwa kuti mutenge ndipo ntchito yomwe mumasankha imadalira zotsatira zomwe mukufuna.

Pankhani ya ntchito ya INT, nthawi zonse imakhala yozungulira nambala mpaka kufupi nambala yochepa pamene ikuchotsa gawo la decimal la chiwerengero.

Mosiyana ndi maonekedwe a maonekedwe omwe amakulolani kusintha chiwerengero cha malo osungirako zinthu popanda kuwonetsa deta yapansi, ntchito ya INT imasintha deta yanu. Kugwiritsira ntchito ntchito imeneyi kungathe kukhudza zotsatira za kuwerengera.

Syntax ndi Ntchito Zothandizira Intaneti

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Syntax ya INT ntchito ndi:

= INT (Namba)

Chiwerengero - (chofunika) mtengo wozunzidwa. Mtsutso uwu ukhoza kukhala:

• deta yeniyeni yozungulira - mzere 2 mu chithunzi pamwambapa;
• selo loyang'ana pa malo a deta mu worksheet - mzere 3 pamwambapa.

Chitsanzo cha NT: Chitsitsimutseni kumalo oyandikira

Chitsanzo ichi chikulongosola njira zomwe zimagwiritsidwa ntchito kulowa INT function mu selo B3 mu chithunzi pamwambapa.

Kulowa mu NT Ntchito

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yonse: = INT (A3) mu selo B3;
2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito INT function dialog box .

Ngakhale kuti n'zotheka kungolowera polojekitiyi, anthu ambiri amavutika kuti agwiritse ntchito bokosilo monga momwe zimakhalira kuti zilowerere muzowonjezereka monga mabakiteriya ndi ogawanikana pakati pa zifukwa.

Masitepe omwe ali pansipa alowetsani mkati mwa INT ntchito pogwiritsa ntchito bokosi la bokosi.

Kutsegula Bokosi la Mauthenga la PRODUCT

1. Dinani pa selo B3 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za NT ntchito ziwonetsedwa;
2. Dinani pa Fomu tab ya menyu yowonongeka;
3. Sankhani Masamu & Katundu kuchokera ku riboni kuti atsegule ntchitoyo.
4. Dinani pa INT mu mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
5. Mu bokosi la bokosi, dinani pa Number line;
6. Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog;
7. Dinani OK kuti mutsirize ntchitoyi ndi kubwerera ku tsamba la ntchito;
8. Yankho 567 liyenera kuoneka mu selo B3;
9. Mukasindikiza pa selo B3 ntchito yonse = INT (B3) ikuwoneka mu barra yazenera pamwamba pa tsamba.

INT vs. TRUNC

Ntchito ya INT ikufanana ndi ntchito ina yozungulira ya Excel - ntchito ya TRUNC .

Zonse ziwiri zimabwerera mmbuyo, koma zimakwaniritsa zotsatira zake:

• MUTU wozungulira INT amawerengera mpaka kufupi kwambiri;
• TRUNC imadula (imachotsa) gawo la decimal la data popanda kuzungulira.

Kusiyanitsa pakati pa ntchito ziwiri ndiwonekeratu ndi nambala zolakwika. Kuti mukhale ndi makhalidwe abwino, monga momwe tawonetsera mzere 3 ndi 4 pamwamba, zonse INT ndi TRUNC zimabweretsanso mtengo wa 567 pamene kuchotsa gawo la decimal la nambala 567.96 mu selo A3,

Mu mzere 5 ndi 6, komabe, zikhalidwe zomwe zimabweretsedwa ndi ntchito ziwiri zikusiyana: -568 vs. -567 chifukwa kudula mitengo yolakwika ndi INT kumathamanga kuchoka ku zero, pamene ntchito ya TRUNC imapangitsa chiwerengerocho kukhala chofanana ndikuchotsa gawo la decimal ya chiwerengerocho.

Makhalidwe Abwino Obwerera

Kuti mubwezeretse decimal kapena gawo laling'ono la chiwerengero, osati chiwerengero cha integer, pangani ndondomeko yogwiritsira ntchito INT monga momwe zasonyezera mu selo B7. Mwa kuchotsa chiwerengero cha integer cha nambala kuchokera ku nambala yonse mu selo A7, ndilo decimal decimal 0,96 yokha.

Njira ina ingathe kukhazikitsidwa pogwiritsira ntchito ntchito ya MOD monga momwe ikuwonedwera mzere 8. MOD ntchito - yoperewera modulus - kawirikawiri amabwereranso pa ntchito yotsalira.

Kuika wotsogolera kwa wina - wongolangizani ndi ndondomeko yachiwiri ya ntchito - imachotsa gawo lochepa la nambala iliyonse, kusiya gawo la decimal okha monga otsala.