Momwe Mungayendetsere Numeri mu Excel

Gwiritsani ntchito ROUNDUP Ntchito mu Excel ku Round Numbers Up

Ntchito ya ROUNDUP mu Excel imagwiritsidwa ntchito kuchepetsa mtengo ndi nambala yeniyeni ya malo osungirako kapena chiwerengero. Ntchitoyi nthawi zonse imakhala yozungulira chiwerengerochi, monga 4.649 mpaka 4.65.

Mphamvu yozungulirayi ku Excel imasintha kufunika kwa deta mu selo, mosiyana ndi machitidwe opangira maonekedwe omwe amakulolani kusintha chiwerengero cha malo osungidwa osasintha popanda kusintha phindu mu selo. Chifukwa cha ichi, zotsatira za chiwerengero zimakhudzidwa.

Manambala osayenerera, ngakhale atakhala ofunika ndi ntchito ya ROUNDUP, amanenedwa kuti akukweza. Mutha kuona zitsanzo zotsatirazi.

Ntchito ya ROUNDUP ya Excel

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

Ichi ndicho chidule cha ntchito ROUNDUP:

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 ndemanga ya Num_digits iikidwa ku 0, ntchitoyo imayendetsa mtengo mpaka kufupi kwambiri;
• Ngati ndemanga ya Num_digits iikidwa ku 1, ntchitoyi imachokera pa digiti imodzi yokha kupita kumalo okwerera kumadzulo ndikuyang'ana ku nambala yotsatira;
• Ngati ndemanga ya Num_digits ndi yoipa, malo onse osungidwa amachotsedwa ndipo ntchitoyo imayang'ana chiwerengero cha ziwerengero ndi kumanzere kwa decimal mpaka pamwamba.

Zindikirani: Kuti mukhale chitsanzo cha mtsutso wotsiriza, ngati mtengo wa ndondomeko ya Num_digits yayikidwa ku -2 , ntchitoyi idzachotsa chiwerengero chonse kumanja komwe kuli decimal ndi kuzungulira chiwerengero choyamba ndi chachiwiri kumanzere kwa decimal decimal mpaka kufika pafupi (monga momwe tawonetsera mzere wachisanu ndi chimodzi mu chitsanzo chapamwamba).

Zitsanzo za Ntchito za ROUNDUP

Chithunzichi pamwamba chikuwonetsa zitsanzo ndikupereka tsatanetsatane wa zotsatira zomwe zinabweretsedwe ndi ntchito ya ROUNDUP ya Excel kwa deta A ya tsambalo.

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

Malangizo pansipa tsatanetsatane ndondomeko zomwe zatengedwa kuti muchepetse nambala mu selo A2 mu chithunzi pamwambapa mpaka malo awiri osagwiritsa ntchito ntchito ROUNDUP. Pogwiritsa ntchito, ntchitoyi idzawonjezera mtengo wa chiwerengero chozungulira.

Kulowa ntchito ya ROUNDUP

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

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

Kugwiritsira ntchito bokosili likuphweka kulowera kutsutsana kwa ntchito. Pogwiritsa ntchito njirayi, sikuli kofunika kuti mulowe nawo makasitomala pakati pa zifukwa zomwe zimagwira ntchito monga zomwe ziyenera kuchitika pamene ntchitoyi ikuyimikidwa mu selo - pakali pano pakati pa A2 ndi 2 .

1. Dinani pa selo C3 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito ROUNDUP zidzawonetsedwa.
2. Dinani pa Fomu tab ya menyu yowonjezera.
3. Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi.
4. Sankhani ROUNDUP kuchokera mndandanda kuti mutsegule dialog box.
5. Sankhani bokosi lolemba pafupi ndi "Nambala."
6. Dinani pa selo A2 mu tsamba lothandizira kuti mulowetse selololo mu bokosi la malingaliro monga malo a chiwerengerocho.
7. Sankhani bokosi lolemba pafupi ndi "Num_digits."
8. Lembani 2 kuti muchepetse nambala mu A2 kuchokera malo asanu mpaka awiri.
9. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.
10. Yankho 242.25 liyenera kuoneka mu selo C3 .
11. Mukasindikiza pa selo C2, ntchito yonse = ROUNDUP (A2, 2) ikuwoneka muzenera zamatabwa pamwamba pa tsamba .