Ntchito ya Google Spreadsheets 'MROUND imapangitsa kuti zikhale zovuta kuzungulira chiwerengero chokwera kapena chotsika kupita kufupi ndi 5, 10, kapena zina zapafupi.
Mwachitsanzo, ntchitoyi ingagwiritsidwe ntchito pozungulira kapena kutsika mtengo kwa zinthu zisanu ndi zisanu (0.05) kapena masentimita khumi (0.10) kuti asagwirizane 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 Google Spreadsheets, imasintha mtengo wa deta.
Kugwiritsira ntchito ntchitoyi pozungulira deta, kotero, kumakhudza zotsatira za mawerengedwe.
Zindikirani: Kuti ma nambala angapo kapena mmwamba popanda kusonyeza kuchuluka kwake, gwiritsani ntchito ntchito ROUNDUP kapena ROUNDDOWN m'malo mwake.
01 a 04
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 MROUND ndi:
= MROUND (mtengo, chinthu)
Zokambirana za ntchitoyi ndi izi:
mtengo - (chofunika) chiwerengero chokwera kapena chotsika kufupi kwambiri
- Mtsutso uwu ukhoza kukhala ndi deta yeniyeni yozungulira kapena ikhoza kutanthauzira selo kwa malo a deta muzenera .
Chofunika - (chofunika) ntchitoyo imayendera ndondomeko yamtengo wapatali kapena pansi pa maiko ambiri omwe ali pafupi.
Mfundo zokhudzana ndi zokhudzana ndi ntchitoyi ndi izi:
- ngati ndondomeko yotsimikizirika yasiya, nambala # N / A mu selo yomwe ili ndi ntchito.
- chofunika ndi kuyamikira zifukwa ziyenera kukhala ndi chizindikiro chomwecho - chabwino kapena choipa. Ngati ayi, ntchitoyo imabwerera #NUM! cholakwika mu selo.
- ngati chinthucho ndi chigwirizano chotsutsana ndi zonsezi, ntchitoyo imabweretsanso nambala yolakwika mu selo monga momwe tawonedwera mzere wachinayi mu chithunzi pamwambapa.
- ngati kukangana kwake kuikidwa ku zero (0), ntchitoyo imabweretsanso mtengo wa zero mu selo monga momwe tawonedwera mzere 7 mu chithunzi pamwambapa.
02 a 04
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
Kaya nambala yotsala yotsala kapena integer (chiwerengero chokongoletsera) chikukwera kapena pansi chimadalira mkangano wamtengo wapatali .
- Ngati chiwerengero chozungulira ndi nambala zonse kumanja kwake mu ndondomeko yamtengo wapatali ndi zosachepera theka la mtengo wa kukangana, ntchitoyo ikuzungulira chiwerengero chotsiriza.
- Ngati chiwerengero chokwera ndi nambala zonse kumanja kwake mu ndondomeko yamtengo wapatali zoposa kapena zofanana ndi theka la mtengo wotsutsana, chinthu chozungulira chimakonzedwa.
Zitsanzo ziwiri zomalizira - mzere 8 ndi 9 wa fano - amagwiritsidwa ntchito kusonyeza momwe ntchitoyo imayendetsera mmwamba kapena pansi.
- Mzere 8, popeza kukangana kwake 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 wotsutsana (5.00), ntchitoyo imayenda mpaka 15.00, yomwe ili pafupi kwambiri ndi 5.00 yaikulu kuposa 12.50.
- Mzere 9, kuyambira 2.49 ndi osachepera theka la mtengo wotsutsana (5.00), ntchitoyo imakhala yozungulira mpaka 10,00, yomwe ili pafupi kwambiri ndi 5.00 zosakwana 12.49.
03 a 04
Kulowa ntchito ya MROUND
Google Spreadsheets sagwiritsira ntchito bokosi la dialogso kuti muike zifukwa za ntchito monga zingapezeke mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.
- Lowetsani deta zotsatirazi mu selo A1: 4.54
- Dinani pa selo C2 mu tsambalo kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito ya MROUND zidzawonetsedwa
- Lembani chizindikiro chofanana (=) potsatira dzina la ntchitoyo
- Pamene mukuyimira, bokosi lopangira okhalo likuwoneka ndi maina a ntchito zomwe zimayamba ndi kalata M
- Dzina MROUND likuwonekera m'bokosilo, dinani pa dzina ndi phokoso la mouse kuti mulowetse dzina la ntchito ndi kutsegula mzere wozungulira mu selo C2
04 a 04
Kulowa Kutsutsana kwa Ntchito
Zolinga za ntchito ya MROUND imalowa pambuyo poyika makina ozungulira mu selo C2.
- Dinani pa selo A2 mu tsamba lothandizira kuti mulowetse seweroli ngati mgwirizano wamtengo wapatali
- Lowani chiwerengero kuti mukhale olekanitsa pakati pa zokhudzana ndi ntchito
- Mtundu 0.05 kulowetsa nambalayi ngati mtsutso
- Lembani mzere wolowera mu kiyilo kuti mulowetse mzere wozungulira " ) " pambuyo pa kukangana kwa ntchitoyo ndi kumaliza ntchitoyi
- 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 mu barra yazenera pamwamba pa tsamba