Ua ntau cov lus teb hauv Excel, cov neeg siv tsis tas ib txwm xav tias qhov tseem ceeb tshaj tawm hauv lub hlwb qee zaum tsis ua ke nrog cov neeg siv los ntawm qhov kev pab cuam rau cov lus teb. Qhov no yog qhov tseeb tshwj xeeb tshaj ntawm qhov muaj txiaj ntsim zoo. Piv txwv, yog tias koj tau teev cov numeric formatting, uas qhia cov zauv nrog ob zauv chaw, ces qhov no tsis txhais tau tias Excel kuj xam cov ntaub ntawv. Tsis yog, ua ntej ntawd, qhov kev pabcuam no suav txog 14 decimal chaw, txawm tias tsuas yog ob tug lej muaj nyob rau hauv lub xovtooj. Qhov tseeb no tej zaum kuj ua rau tsis zoo siab. Yuav kom daws tau qhov teeb meem no, koj yuav tsum teeb tsa qhov kev ntsuas qhov ntsuas raws li ntawm qhov kev tshuaj ntsuam.
Teem lub rounding raws li ntawm qhov screen
Tab sis ua ntej ua qhov kev hloov pauv, koj yuav tsum paub seb koj puas xav tau tig rau qhov tseeb ntawm qhov screen. Xwb, muaj qee zaum, thaum uas siv ntau tus zauv nrog cov zauv, muaj cov nyom zoo li hauv qhov kev xam, uas yuav txo tau tag nrho cov lus teb ntawm cov lus teb. Yog li no, tsis tas yuav tsum muaj qhov chaw no zoo dua tsis raug tsim txom.
Xws li qhov kev txiav txim ntawm qhov screen, koj xav tau nyob rau lub sijhawm ntawm daim phiaj tom ntej. Piv txwv, koj muaj hauj lwm ntxiv ob tus lej 4,41 thiab 4,34, tab sis nws yog qhov tseem ceeb uas tsuas yog ib qho zauv tom qab thaum lub comma tso tawm kom pom ntawm daim ntawv. Tom qab uas peb tau ua cov qauv ntawm lub hlwb, qhov tseem ceeb pib tshwm rau ntawm daim ntawv. 4,4 thiab 4,3, tab sis thaum ntxiv, qhov kev zov me nyuam tsis qhia tus naj npawb hauv xov tooj ntawm tes vim li ntawd 4,7thiab tus nqi 4,8.
Qhov no yog precisely vim lub fact tias rau tus muab xam Excel tiag tiag tseem coj cov zauv 4,41 thiab 4,34. Tom qab muab xam, qhov tshwm sim yog 4,75. Tab sis, txij li thaum peb muab cov formatting los tso saib cov zauv uas tsuas muaj ib qho chaw zauv, kwv yees ua tau thiab tus naj npawb tshwm nyob rau hauv lub xov tooj ntawm tes 4,8. Yog li, nws tsim cov tsos tias qhov kev zov me nyuam tau ua yuam kev (txawm tias qhov no tsis yog li ntawd). Tab sis nyob rau daim ntawv luam tawm xws li kev qhia 4,4+4,3=8,8 yuav yog qhov yuam kev. Yog li, qhov no, nws yog ib qho tseem ceeb heev kom tig qhov tseeb qhov chaw xws li ntawm qhov kev tshuaj ntsuam. Ces Excel yuav suav tsis tas nqa mus rau hauv tus account cov zauv uas qhov kev zov me nyuam ua cim xeeb, tab sis raws li cov nqi pom tshwm hauv xov tooj cua.
Yuav kom paub qhov tseeb ntawm tus naj npawb uas Excel siv los xam, koj yuav tsum xaiv lub xov tooj ntawm tes uas nws muaj. Tom qab ntawd, nws cov nqi yuav tshwm nyob rau ntawm daim qauv mis, uas yog cia hauv Excel nco.
Tshooj: Excel rounding cov zauv
Tig rau ntawm qhov chaw zoo li ntawm kev tshuaj ntsuam hauv niaj hnub versions of Excel
Tam sim no cia saib seb yuav ua li cas tig rau qhov tseeb ntawm qhov screen. Ua ntej, xav paub seb yuav ua li cas rau qhov piv txwv ntawm Microsoft Excel 2010 thiab nws tom qab versions. Lawv muaj qhov no tivthaiv nrog tib yam nkaus. Thiab ces peb yuav tsum paub txhawm rau ntawm qhov kev ntsuam xyuas hauv Excel 2007 thiab hauv Excel 2003.
- Txav mus rau tab "Cov Ntaub Ntawv".
- Nyob rau hauv lub qhov rais qhib, nias ntawm khawm "Kev xaiv".
- Ib qho ntxiv tsis tau qhov rais qhib. Tshem nws mus rau seem "Qib Siab"uas nws lub npe nyob rau hauv daim ntawv teev npe sab nraud ntawm lub qhov rais.
- Tom qab mus rau seem "Qib Siab" txav mus rau sab xis ntawm lub qhov rais, qhov chaw uas muaj ntau qhov chaw ntawm qhov kev zov me nyuam nyob. Nrhiav ib qho chaw ntawm chaw "Thaum hais txog phau ntawv no". Teem ib zuam nyob ze qhov parameter "Koj muab cov lus ntawm kev tshuaj ntsuam".
- Tom qab ntawd, ib lub vojvoog sib txuas, uas hais tias cov lus ntawm cov lus teb yuav raug txo kom tsawg. Peb nias lub khawm "OK".
Tom qab ntawd, hauv Excel 2010 thiab tom qab ntawd, hom yuav tsum tau ua. "on-screen tseeb".
Txhawm rau lov tes taw hom no, xyuas lub thawv hauv qhov kev xaiv qhov rai ze ntawm qhov chaw. "Koj muab cov lus ntawm kev tshuaj ntsuam"ces nias qhov khawm "OK" nyob hauv qab ntawm qhov rais.
Qhib cov ntaub ntawv ntawm qhov screen hauv Excel 2007 thiab Excel 2003
Tam sim no cia tus saib xyuas ceev npaum licas, zoo li ntawm qhov screen hauv Excel 2007 thiab hauv Excel 2003. Txawm hais tias cov qauv no tau muab kho dua, lawv siv ntau tus neeg siv.
Ua ntej tshaj, xav li cas kom pab hom nyob hauv Excel 2007.
- Nias rau ntawm Microsoft Office cim nyob rau sab qaum sab laug ntawm lub qhov rais. Hauv daim ntawv uas tshwm sim, xaiv qhov khoom "Kev Xaiv Excel".
- Hauv qhov rais qhib, xaiv qhov khoom "Qib Siab". Nyob rau sab xis ntawm lub qhov rais hauv pawg koom haum "Thaum hais txog phau ntawv no" teem ib lub zuam nyob ze qhov parameter "Koj muab cov lus ntawm kev tshuaj ntsuam".
Precision hom li qhov screen yuav tsum enabled.
Nyob hauv Excel 2003, cov txheej txheem rau kev txhawb zog rau hom peb yuav tsum txawv dua.
- Nyob rau hauv cov ntawv qhia kab rov tav, nyem qhov khoom "Kev pabcuam". Nyob rau hauv cov npe uas tau qhib, xaiv qhov chaw "Kev xaiv".
- Lub qhov ncauj tsis tau qhib. Nyob rau hauv nws, mus rau tab "Tshawb nrhiav". Tom ntej no, teem ib lub zuam ze ntawm qhov khoom "Qhov tseeb ntawm kev tshuaj ntsuam" thiab nyem rau ntawm lub pob "OK" nyob hauv qab ntawm qhov rais.
Raws li koj tau pom, nws yog qhov yooj yim los txhim kho qhov tseeb hom li ntawm qhov screen hauv Excel, tsis hais tus txheej txheem ntawm qhov kev pab cuam. Qhov loj tshaj plaws yog los txiav txim seb puas yuav tso tawm hom no hauv ib kis xwm txheej lossis tsis.
