Qhov tseeb raws li qhov screen hauv Excel: yuav ua li cas

Feem ntau, cov neeg siv uas ua kev suav hauv Excel tsis paub tias cov lej tso tawm hauv cov hlwb tsis tas li pom zoo nrog cov ntaub ntawv uas qhov kev zov me nyuam siv los ua kev suav. Nws yog hais txog tus nqi fractional. Qhov tseeb yog tias Excel qhov kev pab cuam khaws cia hauv cov lej cim xeeb uas muaj txog 15 tus lej tom qab tus lej lej. Thiab txawm tias qhov tseeb hais tias, tsuas yog 1, 2 lossis 3 tus lej yuav tshwm sim ntawm qhov screen (raws li qhov tshwm sim ntawm lub xov tooj ntawm tes teeb tsa), Excel yuav siv tag nrho cov lej ntawm lub cim xeeb rau kev suav. Qee lub sij hawm qhov no ua rau cov txiaj ntsig thiab cov txiaj ntsig tsis xav tau. Txhawm rau tiv thaiv qhov no los ntawm qhov tshwm sim, koj yuav tsum tau kho qhov tseeb qhov sib npaug, uas yog, teeb tsa rau tib yam li ntawm qhov screen.

Yuav ua li cas rounding ua haujlwm hauv Excel

Ua ntej ntawm tag nrho cov, koj yuav tsum coj mus rau hauv tus account lub fact tias nws yog zoo dua tsis txhob siv qhov teeb meem no tsis tsim nyog. Nws yog ib qho tsim nyog yuav tsum tau ua tib zoo xav thiab txiav txim siab rau koj tus kheej seb nws puas tsim nyog los teeb tsa qhov tseeb raws li ntawm qhov screen lossis tsis yog, txij li feem ntau thaum ua cov lej suav nrog ntau tus lej feem ntau, qhov hu ua cumulative effect tshwm sim, uas txo cov qhov tseeb ntawm kev suav ua.

Nws tsim nyog teeb tsa qhov tseeb raws li ntawm qhov screen hauv cov xwm txheej hauv qab no. Piv txwv li, cia peb hais tias peb xav ntxiv cov lej 6,42 thiab 6,33, tab sis peb tsuas xav tso ib qhov chaw kaum, tsis yog ob.

Ua li no, xaiv cov hlwb uas xav tau, right-click rau lawv, xaiv cov khoom "Format Cells.."

Nyob rau hauv "Number" tab, nyem rau ntawm "Numeric" hom ntawv nyob rau hauv daim ntawv ntawm sab laug, ces teem tus nqi mus rau "1" rau tus naj npawb ntawm decimal qhov chaw thiab nias OK kom tawm hauv formatting qhov rais thiab txuag cov chaw.

Tom qab ua tiav, phau ntawv yuav nthuav tawm qhov tseem ceeb 6,4 thiab 6,3. Thiab yog tias cov zauv feem ntau ntxiv, qhov kev zov me nyuam yuav muab cov lej 12,8.

Tej zaum nws yuav zoo li tias qhov kev zov me nyuam tsis ua haujlwm raug thiab ua yuam kev hauv kev suav, vim tias 6,4 + 6,3 = 12,7. Tab sis cia peb xav seb qhov no puas yog tiag tiag, thiab vim li cas qhov txiaj ntsig zoo li no tau tshwm sim.

Raws li peb tau hais los saum no, Excel siv cov lej qub rau kev suav, piv txwv li 6,42 thiab 6,33. Nyob rau hauv tus txheej txheem ntawm summing lawv, qhov tshwm sim yog 6,75. Tab sis vim yog lub fact tias ua ntej ib tug decimal qhov chaw tau teev nyob rau hauv lub formatting chaw, lub resulting cell yog sib npaug zos rau raws li, thiab qhov kawg tshwm sim yog tso tawm kom pom sib npaug rau 6,8.

Txhawm rau kom tsis txhob muaj qhov tsis meej pem, qhov kev daws teeb meem zoo tshaj plaws yog los teeb tsa qhov tseeb ntawm qhov ntsuas ntawm qhov screen.

Nco ntsoov: Txhawm rau kom paub txog tus nqi qub uas siv los ntawm qhov kev zov me nyuam rau kev suav, nyem rau ntawm lub xov tooj ntawm tes uas muaj tus lej lej, tom qab ntawd ua tib zoo saib rau lub formula bar, uas yuav tso saib tag nrho cov lej khaws cia hauv qhov program nco.

Yuav kho qhov tseeb li cas ntawm qhov screen

Ua ntej, cia peb xam seb yuav ua li cas lub rounding raug teeb tsa zoo li ntawm qhov screen hauv version Excel 2019.

1. Peb mus rau "Cov ntaub ntawv" zaub mov.
2. Nyem rau ntawm cov khoom "Settings" nyob rau hauv daim ntawv ntawm sab laug nyob rau hauv qab heev.
3. Ib lub qhov rais ntxiv nrog rau qhov kev zov me nyuam yuav qhib, nyob rau sab laug uas peb nyem rau ntawm "Advanced" ntu.
4. Tam sim no, nyob rau sab xis ntawm cov chaw, nrhiav ib qho thaiv hu ua "Thaum rov suav cov phau ntawv no:" thiab kos lub npov nyob ib sab ntawm "Tsim qhov tseeb" kev xaiv. Qhov kev zov me nyuam yuav ceeb toom peb tias qhov raug yuav raug txo nrog qhov teeb tsa no. Peb pom zoo rau qhov no los ntawm nias lub pob OK thiab tom qab ntawd OK dua kom paub meej tias cov kev hloov pauv thiab tawm ntawm lub qhov rais xaiv.

Nco ntsoov: Yog tias nws tsim nyog los lov tes taw hom no, mus rau tib qhov tsis muaj thiab tsuas yog tshem tawm qhov sib thooj checkbox.

Kho Rounding Precision nyob rau hauv lub versions ua ntej

Txawm hais tias qhov hloov tshiab tas li ntawm Excel qhov kev pab cuam, ntau yam ntawm cov haujlwm yooj yim thiab cov algorithm rau kev siv lawv hloov me ntsis los yog nyob twj ywm tib yam kom cov neeg siv, tom qab hloov mus rau ib tug tshiab version, tsis muaj teeb meem tau siv rau lub interface tshiab, thiab lwm yam.

Hauv peb cov ntaub ntawv, lub algorithm rau kev teeb tsa qhov raug raws li ntawm qhov screen hauv cov qauv ua ntej ntawm qhov kev zov me nyuam yuav luag zoo ib yam li qhov peb tau txiav txim siab saum toj no rau 2019 version.

Microsoft Excel 2010

1. Mus rau "Cov ntaub ntawv" zaub mov.
2. Nyem rau ntawm qhov khoom nrog lub npe "Settings".
3. Nyob rau hauv qhov chaw qhov rai uas qhib, nyem rau ntawm "Advanced" yam khoom.
4. Muab zuam rau pem hauv ntej ntawm qhov kev xaiv "Tsim qhov tseeb raws li ntawm qhov screen" hauv qhov chaw thaiv "Thaum rov xam phau ntawv no". Ib zaug ntxiv, peb paub meej tias qhov kev hloov kho tau los ntawm kev nyem rau ntawm lub pob OK, coj mus rau hauv tus account qhov tseeb ntawm kev suav yuav raug txo.

Microsoft Excel 2007 thiab 2003

Versions ntawm cov xyoo no, raws li ib co neeg siv, twb outdated. Lwm tus xav tias lawv yooj yim heev thiab txuas ntxiv ua haujlwm hauv lawv mus rau niaj hnub no, txawm tias qhov tshwm sim ntawm cov ntawv tshiab.

Cia peb pib nrog 2007 version.

1. Nyem rau ntawm "Microsoft Office" icon, uas nyob rau sab laug sab laug ntawm lub qhov rais. Ib daim ntawv teev npe yuav tsum tshwm sim uas koj yuav tsum xaiv ib ntu hu ua "Excel Options".
2. Lwm lub qhov rais yuav qhib uas koj xav tau cov khoom "Advanced". Tom ntej no, ntawm sab xis, xaiv "Thaum rov xam phau ntawv no" pawg ntawm kev teeb tsa thiab khij lub npov nyob ib sab ntawm "Teem qhov tseeb raws li ntawm qhov screen" ua haujlwm.

Nrog rau qhov ua ntej version (2013), tej yam txawv me ntsis.

1. Hauv cov ntawv qhia zaub mov saum toj kawg nkaus koj yuav tsum nrhiav ntu "Kev Pabcuam". Tom qab nws raug xaiv, ib daim ntawv teev npe yuav tshwm nyob rau hauv uas koj yuav tsum tau nyem rau ntawm "Options" yam khoom.
2. Nyob rau hauv lub qhov rais uas qhib nrog cov tsis, xaiv "Calculation" thiab ces khij lub npov nyob ib sab ntawm lub "Qhov tseeb li ntawm qhov screen" xaiv.

xaus

Kev teeb tsa qhov tseeb raws li qhov screen hauv Excel yog qhov muaj txiaj ntsig zoo, thiab hauv qee qhov xwm txheej, ib qho tseem ceeb uas tsis yog txhua tus neeg siv paub txog. Nws yuav tsis yooj yim rau kev teeb tsa tsim nyog nyob rau hauv ib qho ntawm cov versions ntawm qhov kev pab cuam, vim tias tsis muaj qhov sib txawv hauv qhov kev npaj ua, thiab qhov sib txawv tsuas yog hauv kev hloov kho interfaces, uas, txawm li cas los xij, kev txuas ntxiv yog khaws cia.