Momwe Mungayendetsere Numeri Kuchokera ku Excel Ndi Ntchito ya ROUNDDOWN

01 ya 01

Ntchito ya ROUNDDOWN ya Excel

Ntchito ya ROUNDDOWN:

• amagwiritsidwa ntchito kuchepetsa mtengo ndi nambala yeniyeni ya malo kapena decimal;
• nthawi zonse azikhala ndi chiwerengero chofanana;
• imasintha kufunika kwa deta mu selo - mosiyana ndi zosankha za maonekedwe omwe amakulolani kusintha chiwerengero cha malo osungidwa osasintha popanda kusintha mtengo mu selo;
• zimakhudza zotsatira za mawerengedwe chifukwa cha kusintha kwa deta.
• nthawi zonse kuzungulira zero. Ziwerengero zosayenerera, ngakhale kuti zowonjezera phindu ndi ntchitoyi, zimanenedwa kuti zazingidwa - monga momwe zisonyezedwera mu zitsanzo za mizere isanu ndi sikisi mu chithunzi pamwambapa).

Syntax ndi Ntchito Zopangira ROUNDDOWN

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

Chidule cha ntchito ya ROUNDDOWN ndi:

= ROUNDDOWN (Namba, Num_digits)

Zokambirana za ntchitoyi ndi izi:

Chiwerengero - (chofunika) mtengo wozungulira

• Mtsutso uwu ukhoza kukhala ndi deta yeniyeni yozungulira kapena ikhoza kutanthauzira selo kwa malo a deta muzenera.

Num_digits - (yofunika) chiwerengero cha ziwerengero zomwe nambala ya Nambala idzapangidwira.

• ngati nambala_yiyi ikukangana ndi 0, ntchitoyo imayendetsa mtengo mpaka kufupi kwambiri
• ngati Num_digits kukangana yayikidwira 1, ntchitoyo imangokhala ndi digiti imodzi yokha kumanja ya decimal ndipo ikuzungulira mpaka nambala yotsatira
• ngati nambala_yiyi ikutsutsana ndizoipa, malo onse osungidwa amachotsedwa ndipo ntchitoyo ikuzungulira chiwerengero cha chiwerengero ndi kumanzere kwa chigawo cha decimal kufika ku zero
  • Mwachitsanzo, ngati phindu la Num_digits likukhazikitsidwa ku -2 , ntchitoyi idzachotsa chiwerengero chonse kumalo okondwerera kumadzulo ndi kuzungulira chiwerengero choyamba ndi chachiwiri kumanzere kwa decimal mpaka kufika pafupi ndi 100 monga momwe zasonyezedwera mu chitsanzo mzere 6 mu chithunzi pamwambapa

Ntchito Zachilengedwe za ROUNDDOWN

Chithunzichi pamwamba chikuwonetsa zitsanzo ndikupereka tsatanetsatane wa zotsatira zomwe zinabweretsedwa ndi ntchito ya ROUNDDOWN ya Excel kwa data mu gawo A la tsamba.

Zotsatira, zosonyezedwa m'ndandanda B, zimadalira kufunika kwa mkangano wa Num_digits .

Malangizo omwe ali pansipa tsatanetsatane ndondomeko zomwe zatengedwa kuti kuchepetsa chiwerengero cha selo A2 mu chithunzi pamwambapa mpaka malo awiri osagwiritsa ntchito ntchito ROUNDDOWN. Chifukwa chakuti ntchitoyo imakhala yozungulira nthawi zonse, chiwerengero chozungulira sichingasinthe.

Kulowa ntchito ya ROUNDDOWN

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

• Kujambula ntchito yonse: = ROUNDDOWN (A2.2) kulowa mu selo C3 mu tsamba la ntchito;
• Kusankha ntchito ndi zifukwa pogwiritsa ntchito bokosi la bokosi la ntchito .

Kugwiritsira ntchito bokosili likuphweka kulowera kutsutsana kwa ntchito. Pogwiritsa ntchito njirayi, sikofunika kuti mulowe nawo makasitomala pakati pa zifukwa za ntchitoyo monga momwe ziyenera kukhalira pamene ntchitoyi imayikidwa mu selo - pa nkhaniyi pakati pa A2 ndi 2.

Masitepe m'munsimu akulowa mu ntchito ya ROUNDDOWN pogwiritsa ntchito bokosi.

1. Dinani pa selo C3 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito ya ROUNDDOWN idzawonetsedwa;
2. Dinani pa Fomu tab ya menyu yowonongeka;
3. Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi;
4. Dinani pa ROUNDDOWN mu mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
5. Mu bokosi la bokosi, dinani pa Number line;
6. Dinani pa selo A2 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la malingaliro monga malo a chiwerengero chozungulira;
7. Dinani pa Num_digits mzere;
8. Lembani awiri "2" kuti muchepetse nambala mu A2 kuchokera malo asanu mpaka awiri;
9. Dinani OK kuti mutseke bokosi la bokosi ndikubweranso ku tsamba la ntchito;
10. Yankho 567.96 liyenera kuoneka mu selo C3;
11. Mukasindikiza pa selo C2 ntchito yonse = ROUNDDOWN (A2, 2) ikuwoneka muzenera zamatabwa pamwamba pa tsamba .