Chithunzi kumanzere chikuwonetsa zitsanzo ndipo zimapereka ndemanga za zotsatira zingapo zomwe zinabweretsedwe ndi Google Spreadsheets 'ROUNDUP ntchito kwa deta mu gawo A la tsamba. Zotsatira, zosonyezedwa m'mbali C, zidalira pa mtengo wa mtsutso wotsatila - zambiri zambiri pansipa.
01 a 02
Google Spreadsheets 'ROUNDUP Function
Mawerengedwe Ozungulira Ku Google Spreadsheets
Chithunzichi pamwamba chikuwonetsa zitsanzo ndikupereka tsatanetsatane wa zotsatira zomwe zinabweretsedwe ndi Google Spreadsheets 'ROUNDUP ntchito kwa deta m'mbali A ya tsamba.
Zotsatira, zosonyezedwa m'mbali C, zidalira pa mtengo wa mtsutso wotsatila - zambiri zambiri pansipa.
Syntax ndi Magwirizano a Funso la ROUNDUP
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa.
Chidule cha ntchito ya ROUNDUP ndi:
= ROUNDUP (chiwerengero, chiwerengero)
Zokambirana za ntchitoyi ndi izi:
nambala - (yofunika) mtengo wozungulira
- Mtsutso uwu ukhoza kukhala ndi deta yeniyeni yozungulira kapena ikhoza kutanthauzira selo kwa malo a deta muzenera .
chiwerengero - (mungasankhe) chiwerengero cha malo apamwamba kuti mutuluke
- ngati ndondomeko yowerengeka yanyalanyaza, ntchitoyo imayendetsa mtengo kupita kufupi kwambiri
- ngati chiwerengero chowerengera chaikidwa ku 1, mwachitsanzo, ntchitoyi imachokera pa digiti imodzi yokha yomwe ili kumanja kwa chiwerengero cha decimal ndikuyang'ana ku nambala yotsatira
- ngati ndondomeko yowerengera ili yoipa, malo onse osungirako amachotsedwa ndipo ntchitoyo ikuzungulira chiwerengero cha chiwerengero ndi kumanzere kwa decimal mpaka pamwamba
- Mwachitsanzo, ngati mtengo wa ndondomeko yowonjezera waperekedwa ku -1 , ntchitoyo imachotsa madiresi onse kumanja kwadi decimal ndikuzungulira digiri yoyamba kumanzere kwa decimal mpaka 10 - chitsanzo 3 mu chithunzi pamwambapa
- ngati mtengo wa ndondomeko yowonjezera ifika ku -2 , ntchitoyi idzachotsa chiwerengero choyang'ana kumanja kwa chigawo cha decimal ndikuzungulira chiwerengero choyamba ndi chachiwiri kumanzere kwa decimal mpaka 100 - chitsanzo 5 mu chithunzi pamwambapa
ROUNDUP Function Summary
Ntchito ya ROUNDUP:
- amagwiritsidwa ntchito kuchepetsa mtengo ndi nambala yeniyeni ya malo kapena decimal;
- nthawi zonse kuzungulira chiwerengero chokwera mmwamba;
- 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 amakhala kutali ndi zero. Manambala osayenerera, ngakhale atachepetsedwa phindu ndi ntchitoyi, amanenedwa kuti akukweza (zitsanzo 4 ndi 5 mu chithunzi pamwambapa).
02 a 02
Mapalegalamu a Google 'ROUNDUP Ntchito Pang'onopang'ono
Chitsanzo: Kugwiritsa Ntchito ROUNDUP Ntchito mu Google Spreadsheets
Monga tawonera pa chithunzi pamwambapa, chitsanzo ichi chigwiritsa ntchito ntchito ya ROUNDUP kuchepetsa chiwerengero mu selo A1 ku malo awiri osungira. Kuwonjezera pamenepo, izo zidzakulitsa kufunika kwa chiwerengero chokwera ndi chimodzi.
Kuwonetsa zotsatira zokhudzana ndi manambala ali ndi ziwerengero, chiwerengero choyambirira ndi ozungulira chidzawonjezeredwa ndi 10 ndipo zotsatira ziyereke.
Kulowa Deta
Lowetsani deta zotsatirazi mu maselo osankhidwa.
Cell Data A1 - 242.24134 B1 - 10Kulowa ntchito ya ROUNDUP
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.
- Dinani pa selo A2 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito ROUNDUP zidzawonetsedwa
- Lembani chizindikiro chofanana (=) chotsatira dzina la ntchito yozungulira
- Pamene mukuyimira, bokosi lopangira okhalo likuwoneka ndi mayina a ntchito zomwe zimayamba ndi kalata R
- Pamene dzina lakuti ROUNDUP likupezeka m'bokosi, dinani pa dzina ndi ndondomeko ya mouse kuti mulowetse dzina la ntchito ndi kutsegula mzere wozungulira mu selo A2
Kulowa Maganizo a Ntchito
- Pogwiritsa ntchito chithunzithunzi chija mutatseguka chingwe chotseguka, dinani pa selo A1 patsiku la ntchito kuti mulowe mulojekitiyi monga yankho la Nambala
- Potsatira selo la selo, lembani comma ( , ) kuti mukhale olekanitsa pakati pa zotsutsana
- Pambuyo pa mtundu wa makina a "2" monga ndemanga yowerengera kuchepetsa chiwerengero cha malo osungirako mtengo kuti mtengo mu A1 kuchokera kwa zisanu ndi zitatu
- Lembani mzere wozungulira " ) " kuti mutsirize zifukwa za ntchitoyo
- Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo
- Yankho 242.25 liyenera kuoneka mu selo A2
- Mukasindikiza pa selo A2 ntchito yonse = ROUNDUP (A1, 2) ikuwoneka mu barra ya fomula pamwamba pa tsamba
Kugwiritsa Ntchito Nambala Yowiridwa pa Kuwerengera
Mu chithunzi pamwambapa, mtengo mu selo C1 wapangidwira kuti uwonetse nambala zitatu zokha kuti chiwerengerochi chikhale chosavuta kuwerenga.
- Dinani pa selo C1 kuti likhale selo yogwira ntchito - izi ndi momwe njira yowonjezera idzalembedwera
- Lembani chizindikiro chofanana kuti muyambe mwambowu
- Dinani pa selo A1 kuti mulowetse selolo mu njirayi
- Lembani asteriski (*) - chizindikiro chochulukitsa mu Google Spreadsheets
- Dinani pa selo B1 kuti mulowetse selolo mu njirayi
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho
- Yankho lachiwiri 2,422,413 liyenera kuoneka mu selo C1
- Lembani nambala 10 mu selo B2
- Dinani pa selo C1 kuti mupange selo yogwira ntchito.
- Lembani ndondomekoyi mu C1 mu selo C2 pogwiritsira ntchito Kudzaza Mankhwala kapena Kopani ndi Kuyika
- Yankho lake 2,422.50 liyenera kuoneka mu selo C2.
Njira yosiyana imayambira m'maselo C1 ndi C2 - 2,422.413 pozungulira 2,422.50 amasonyeza kuti nambala yozungulira ingathe kukhala ndi chiwerengero, chomwe chingakhale chiwerengero chofunikira nthawi zina.