01 a 03
Mapulani a Google Spreadsheets 'ROUND
Ntchito ya ROUND ingagwiritsidwe ntchito kuchepetsa mtengo ndi malo enieni a malo a decimal.
Pakali pano, chiwerengero chomaliza, chiwerengero chozungulira, chimakwera kapena pansi.
Malamulo a manambala ozungulira omwe Google Spreadsheets amatsata, akulamula;
- Ngati mtengo wa nambala yomwe ili kumanja kwa chiwerengero chokwera ndi osachepera asanu, chiwerengero chozungulira chikusinthika;
- Ngati mtengo wa nambala yomwe ili kudzanja lamanja ndi zisanu kapena kuposerapo, chiwerengero chokwera chikukwera ndi chimodzi.
Ndiponso, mosiyana ndi zosankha zokometsera zomwe zimakulolani kusintha chiwerengero cha malo osungirako osasintha popanda kusintha phindu mu selo, ntchito ya ROUND, monga ntchito zina za Google Spreadsheets, zimasintha mtengo wa deta.
Kugwiritsira ntchito ntchitoyi pozungulira deta, kotero, kumakhudza zotsatira za mawerengedwe.
Chithunzichi pamwamba chikuwonetsa zitsanzo ndikupereka tsatanetsatane wa zotsatira zomwe zinabweretsedwera ndi Google Spreadsheets 'ROUNDDOWN ntchito ya deta mu gawo A la tsamba.
Zotsatira, zosonyezedwa m'mbali C, zimadalira kufunika kwa mtsutsano wotsatira - onani tsatanetsatane pansipa.
02 a 03
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 (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 yasiya, ntchitoyi imayendetsa mtengo kupita kufupi kwambiri
- Ngati ndemanga yowonjezera yayikidwa ku 1, mwachitsanzo, ntchitoyi imachokera pa digiti imodzi yokha yomwe ili kumanja kwa chiwerengero cha decimal ndikuyang'ana ku nambala yotsatira
- Ngati ndemanga yowerengera ili yoipa, malo onse osungirako amachotsedwa ndipo ntchitoyo imayang'ana chiwerengero cha ziwerengero ndi kumanzere kwa decimal mpaka pansi
- Mwachitsanzo, ngati mtengo wa ndondomeko yowonjezera idaikidwa ku -1 , ntchitoyi idzachotsa chiwerengero chonse ku malo a decimal ndi kuzungulira chiwerengero choyamba kumanzere kwa decimal mpaka 10 - chitsanzo 2 mu chithunzi pamwambapa
- Ngati mtengo wa ndondomeko yowonjezera idafika ku -2 , ntchitoyi idzachotsa chiwerengero chonse kumalo oyenera a decimal ndi kuzungulira chiwerengero choyamba ndi chachiwiri kumanzere kwa decimal mpaka 100 - chitsanzo 4 mu chithunzi pamwambapa
03 a 03
ROUNDDOWN Function Summary
Ntchito ya ROUNDDOWN:
- Amagwiritsidwa ntchito kuchepetsa mtengo ndi chiwerengero china cha malo a decimal kapena chiwerengero;
- Nthawi zonse musasiye chiwerengero chosasinthika - musachiyambe kuzungulira;
- Kuwonetsa kufunika kwa deta mu selo - mosiyana ndi zosankha za maonekedwe omwe amakulolani kusintha chiwerengero cha malo osungidwa osasintha popanda kusintha kwenikweni mu selo;
- Zimakhudza zotsatira za mawerengedwe chifukwa cha kusintha kwa deta.
- Nthawi zonse amayang'ana ku zero. Manambala osayenerera, ngakhale kuti awonjezeka phindu ndi ntchitoyo, amanenedwa kuti akutsitsidwa (zitsanzo 4 ndi 5 mu chithunzi pamwambapa).