Microsoft Excel ua haujlwm nrog cov lej cov ntaub ntawv thiab. Thaum ua kev sib faib los yog ua hauj lwm nrog cov zauv feem xyuam, qhov kev pab cuam rounds. Qhov no yog vim yog qhov tseeb tias qhov tseeb cov zauv feem ntau yuav tsum tsis tshua muaj, tiam sis nws tsis yog yooj yim heev los khiav lag luam nrog ib qho kev qhia loj nrog ntau qhov chaw zauv. Ntxiv rau qhov no, muaj ntau cov lej uas tsis muaj tseeb raws li hauv paus ntsiab lus. Tab sis, tib lub sij hawm, tsis muaj txuam yuaj yuav ua rau tag nrho cov teeb meem hauv qhov xwm txheej uas yuav tsum tau ua. Zoo hmoo, hauv Microsoft Excel, cov tib neeg siv lawv tus kheej tuaj yeem npaj cov lej ua ke.
Khaws cov zauv hauv Excel nco
Tag nrho cov xov tooj nrog Microsoft Excel ua haujlwm yog muab faib ua txhua yam thiab kwv yees. Cov lej xov tooj txog 15 tus lej muab cia rau hauv lub cim xeeb, thiab tso tawm kom pom kom txog thaum tus zauv uas tus neeg siv nws tus kheej hais. Tab sis, tib lub sij hawm, tag nrho cov lus teb yog ua raws li cov ntaub ntawv khaws cia hauv lub cim xeeb, thiab tsis tso tawm kom pom ntawm lub monitor.
Siv lub tshuab ua luam, Microsoft Excel discards ib qho zauv ntawm cov zauv. Hauv Excel, txoj kab kev siv pa luam yeeb yuav siv, thaum tus lej tsawg tshaj 5 yog sib npaug, thiab ntau dua los sis sib npaug li 5 xyoos.
Sib npaug nrog cov nyees khawm ntawm txoj hlua
Qhov yooj yim tshaj los hloov cov kab ntawv ntawm tus nab npawb yog xaiv ib lub xovtooj ntawm tes lossis ib pawg ntawm cov hlwb, thiab thaum nyob hauv lub Tsev tab, nyem rau ntawm txoj kab ntawm "Cov Kev Txiav Txim Siab" lossis "Decrease Digitality" khawm. Ob qho nyees khawm no nyob hauv tus "Number" toolbox. Hauv qhov no, tsuas yog tus naj npawb cov xov tooj yuav muab sib npaug, tab sis rau cov lus teb, yog tias tsim nyog, txog li ntawm 15 tus lej ntawm cov lej yuav tsum muaj feem xyuam.
Thaum koj nias rau ntawm lub pob "Ua kom lub dav dav", tus naj npawb ntawm cov cim kos npe tom qab lub zuj zus nce los ntawm ib qho.
Thaum koj nias rau lub khawm "Txo ntsis qhov tob" tus nab npawb ntawm cov zauv tom qab cov zauv zuag yog txo los ntawm ib qho.
Sib npaug ntawm hom xov tooj ntawm tes
Koj tuaj yeem teem cov phiaj siv xov tooj ntawm cov hom phiaj. Ua li no, xaiv qhov ntau ntawm cov hlwb ntawm daim ntawv, nias lub khawm txoj kev nas, thiab xaiv cov "Hom ntawv ntawm cov hlwb" hauv cov zaub mov uas tshwm sim.
Hauv qhov qhib qhov rai ntawm lub hom phiaj ntawm lub xov tooj ntawm tes, mus rau "Naj Npawb" tab. Yog tias cov ntaub ntawv tsis yog numeric, ces koj yuav tsum xaiv hom ntawv numeric, txwv tsis pub koj yuav tsis muaj peev xwm hloov lub rounding. Nyob hauv nruab nrab ntawm lub qhov rais uas nyob ze rau ntawm lub thev ntawv "Tus nab npawb ntawm cov chaw zauv" peb tsuas yog qhia tus naj npawb ntawm cov cim uas peb xav pom thaum twg. Tom qab ntawd, nyem rau ntawm "OK" khawm.
Teem caij xam qhov tseeb
Yog tias yav dhau los, cov txheej xwm tsis tsuas yog cuam tshuam cov ntaub ntawv qhia lwm yam, thiab ntau yam qhia tau tseeb (txog li 15 lub cim) raug siv rau hauv cov lus teb, tam sim no peb yuav qhia rau koj tias yuav pauv tau qhov tseeb ntawm cov lus teb.
Ua li no, mus rau "Cov Ntaub Ntawv" tab. Ntxiv mus, tshais mus rau "Tshooj".
Lub Excel xaiv qhib qhov rai. Hauv qhov rai no, mus rau seem "Advanced". Peb tab tom nrhiav ib ntu ntawm qhov chaw hu ua "Thaum recalculating phau ntawv no." Cov chaw nyob rau sab no yog siv rau cov ntawv txheeb, tab sis rau tag nrho cov phau ntawv raws li tus kheej, uas yog, rau tag nrho cov ntaub ntawv. Peb muab tus zuam los tso rau hauv pem hauv ntej ntawm cov parameter "Koj yuav tsum ua raws li ntawm qhov screen." Nias rau ntawm "OK" khawm nyob sab qis sab laug ntawm lub qhov rais.
Tam sim no, thaum xam xyuas cov ntaub ntawv, tus nqi naj npawb ntawm tus naj npawb ntawm qhov screen yuav raug coj mus rau hauv tus account, thiab tsis yog ib qho cia rau hauv Excel nco. Kev kho ntawm tus naj npawb zauv yuav ua tau nyob rau hauv ib qho ntawm ob txoj kev, uas peb tau tham saum toj no.
Daim ntawv thov kev ua haujlwm
Yog hais tias koj xav hloov cov nqi rounding thaum koj xam nrog rau ib lub los yog ntau lub hlwb, tab sis koj tsis xav txo cov lus teb rau cov ntaub ntawv tag nrho, ces qhov no, nws yog qhov zoo tshaj plaws los siv cov kev pab cuam los ntawm ROUND kev ua haujlwm thiab nws cov kev hloov ntau yam, thiab ib txhia nta.
Ntawm cov haujlwm tseem ceeb tshaj plaws uas tswj kev sib npaug, cov hauv qab no yuav tsum muaj:
- ROUND - rounds rau cov zauv cim cov zauv, raws li kev lees txais cov kev cai;
- ROUND-UP - rounds mus txog tus xov tooj ze tshaj plaws ntawm qhov module;
- ROUNDDOWN - rounds mus rau tus xov tooj uas ze tshaj plaws hauv qab;
- RING - rounds tus naj npawb nrog ib tug muab qhov tseeb;
- OKRVVERH - rounds tus naj npawb nrog ib tug muab kev tseeb txog qhov module;
- OKRVNIZ - muab cov zauv cia rau hauv cov module nrog qhov muab tau;
- OTBR - muab cov ntaub ntawv rau ib qho integer;
- CHETN - rounds cov ntaub ntawv mus rau qhov ze txawm tooj;
- Khib - rounds cov ntaub ntawv mus rau tus xov tooj tsawg tshaj plaws.
Cov lus qhia nram qab no yog: "Cov npe ua haujlwm (tus lej, tus lej) Cov lus no yog, yog koj, piv txwv, xav muab tus lej 2.56896 mus rau peb tug lej, ces siv lub ROUND (2.56896; 3). Cov zis yog tus naj npawb 2.569.
Cov qauv hauv qab no yog siv rau kev khiav dej num ROUNDCASE, OKRVVER thiab OKRVNIZ: "Lub npe ntawm txoj haujlwm (naj npawb; kev tseeb)". Piv txwv, kom muab tus naj npawb 11 mus rau qhov ze ntau tshaj plaws ntawm 2, nkag mus rau ROUND (11; 2). Cov zis yog tus naj npawb 12.
Qhov Txuj Ci OTBR, CHETN thiab TAWM siv cov nram qab no: "Muaj nuj nqi npe (zauv)". Yuav kom muab tus naj npawb ntawm 17 mus rau qhov ze tshaj plaws, siv qhov ua CHETN (17). Peb tau txais tus xov tooj 18.
Qhov kev ua haujlwm nkag mus tau hauv ob qho tib si hauv xov tooj ntawm tes thiab hauv txoj kab, tom qab xaiv lub xov tooj ntawm tes uas nws yuav tsum tau nyob. Txhua qhov kev ua haujlwm yuav tsum yog ua ntej ntawm "=" kos npe.
Muaj ib txoj kev me ntsis sib txawv los ua kom paub ntau zog. Nws yog qhov tshwj xeeb tshaj yog thaum muaj ib lub rooj nrog qhov tseem ceeb uas yuav tsum tau hloov dua siab tshiab rau hauv cov xov tooj sib npaug ntawm sab nraud.
Ua li no, mus rau qhov "Cov qauv". Nias rau lub pob "Mathematical". Tom ntej no, nyob rau hauv daim ntawv uas qhib, xaiv qhov kev ua haujlwm, piv txwv li ROUND.
Tom qab ntawd, qhov kev ua lag luam qhib qhov rais qhib. Nyob rau ntawm "Field Number", koj tuaj yeem nkag mus rau tus naj npawb ntawm kev xuas tes, tab sis yog tias peb xav kom hloov cov ntaub ntawv ntawm tag nrho cov lus, ces nias rau lub pob mus rau sab xis ntawm cov ntaub ntawv nkag teb chaws.
Qhov kev sib cav sib cav yog qhov tsawg. Tam sim no koj yuav tsum nias ntawm lub xovtooj ntawm sab sab, ntawm cov ntaub ntawv uas peb yuav tau muab tso tawm. Tom qab tus nqi nkag mus rau hauv lub qhov rais, nyem rau ntawm lub pob mus rau sab xis ntawm tus nqi no.
Qhov kev ua lag luam muaj nuj nqi qhib dua ntxiv. Hauv "Cov nab npawb ntawm cov ntawv" peb sau qhov tob qhov tob uas peb xav tau kom txo cov zauv. Tom qab ntawd, nyem rau ntawm "OK" khawm.
Raws li koj pom, tus xov tooj yog sib npaug. Txhawm rau tag nrho lwm cov ntaub ntawv ntawm cov kab ntawv kom zoo tib yam, peb tsiv mus rau tus cursor mus rau sab cai ces kaum ntawm lub xovtooj nrog tus nqi sib npaug, nias ntawm sab laug nas khawm, thiab rub nws mus rau qhov kawg ntawm lub rooj.
Tom qab ntawd, txhua qhov tseem ceeb hauv kem seem yuav tsum sib npaug.
Raws li koj pom, muaj ob txoj hauv kev los hloov cov duab pom ntawm tus nab npawb: siv lub pob ntawm daim kab xev, thiab hloov cov tsis zoo ntawm hom xov tooj ntawm tes. Tsis tas li ntawd, koj tuaj yeem hloov lub rounding ntawm cov ntaub ntawv uas tau ua tiav. Qhov no kuj tuaj yeem ua tiav raws li ob txoj hauv kev: los hloov qhov chaw ntawm phau ntawv tag nrho, los yog los ntawm kev siv cov haujlwm tshwj xeeb. Kev xaiv ntawm ib txoj kev yog nyob ntawm seb koj puas yuav siv qhov sib npaug ntawm no rau tag nrho cov ntaub ntawv hauv cov ntaub ntawv, los yog tsuas yog rau ntau yam ntawm cov hlwb.
