Ntchito ya MROUND ya Excel imapangitsa kuti zikhale zosavuta kuzungulira nambala kupita mmwamba kapena pansi mpaka kuchulukitsa 5, 10, kapena mtengo wina uliwonse.
Mwachitsanzo, ntchitoyi ingagwiritsidwe ntchito pozungulira kapena kutsika mtengo wa zinthu zomwe zili pafupi kwambiri:
- masentimita (0.05)
- masenti khumi (0.10)
kupewa kupezeka ndi ndalama (0.01) monga kusintha.
Mosiyana ndi zosankha zokometsera zomwe zimakulolani kusintha chiwerengero cha malo osungirako osasintha popanda kusintha phindu mu selo, ntchito ya MROUND, monga ntchito zina za Excel, zimasintha mtengo wa deta.
Kugwiritsira ntchito ntchitoyi pozungulira deta, kotero, kumakhudza zotsatira za mawerengedwe.
Syntax ndi Arguments ya Funso la MROUND
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito ya ROUNDDOWN ndi:
= MUTU (Nambala, Yambiri)
Zokambirana za ntchitoyi ndi izi:
Chiwerengero - (chofunika) chiwerengerocho chikhale chokwera kapena chotsika kufupi ndi chifupi
- Mtsutso uwu ukhoza kukhala ndi deta yeniyeni yozungulira kapena ikhoza kutanthauzira selo kwa malo a deta muzenera .
Ambiri - (oyenerera) ntchitoyo ikuzungulira nambala ya Nambala kapena pansi pamtengo wapatali kwambiri.
Mfundo zokhudzana ndi zokhudzana ndi ntchitoyi ndi izi:
- Chiwerengero ndi zifukwa zambiri ziyenera kukhala ndi chizindikiro chomwecho - chabwino kapena choipa. Ngati ayi, ntchitoyo imabwerera #NUM! cholakwika mu selo.
- Ngati nambala ndi zifukwa zambiri zimakhala zoipa, ntchito imabweretsanso nambala yolakwika mu selo monga momwe tawonedwera mzere wachinayi mu chithunzi pamwambapa.
- ngati ndemanga yambiri imayikidwa pa zero (0), ntchitoyi imabweretsanso mtengo wa zero mu selo monga momwe tawonedwera mzere 7 mu chithunzi pamwambapa.
Zitsanzo za Ntchito za MROUND
Mu chithunzi pamwambapa, pa zitsanzo zisanu ndi chimodzi zoyambirira, chiwerengero cha 4.54 chatsekedwa kapena chotsika ndi ntchito ya MROUND pogwiritsa ntchito miyambo yosiyanasiyana pazogwirizana monga 0.05, 0.10, 5.0, 0, ndi 10.0.
Zotsatira zimasonyezedwa mu chigawo C ndipo ndondomekoyi imapereka zotsatira mu chigawo D.
Kupitiliza Kapena Kutsika
Malinga ndi felelo lothandizira la Excel, momwe ntchitoyo imakhalira ngati kuyendetsa chiwerengero chotsala chotsiriza (chiwerengero chokwera) mmwamba kapena pansi kumadalira zotsalira zomwe zimachokera kugawanika Nthano ya Number ndi Multiple argument.
- Ngati zotsatirazi zoposa kapena zofanana ndi theka la mgwirizano wochuluka, ntchitoyo ikuzungulira chiwerengero chotsiriza (kutali ndi zero).
- Ngati zotsatirazi ziri zosachepera theka la mtengo wa mtsutso wambiri, ntchitoyi ikuzungulira chiwerengero chotsiriza (kufika ku zero).
Zitsanzo ziwiri zomalizira - mzere 8 ndi 9 wa fano - amagwiritsidwa ntchito kusonyeza momwe ntchitoyo imayendetsera mmwamba kapena pansi.
- Mu mzere 8, popeza kukangana Kwambiri ndi chiwerengero cha chiwerengero chimodzi, 2 imakhala chiwerengero cha chiwerengero cha chiwerengero cha 12.50 mtengo mu selo A8. Popeza 2.5 ndi ofanana ndi theka la mtengo wa Multiple argument (5.00), ntchitoyi imayambira mpaka 15.00, yomwe ili pafupi kwambiri ndi 5.00 yaikulu kuposa 12.50.
- Mu mzere wa 9, kuyambira 2.49 ndi osachepera theka la mtengo wa Multiple argument (5.00), ntchitoyi ikuzungulira zotsatira zake kufika pa 10.00, yomwe ili pafupi kwambiri ndi 5.00 zosakwana 12.49.
Chitsanzo Pogwiritsira Ntchito Ntchito ya MROUND
Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:
- Kujambula ntchito yonse: monga = MROUND (A2,0.05) mu selo lamasewera.
- Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito bokosi la bokosi la MROUND.
Anthu ambiri amavutika kuti agwiritse ntchito bokosili kuti alowe mmaganizo a ntchito chifukwa zimasamalira mgwirizano wa ntchito - monga makasitomala omwe amachititsa kuti azikhala osiyana pakati pa zokambiranazo.
Ndondomeko ili m'munsimu chivundikiro pogwiritsa ntchito bokosilo kuti mulowetse ntchito yozungulira mu selo C2 yachitsanzo pamwambapa.
- Dinani pa selo B2 kuti mupange selo yogwira ntchito .
- Dinani pa Fomu tab ya riboni .
- Dinani pa Math & Trig icon kuti mutsegule ntchito yolemba pansi.
- Dinani pa MROUND m'ndandanda kuti mutsegule dialog box.
- Mu bokosi la bokosi, dinani pa Nambala .
- Dinani pa selo A2 patsiku la ntchito kuti mulowetse selo ili monga nambala ya Namba .
- Mu bokosi la bokosi, dinani pa Multiple line.
- Lembani mu 0.05 - chiwerengero cha A2 chidzakonzedwa kapena kutsika kumtunda wochuluka wa masentimita asanu.
- Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.
- Phindu la 4.55 liyenera kuoneka mu selo B2, lomwe liri lalikulu kwambiri la 0.05 lalikulu kuposa 4.54.
- Mukasindikiza pa selo C2 ntchito yonse = MROUND (A2, 0.05) ikuwoneka muzenera zamatabwa pamwamba pa tsamba.