Momwe mungazungulire manambala mmwamba ndi pansi mu Excel

Nthawi ndi nthawi pangakhale vuto lomwe muyenera kuzungulira manambala. Izi zikhoza kukhala kutsimikiza kwa mtengo wapafupi kwambiri m'sitolo, kuwerengera mtengo wa katundu pambuyo pa kukwezedwa, malipiro pa deposit ndi ntchito yosonkhanitsa kusintha kochepa, ndi zina.

Pali njira zingapo zokwaniritsira ntchitoyi. Choyamba ndikusintha mawonekedwe amtundu wa cell. Chachiwiri ndi kugwiritsa ntchito ntchito. Kusiyana kwa njira zimenezi n’kwambiri. Mtundu wowonetsera ma cell umafunika nthawi zina pomwe muyenera kuwonetsa zilembo zazing'ono kapena kusindikiza tebulo. Ndiye ndi zokwanira kusintha maonekedwe a selo. Sichisintha zimene zili mmenemo.

Njira yachiwiri imakulolani kugwiritsa ntchito mtengo wozungulira powerengera. Ndikokwanira kungolowetsa chilinganizo choyenera, ndiyeno chizindikirochi chingagwiritsidwe ntchito pazifukwa zosiyanasiyana. Pa nkhani imeneyi, chinthu chachikulu si kulakwitsa. Choncho tiyeni tione mwatsatanetsatane.

Momwe mungazungulire nambala pokhazikitsa mawonekedwe a cell?

Tiyeni titsegule tebulo ndikusuntha cholozera ku selo A1. Kenako, lembani nambala yachigawo 76,575 pamenepo. Kenako, dinani kumanja ndi mbewa, ndiyeno kusankha "Format Maselo" mwina. Zenera lidzawoneka. Itha kuyitanidwanso ndikukanikiza Ctrl + 1 kapena kuchokera ku Home tabu (Nambala chida).

Pazenera lomwe likuwoneka, tili ndi chidwi ndi mtundu wa manambala momwe timasankhira kuchuluka kwa malo omwe akufunika tsopano. Tiyerekeze kuti akulowererapo tsopano. Apa mutha kukhazikitsa mtengowu kukhala 0.

Tikatsimikizira zosintha zomwe zachitika, tidzakhala ndi mtengo womaliza m'selo - 77.

Chilichonse, monga tikuwonera, ndichokwanira kukanikiza mabatani ochepa a mbewa, ndipo, ngati ndi matsenga, nambala yozungulira imayamba kuwonetsedwa. Koma tiyenera kukumbukira kuti sangagwiritsidwe ntchito masamu masamu. 

Momwe mungazungulire nambala mu Excel

Kwa ife, kuzungulira kunkachitika pofuna kuwonjezeka. Zimatengera nambala yomwe ikuchotsedwa. Ngati pali 5 kapena kuposerapo kutsogolo kwa mtengo womwe ukufunidwa, ndiye kuti kuzungulira kumachitika molunjika, ndipo ngati kuli kochepa, kumazungulira. Chilichonse chili momwe ziyenera kuchitikira masamu, palibe kusintha kwa malamulo.

Kulondola kwa zotsatira zimadalira kuchuluka kwa zilembo zomwe munthu wasankha kuchoka. Chokulirapo, ndichokwera kwambiri cholondola. Chifukwa chake, tikulimbikitsidwa kuti muzingozungulira zomwe zili zofunika pakufunika kutero.. Nthawi zina ngakhale kuzungulira pang'ono kumatha kupotoza mawerengedwewo. Izi, mwa njira, ndi chimodzi mwa zifukwa zofala kwambiri zomwe olosera nthawi zambiri amalakwitsa. Ngakhale zotsatira za gulugufe zinadziwika pamene, chifukwa cha kusiyana kochepa pakati pa mtengo wozungulira ndi wamakono, nyengo yamvula inanenedweratu.

Momwe mungazungulire nambala mmwamba ndi pansi?

Njira yabwino kwambiri yozungulira mu Excel ndikugwiritsa ntchito masamu. Ndi chithandizo chake, mutha kupeza kuzungulira kwenikweni, osati zowoneka. Ubwino wa njira imeneyi ndi wakuti munthu akhoza kusankha yekha njira yoti ayendere. Koma mpaka titaulula makhadi onse, timasunga chiwembucho. Pang'ono pang'ono, ndipo mudzadziwa zomwe muyenera kuchita kuti mukwaniritse cholinga ichi.

Momwe mungafikire nambala yonse

Monga tawonetsera m'chitsanzo chapitachi, ndikwanira kungochotsa manambala mu gawo laling'ono kuchokera ku chilinganizo, popeza nambalayo nthawi yomweyo imakhala nambala. Umu ndi momwe kuzungulira kumagwirira ntchito! Koma mothandizidwa ndi chilinganizo, mukhoza kupeza chiwerengero chenichenicho, ndipo njira yomwe tafotokozayi ndi yowonekera. Koma malingaliro sasintha kutengera ngati zotsatira zenizeni kapena zowoneka zidzawonetsedwa. Muyenerabe kuyika zilembo ziro.

N'zothekanso kugwiritsa ntchito ntchito Chithunzi cha KRUGLVVERH и ZUNGULIRA PASIkusunga nambala yozungulira yokha. Chifukwa chake, kuzungulira koyamba kumazungulira, ndipo kuzungulira kwachiwiri kumapita kosiyana ndi koyamba. Pankhani ya makhalidwe oipa, zosiyana ndizowona, chifukwa kuzungulira kukuchitika modulo 

Chifukwa chiyani Excel imazungulira manambala akulu?

Pafupifupi ma calculator kapena pulogalamu iliyonse, ngati mulowetsa ziwerengero zazikulu kwambiri, zimazunguliridwa mpaka mawonekedwe E + ndi zina zotero. Excel ndi chimodzimodzi. N’chifukwa chiyani zimenezi zikuchitika?

Ngati nambalayo ili ndi manambala opitilira 11, ndiye kuti imasinthidwa kukhala 1,111E +11. Kuyimira nambala uku kumatchedwa exponential. Ndizovuta kupanga njira yoyimira yotere pamanja. Kuti muchite izi, muyenera kuwerengera logarithm ya nambalayo ndikuchita zina zingapo.

Ngati sitikufuna kuti Excel azizungulira manambala akulu, tiyenera kutsogola mtengo womwewo ndi '. Choyamba muyenera kukhazikitsa lemba mtundu. Koma sikudzakhalanso zotheka kuchita masamu popanda kugwiritsa ntchito njira zapadera. 

Ndizovomerezekanso kuyika ma values ​​ngati nambala yokhala ndi mipata. Excel imangosintha selo kukhala mtundu wamawu. Ndizosatheka kukhazikitsa mwachindunji kuti pulogalamu ya spreadsheet isachite izi. Pokhapokha mwa kukhazikitsa apostrophe. 

Momwe mungazungulire ndi Excel function?

Ndipo tsopano tiyeni tipite molunjika kukachita. Zoyenera kuchita pozungulira manambala pogwiritsa ntchito ntchito? Pali ntchito yapadera ya izi. ROUNDWOOD. Itha kutchedwa m'njira zosiyanasiyana: kudzera mu riboni mumitundu ya Excel 2007 ndi yatsopano.

Njira yachiwiri ndiyo kulemba pamanja. Ndiwotsogola kwambiri chifukwa muyenera kudziwa mawuwo osachepera.

Njira yosavuta kwa oyamba kumene ndikugwiritsa ntchito wizard. Kuti muchite izi, muyenera kupeza batani pafupi ndi mzere wolowetsa fomula, pomwe kuphatikiza kwa zilembo zazing'ono fx kumalembedwa. Mutha kupeza ntchitoyi mu gawo la "Math", ndipo mutayisankha, mudzafunsidwa kuti mulowe mkangano. Aliyense wa iwo anasaina, kotero n'zosavuta kumvetsa.

RUND Function Syntax

Ngati mawu akugwiritsidwa ntchito, muyenera kumvetsetsa momwe mungalembere molondola. Dongosolo lomwe mfundo zimalowetsedwa zimatchedwa syntax. Ntchito iliyonse imakhala ndi mawu omveka bwino. Choyamba, chizindikiro chofanana chimalembedwa, ndiye dzina la ntchitoyo, ndiye zotsutsana, zomwe zimalembedwa m'mabokosi, ndipo zimalekanitsidwa ndi comma. Chiwerengero cha mikangano chikhoza kusiyana ndi ntchito ndi ntchito. Ena mwa iwo mulibe konse, ndipo ena mwa iwo ali osachepera 5, osachepera. 

Pankhani ya ntchito ya ROUND, pali awiri. Tiyeni tione mwatsatanetsatane.

RUND zokangana zantchito

Chifukwa chake ntchitoyi ili ndi zifukwa ziwiri:

1. Nambala. Ichi ndi cholozera pa cell. Kapenanso, mutha kuyika mtengo womwe mukufuna mumkanganowu pamanja.
2. Chiwerengero cha manambala omwe mukuzungulira.
   

   

Kuti muzungulire nambala yonse (ndiko kuti, yomwe ilibe malo owerengera), ingolembani chizindikiro chochotsera patsogolo pa nambala mugawo lachiwiri. Kuti mufikire makumi, muyenera kulemba -1, mazana -2, ndikutsatira mfundo iyi mopitilira. Kukula kwa gawo la nambala iyi, manambala ochulukirapo adzazunguliridwa. 

Zoyambira ntchito ROUNDWOOD

Tiyeni tiwone momwe ntchitoyi ingagwiritsire ntchito, pogwiritsa ntchito chitsanzo cha kuzungulira zikwi.

Tangoganizani tili ndi tebulo loterolo. Talemba fomula yozungulira mu cell yachiwiri, ndipo tikuwona zotsatira zake pachithunzichi.

Ndizotheka kuzungulira osati nambala yokha, komanso mtengo uliwonse. Mu chitsanzo, zikuwoneka ngati izi. Tiyerekeze kuti tili ndi mizati itatu. Pachiyambi choyamba, mtengo wa katundu umalembedwa, chachiwiri - momwe unagulidwa. Koma chachitatu, motero, mtengo womaliza ukuwonetsedwa. 

Tangoganizani kuti ntchito yathu ndikuwonetsa kuchuluka kwa ma ruble, ndikunyalanyaza ndalamazo. Kenako mupeza tebulo lotsatirali.

Mwa kuchulukitsa

Excel imapangitsa kuti zizitha kuzungulira manambala osati kufupi kwambiri, koma kwa omwe amachulukitsa ena. Pali ntchito yapadera ya izi yotchedwa ROUND. Ndi chithandizo chake, mutha kukwaniritsa kulondola kozungulira komwe kumafunikira. 

Pali mfundo ziwiri zazikulu. Yoyamba ndi nambala yomwe iyenera kuzunguliridwa. Yachiwiri ndi nambala yomwe iyenera kukhala yochulukitsa ya yomwe yaperekedwa. Mfundo ziwirizi zitha kuperekedwa pamanja kapena kudzera mu selo. 

Potengera kuchuluka kwa zilembo

Zitsanzo zonse zomwe zafotokozedwa pamwambapa ndizochitika zapadera zozungulira ndi kuchuluka kwa zilembo. Ndikokwanira kungolowetsa nambala yofunikira ya zilembo kuti zisiyidwe muzokambirana zofananira. Kwenikweni, ndizo zonse. 

Kuzungulira mu Excel pogwiritsa ntchito ntchito ya ROUNUP

Wogwiritsa akhoza kudziyimira pawokha njira yozungulira. Kugwiritsa ntchito Chithunzi cha KRUGLVVERH mutha kuchotsa manambala owonjezera kapena kuzungulira nambala yonse mpaka yomwe ikuwoneka yokwezeka.

Chitsanzo chogwiritsa ntchito fomula ichi chikuwoneka pachithunzichi.

Kusiyana kwakukulu pakati pa ntchitoyi ndi ROUNDWOOD ndiye kuti ntchitoyo nthawi zonse imazungulira. Ngati pali manambala aliwonse a nambala, kuzungulira kumachitika ku nambala inayake ya iwo.

RoundUP Ntchito Syntax

Ntchitoyi imatenga mfundo ziwiri. Kawirikawiri, ntchitoyi ikuwoneka ngati iyi.

=ROUNDLVVERH(76,9)

Tsopano tiyeni tione mwatsatanetsatane mfundo zake.

Zotsutsana za Ntchito RoundUP

Kalembedwe ka ntchitoyi, monga tikuonera, ndi yosavuta. Zotsutsazo ndi izi:

1. Nambala. Iyi ndi nambala iliyonse yomwe ikufunika kuzungulira.

2. Chiwerengero cha manambala. Nambala ya manambala omwe adzasiyidwe pambuyo pozungulira alowa apa.

Choncho, mu syntax, ndondomekoyi si yosiyana ndi ROUNDWOOD. Makhalidwe a nambala amatsimikizira kuti ndi nambala ziti zomwe zidzachepe. Ngati mtsutso wachiwiri uli wabwino, ndiye kuti kuzungulira kumachitikira kumanja kwa decimal point. Ngati ili negative, ndiye kumanzere. 

Kuzungulira mu Excel pogwiritsa ntchito ntchito ZUNGULIRA PASI

Ntchitoyi imagwira ntchito mofanana ndi yapitayi. Lili ndi zotsutsana zofanana ndi mawu, komanso machitidwe omwewo amagwiritsidwira ntchito. Kusiyanitsa kokhako ndikuti kuzungulira kumachitika molowera pansi (kuchokera ku nambala yayikulu kupita ku yaying'ono, mwa kuyankhula kwina). Chifukwa chake dzina.

Mawu onse ogwiritsidwa ntchito ndi ofanana. Chifukwa chake, ngati mkangano wachiwiri (tidzawapatsa mtsogolo pang'ono) uli wofanana ndi ziro, nambalayo imazunguliridwa mpaka nambala yonse. Ngati zosakwana 0, ndiye kuti chiwerengero cha manambala pamaso pa decimal chimachepetsedwa. Ngati ndi wamkulu kuposa zero, ndiye - pambuyo pake. Mwanjira iyi, mutha kuchotsa ziwerengero zingapo zamagawo a decimal.

RoundDOWN Function Syntax

Chifukwa chake, ma syntax amafanana kwathunthu ndi chitsanzo cham'mbuyomu. Chifukwa chake, sizosiyana kwambiri. Koma ngati pali chikhumbo chotere, Excel imathandizira kugwiritsa ntchito ntchitoyi mwaokha.

Choyamba muyenera kupita ku chikalata chomwe mukufuna, tsegulani pepala lolondola ndikuyamba kulemba chizindikiro chofanana pamzere wolowetsa fomula. Pambuyo pake, muyenera kufotokoza mwachindunji dzina lachilinganizo ROUNDOWN, Kenako lowetsani mikangano iwiri.

Kawirikawiri, ndondomekoyi ikuwoneka motere.

=RoundString(3,2, 0)

Tsopano tiyeni tione mwatsatanetsatane zomwe ntchito iyi ili nayo.

Zokambirana ZUNGULIRA PASI

Pamenepa, zotsutsana ndizofanana ndendende ndi zomwe zidalembedwa kale. Choyamba muyenera kufotokoza manambala omwe akuyenera kuzungulira (chiwerengero chimodzi kapena chiwerengero chonse), pambuyo pake, kupyolera mu semicolon, tchulani chiwerengero cha manambala omwe adzachepetsedwa. Malamulo ena onse ndi ofanana kwathunthu.

Chifukwa chake, kuzungulira mu Excel ndi chinthu chosavuta koma chothandiza chomwe chimalola munthu kuti achepetse kuwerengera kapena kuzindikira. Chinthu chachikulu ndikumvetsetsa bwino njira yomwe iyenera kugwiritsidwa ntchito komanso pazochitika zenizeni. Ngati timangofunika kuwonetsa deta (kusindikiza ndi chimodzi mwazinthu zomwe zingatheke), ndiye kuti tigwiritse ntchito mawonekedwe a selo. 

Ngati munthu akufunika kuchita masamu athunthu, ndiye kuti kugwiritsa ntchito ntchito kapena chilinganizo ndicho njira yokhayo yomwe ingatheke. N’zoona kuti zinthu ngati zimenezi sizichitikachitika. Nthawi zambiri anthu, m'malo mwake, amazungulira mozungulira.