Momwe mungazungulire zotsatira mu Excel - formulas

Imodzi mwamasamu otchuka omwe anthu amagwiritsa ntchito nthawi zambiri akamagwira ntchito ndi Excel spreadsheets ndi manambala ozungulira. Oyamba ena amayesa kugwiritsa ntchito chiwerengero cha nambala, koma sichinapangidwe kuti chiwonetsere manambala enieni m'maselo, zomwe zimabweretsa zolakwika. Kuti mupeze zotsatira zomwe mukufuna mutatha kuzungulira, muyenera kugwiritsa ntchito ntchito zapadera zomwe zimapangidwira masamuwa. Muyenera kudziwa aliyense wa iwo mwatsatanetsatane.

RUND ntchito

Ntchito yosavuta kwambiri yomwe mungazungulire mtengo wa manambala ku nambala yofunikira ya manambala ndi ROUND. Chitsanzo chosavuta kwambiri ndikuzunguliza decimal kuchoka pa malo awiri kupita ku amodzi.

Ndikofunika kukumbukira kuti ntchitoyi imangozungulira kutali ndi zero.

Mawonekedwe a RUND formula: ROUND(chiwerengero, chiwerengero cha manambala). Kukulitsa mikangano:

1. Chiwerengero cha manambala - apa muyenera kufotokoza chiwerengero cha manambala omwe chiwerengerocho chidzazunguliridwa.
2. Nambala - malowa akhoza kukhala chiwerengero cha chiwerengero, chiwerengero cha decimal, chomwe chidzazunguliridwa.

Nambala ya manambala ikhoza kukhala:

• zoipa - pamenepa, gawo lokhalo la chiwerengero cha chiwerengero (chimodzi cha kumanzere kwa chiwerengero cha decimal) chimazungulira;
• zofanana ndi ziro - manambala onse amazunguliridwa ku gawo lonse;
• zabwino - pakadali pano, gawo laling'ono lokha, lomwe lili kumanja kwa decimal, ndilozungulira.

Njira zokhazikitsira:

1. Kuti mupeze nambala yozungulira mpaka chakhumi monga chotsatira, muyenera kutsegula zenera ndikuyika zotsutsana za ntchito, lowetsani mtengo "1" mu "chiwerengero cha manambala".
2. Kuti muzungulire mtengo mpaka zana, muyenera kuyika mtengo "2" pazenera lazosintha zantchito.
3. Kuti mupeze nambala yozungulira mpaka chikwi chapafupi, pawindo lokhazikitsa mikangano pamzere "chiwerengero cha manambala" muyenera kulowa nambala "3".

RoundUP ndi ROUNDDOWN ntchito

Mafomu ena awiri omwe adapangidwa kuti azizungulira manambala mu Excel ndi ROUNDUP ndi ROUNDDOWN. Ndi chithandizo chawo, mutha kuzungulira manambala ang'onoang'ono m'mwamba kapena pansi, mosasamala kanthu kuti ndi manambala ati omaliza omwe ali mumtengowo.

Chithunzi cha KRUGLVVERH

Ndi ntchitoyi, mutha kuzungulira nambala kuchokera pa 0 mpaka nambala yoperekedwa. Mawonekedwe a formula: ROUNDUP(chiwerengero, chiwerengero cha manambala). Kufotokozera kwa ndondomekoyi ndi kofanana ndi ntchito ya ROUND - nambala ndi nambala iliyonse yomwe iyenera kuzunguliridwa, ndipo m'malo mwa chiwerengero cha manambala, chiwerengero cha zilembo zomwe mawuwa amafunikira. kuchepetsedwa kwakhazikitsidwa.

ZUNGULIRA PASI

Pogwiritsa ntchito ndondomekoyi, chiwerengero cha manambala chimafupikitsidwa - kuyambira pa ziro ndi pansi. Mawonekedwe a ntchito: ROUNDDOWN(nambala, chiwerengero cha manambala). Kumasulira kwa fomulayi ndi kofanana ndi kwam'mbuyomu.

RUND ntchito

Njira ina yothandiza yomwe imagwiritsidwa ntchito pozungulira manambala osiyanasiyana ndi ROUND. Amagwiritsidwa ntchito kuzungulira nambala kupita kumalo enaake kuti apeze zotsatira zolondola.

Malangizo ozungulira

Chitsanzo chodziwika bwino cha chilinganizo chozungulira manambala ndi mawu awa: Ntchito (chiwerengero cha nambala; chiwerengero cha manambala). Chitsanzo chozungulira kuchokera ku chitsanzo chothandiza:

1. Sankhani selo iliyonse yaulere ndi batani lakumanzere.
2. Lembani chizindikiro "=".
3. Sankhani imodzi mwazochita - ROUND, RoundUP, ROUNDDOWN. Lembani pambuyo pa chizindikiro chofanana.
4. Lembani zofunikira m'mabulaketi, dinani batani la "Enter". Selo liyenera kuwonetsa zotsatira.

Ntchito zilizonse zitha kukhazikitsidwa kudzera mu "Function Wizard" kupita ku selo linalake, kuwalemba mu selo lomwelo kapena kudzera pamzere wowonjezera ma formula. Chotsatiracho chikuwonetsedwa ndi chizindikiro "fx". Mukalowa mu cell kapena mzere wama fomula paokha, pulogalamuyo imawonetsa mndandanda wazomwe mungachite kuti muchepetse ntchito ya wogwiritsa ntchito.

Njira ina yowonjezerera ntchito kuti muwerenge masamu osiyanasiyana ndi kudzera pa toolbar. Apa muyenera kutsegula tabu ya "Mafomu", sankhani zomwe mukufuna kuchokera pamndandanda womwe umatsegulidwa. Mukadina pazigawo zilizonse zomwe zaperekedwa, zenera lapadera la "Function Arguments" lidzawonekera pazenera, momwe muyenera kuyika nambala mumzere woyamba, kuchuluka kwa manambala ozungulira - chachiwiri.

Ndizotheka kuwonetsa zotsatira pozungulira manambala onse kuchokera pagawo limodzi. Kuti tichite izi, ndikofunikira kuwerengera gawo limodzi mwamaselo apamwamba kwambiri, mu selo moyang'anizana nalo. Zotsatira zikapezeka, muyenera kusuntha cholozera m'mphepete mwa seloli, dikirani kuti mtanda wakuda uwoneke pakona yake. Kugwira LMB, tambasulani zotsatira kwa nthawi yonse ya gawolo. Chotsatiracho chiyenera kukhala mzere wokhala ndi zotsatira zonse zofunika.

Zofunika! Palinso njira zina zingapo zomwe zingagwiritsidwe ntchito polemba manambala osiyanasiyana. ODD - imazungulira mpaka nambala yoyamba yosamvetseka. EVEN - Kuzungulira mpaka nambala yoyamba. KUCHEPETSA - pogwiritsa ntchito ntchitoyi, chiwerengero cha nambala chimazunguliridwa ku chiwerengero chonse mwa kutaya manambala onse pambuyo pa decimal.

Kutsiliza

Kuzungulira manambala mu Excel, pali zida zingapo - ntchito payokha. Aliyense wa iwo amachita kuwerengera mbali ina (m'munsimu kapena pamwamba 0). Panthawi imodzimodziyo, chiwerengero cha manambala chimayikidwa ndi wogwiritsa ntchito mwiniwake, chifukwa chomwe angapeze zotsatira za chidwi.