Excel's CEILING muaj nuj nqi tuaj yeem tshem tawm qhov tsis xav tau cov lej lej lossis cov lej tsis tseem ceeb hauv cov ntaub ntawv los ntawm kev sib sau cov lej mus rau tus nqi tseem ceeb tshaj plaws. Kev siv tswv yim rau CEILING muaj nuj nqi yog txhawm rau txheeb cov nqi mus rau qhov ze tshaj plaws dime kom tsis txhob cuam tshuam nrog pennies thiab npib tsib xee.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, 2016, 2013, thiab 2010.
Hloov cov ntaub ntawv nrog CEILING Function
Zoo li lwm yam kev hloov pauv, lub luag haujlwm CEILING hloov cov ntaub ntawv hauv koj daim ntawv ua haujlwm thiab, yog li ntawd, cuam tshuam cov txiaj ntsig ntawm kev suav uas siv cov nqi sib npaug.
Raws li lwm txoj hauv kev, Excel muaj cov kev xaiv xaiv uas tso cai rau koj hloov tus lej lej ntawm qhov chaw tso tawm los ntawm koj cov ntaub ntawv yam tsis hloov cov lej lawv tus kheej. Kev hloov pauv formatting rau cov ntaub ntawv tsis cuam tshuam rau kev suav.
Txhawm rau hloov tus lej tsis tau qhia meej txog qhov kev sib tw, siv ROUNDUP muaj nuj nqi.
Excel CEILING Function
A muaj nuj nqi syntax yog hais txog lub luag haujlwm layout thiab suav nrog nws lub npe, brackets, thiab kev sib cav.
Cov lus qhia rau CEILING muaj nuj nqi yog:
=CEILING (Number, Qhov tseem ceeb)
Number - Tus nqi rau puag ncig. Qhov kev sib cav no tuaj yeem muaj cov ntaub ntawv tiag tiag rau kev sib tw, lossis nws tuaj yeem yog lub xov tooj siv rau qhov chaw ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm.
Significance -Tus lej lej ntawm qhov chaw nyob hauv qhov kev sib cav qhia tias muaj pes tsawg tus lej lossis tus lej tseem ceeb tam sim no hauv qhov tshwm sim (kab 2 thiab 3 ntawm qhov piv txwv).
- Qhov muaj nuj nqi hloov pauv tus lej sib cav hais txog qhov ze tshaj plaws ntawm ntau tus nqi no.
- Yog siv tus lej, tag nrho cov lej lej raug tshem tawm, thiab cov txiaj ntsig tau muab sib npaug mus rau qhov ze tshaj plaws ntawm tus nqi no (saib kab 4 ntawm qhov piv txwv).
- Rau qhov tsis zoo tus lej sib cav thiab cov lus sib cav qhov tseem ceeb, cov txiaj ntsig tau muab sib npaug mus rau xoom (saib kab 5 thiab 6 ntawm qhov piv txwv).
- Rau qhov tsis zoo tus lej sib cav thiab qhov tsis zoo qhov tseem ceeb sib cav, cov txiaj ntsig tau muab sib npaug qis qis ntawm xoom (saib kab 7 ntawm qhov piv txwv).
CEILING Function Piv txwv
Koj tuaj yeem nkag mus rau CEILING muaj nuj nqi los ntawm kev ntaus lub npe ua haujlwm thiab cov lus sib cav rau hauv lub xovtooj uas xav tau, lossis siv lub luag haujlwm lub dialog box raws li tau teev tseg.
- Xaiv xovtooj C2 ua kom nws lub xovtooj ua haujlwm uas cov txiaj ntsig CEILING yuav tso tawm.
-
Select the Formulas tab.
Image -
Choose Math & Trig hauv pawg tsev qiv ntawv Function.
Image - Xaiv CEILING hauv daim ntawv los nqa lub luag haujlwm lub dialog box.
- Nyob hauv lub dialog box, xaiv tus Number kab.
-
Xaiv xovtooj A2 hauv daim ntawv ua haujlwm kom nkag mus rau qhov kev siv ntawm tes rau hauv lub thawv sib tham.
Image - Nyob rau hauv lub dialog box, xaiv tus Significance kab.
-
Type in 0.1.
Image - Xaiv OK kom ua tiav txoj haujlwm thiab kaw lub thawv sib tham. Cov lus teb 34.3 yuav tsum tshwm sim hauv cell C2.
Thaum koj nyem rau ntawm tes E1,qhov ua tiav=CEILING (A2, 0.1) tshwm hauv cov qauv bar saum daim ntawv ua haujlwm.
Yuav ua li cas Excel tuaj txog ntawm cov lus teb no yog:
- Ua ntej, nws tshem tawm ib tus lej tsis tseem ceeb (2) ntawm tus lej kawg. Ib qhov chaw decimal nyob rau hauv qhov kev sib cav tseem ceeb txhais tau tias tsuas yog ib qho zauv ntawm qhov tshwm sim.
- Tom ntej no, nws hloov tus lej seem ntawm tus lej mus txog 34.3 vim qhov no yog qhov ntau tshaj tom ntej ntawm 0.10 tom qab 34.2.
Cell C3 to C7 Results
Thaum koj rov ua cov kauj ruam saum toj no rau cov hlwb C3 rau C7, koj tau txais cov txiaj ntsig hauv qab no:
- Cell C3 muaj tus nqi 34.25 vim tias ob qhov chaw lej hauv qhov kev sib cav tseem ceeb xav tau ob qhov lej lej hauv qhov tshwm sim, thiab 34.25 yog qhov ntau tshaj tom ntej ntawm 0.05 tom qab 34.22.
- Cell C4 muaj tus nqi 35. Vim tias qhov kev sib cav tseem ceeb yog tus lej, tag nrho cov lej lej raug tshem tawm ntawm qhov tshwm sim, thiab 35 yog qhov ntau tshaj plaws ntawm 1 tom qab 34.
- Cell C5 muaj tus nqi -34.2 rau tib lub laj thawj muab rau cell C2.
- Cell C6 muaj tus nqi -34 rau tib yam vim li cas ntawm tes C4.
- Cell C7 muaj tus nqi -35. Kev sib txuas tus lej tsis zoo thiab tus lej tsis zoo rau qhov kev sib cav qhov tseem ceeb tshem tawm tag nrho cov lej lej thiab ntsuas qhov tshwm sim mus rau qhov ntau ntxiv ntawm 1 tom qab -34.
Excel rov qab NUM! yuam kev tus nqi rau lub CEILING muaj nuj nqi yog ib tug zoo Number sib cav nrog ib tug tsis zoo qhov tseem ceeb argument.
