Maitiro ekutenderedza mhedzisiro muExcel - mafomula

Imwe yeanozivikanwa masvomhu maitiro ayo vanhu vanowanzo shandisa kana vachishanda neExcel maspredishiti ndeyekutenderedza manhamba. Vamwe vanotanga vanoedza kushandisa nhamba yefomati, asi haina kugadzirirwa kuratidza nhamba chaidzo mumasero, izvo zvinoguma nekukanganisa. Kuti uwane mhedzisiro yaunoda mushure mekutenderedza, iwe unofanirwa kushandisa akakosha mabasa akagadzirirwa uku kushanda kwemasvomhu. Iwe unofanirwa kusvika pakuziva mumwe nemumwe wavo zvakadzama.

RUND basa

Basa rakareruka raunokwanisa kutenderedza kukosha kwenhamba kuenda kunhamba inodiwa yemanhamba iROUND. Muenzaniso wakapfava ndeyekutenderedza decimal kubva panzvimbo mbiri kuenda kune imwe.

Zvakakosha kuyeuka kuti basa iri rinongotenderera kubva kune zero.

Kuonekwa kweiyo ROUND formula: ROUND(nhamba, nhamba yemanhamba). Kuwedzera nharo:

1. Nhamba yemanhamba - pano unofanira kutsanangura nhamba yenhamba iyo kukosha kwenhamba kuchatenderedzwa.
2. Nhamba - nzvimbo ino inogona kuva nhamba yenhamba, chikamu chedesimali, icho chichave chakatenderedzwa.

Nhamba yemanhamba inogona kuva:

• zvisina kunaka - munyaya iyi, chikamu chechidimbu chehuwandu hwehuwandu (iyo kuruboshwe rwechidimbu chegumi) inotenderedzwa;
• yakaenzana ne zero - manhamba ese akatenderedzwa kusvika kuchikamu chizere;
• positive - muchiitiko ichi, chikamu chechidimbu chete, chiri kurudyi rwe decimal point, chakatenderedzwa.

Setting nzira:

1. Kuti uwane nhamba yakatenderedzwa kusvika pagumi semhedzisiro, iwe unofanirwa kuvhura hwindo nekuseta basa nharo, isa kukosha "1" mumutsara we "nhamba yemanhamba".
2. Kuti utenderedze kukosha kwenhamba kusvika kumazana, unofanirwa kuisa kukosha kwe "2" muhwindo rebasa rekupokana.
3. Kuti uwane kukosha kwenhamba yakatenderedzwa kune chiuru chiri pedyo, pahwindo rekugadzirisa nharo mumutsara "nhamba yemanhamba" unofanira kuisa nhamba "3".

RoundUP uye ROUNDDOWN mabasa

Mamwe mafomula maviri akagadzirirwa kutenderedza manhamba muExcel ari ROUNDUP uye ROUNDDOWN. Nerubatsiro rwavo, unogona kutenderedza nhamba dzezvikamu kumusoro kana pasi, zvisinei kuti ndeapi manhamba ekupedzisira ari mukukosha kwenhamba.

KRUGLVVERH

Nebasa iri, unogona kutenderedza kukosha kwenhamba kubva pa0 kusvika kunhamba yakapihwa. Kuonekwa kweformula: ROUNDUP(nhamba, nhamba yemanhamba). Decoding yeformula yakangofanana neye ROUND function - nhamba imhando ipi neipi yenhamba inoda kutenderedzwa, uye pachinzvimbo chenhamba yemadijiti, nhamba yenhamba yemabhii panodiwa kutaura kwakawanda. kuderedzwa kwakaiswa.

DZONDE PASI

Uchishandisa iyi fomula, kukosha kwenhamba kunotenderedzwa pasi - kutanga kubva zero uye pazasi. Kuonekwa kwebasa: ROUNDDOWN(nhamba, nhamba yemanhamba). Kudhirodherwa kweformula iyi kwakafanana neiya yapfuura.

RUND basa

Imwe fomula inobatsira iyo inoshandiswa kutenderedza akasiyana manhamba kukosha ndeye ROUND. Inoshandiswa kutenderedza nhamba kune imwe nzvimbo yedesimali kuti uwane mhedzisiro chaiyo.

Kutenderera mirayiridzo

Muenzaniso wakajairika weformula yekutenderedza nhamba dzenhamba ndiwo mutsara unotevera: Basa (numeric value; nhamba yemanhamba). Muenzaniso unotenderedza kubva pamuenzaniso unoshanda:

1. Sarudza chero sero yemahara ine bhatani rekuruboshwe.
2. Nyora chikwangwani "=".
3. Sarudza rimwe remabasa - ROUND, ROUNDUP, ROUNDDOWN. Nyora ipapo mushure mechiratidzo chakaenzana.
4. Nyora hunhu hunodiwa mumabhuraketi, tinya bhatani rekuti "Enter". Sero rinofanira kuratidza mhedzisiro.

Chero mabasa anogona kusetwa kuburikidza ne "Function Wizard" kune chaiyo sero, nyora iwo muchitokisi pachayo kana kuburikidza nemutsetse wekuwedzera mafomula. Iyo yekupedzisira inoratidzwa nechiratidzo "fx". Kana iwe ukapinda wakazvimirira musero kana mutsara wemafomula, chirongwa chinoratidza runyoro rwezvaungagona kuita kurerutsa basa remushandisi.

Imwe nzira yekuwedzera mabasa ekuita masvomhu akasiyana siyana ari kuburikidza nebhari rekushandisa. Pano iwe unofanirwa kuvhura iyo "Formulas" tebhu, sarudza sarudzo yekufarira kubva pane inovhura runyorwa. Mushure mekudzvanya pane chero basa rakarongwa, hwindo rakaparadzana "Function Arguments" richaonekwa pachiratidziri, umo iwe unofanirwa kuisa kukosha kwenhamba mumutsara wekutanga, nhamba yemanhamba ekutenderera - mune yechipiri.

Zvinogoneka kuratidza otomatiki mhedzisiro nekutenderedza nhamba dzese kubva kune imwe column. Kuti uite izvi, zvakakosha kuita kuverenga kune imwe yepamusoro-soro masero, muchitokisi chakatarisana nayo. Kana mhedzisiro yawanikwa, unofanirwa kufambisa chitubu kumucheto kwesero iri, kumirira kuti muchinjikwa mutema uoneke mukona yayo. Kubata LMB, tambanudza mhedzisiro yenguva yese yekoramu. Mhedzisiro yacho inofanira kunge iri koramu ine zvese zvinodiwa mhedzisiro.

Zvinokosha! Kune mamwe akawanda mafomula anogona kushandiswa mukuita kutenderedza akasiyana manhamba. ODD - inotenderedza kusvika kunhamba yekutanga isinganzwisisike. EVEN - Kutenderedza kusvika kune yekutanga kunyange nhamba. KUDUKURWA - uchishandisa basa iri, kukosha kwenhamba kunotenderedzwa kunhamba yese nekurasa manhamba ese mushure medesimali.

mhedziso

Kutenderedza nhamba dzenhamba muExcel, kune akati wandei maturusi - ega mabasa. Mumwe nomumwe wavo anoita kuverenga mune imwe nzira (pazasi kana pamusoro 0). Panguva imwecheteyo, nhamba yemanhamba inotarwa nemushandisi pachake, nekuda kwaanogona kuwana chero mhedzisiro yekufarira.