Koj tuaj yeem xam tus lej ntawm lub hlis uas haum nruab nrab ntawm ob hnub uas tsis tsim siv siv cov Microsoft Excel qhov ntawv nthuav qhia. Txhawm rau ua qhov no, nws muaj qhov tsim nyog ntawm kev ua haujlwm rau hloov cov hnub rau cov nqi ntau.
Nws yog qhov tsim nyog
Microsoft Excel cov ntawv teev kev hloov kho
Cov Lus Qhia
Kauj ruam 1
Nkag mus rau hauv thawj lub cell (A1) hnub pib ntawm lub sijhawm, lub sijhawm ntawm lub hlis koj xav suav, thiab nias Enter. Hnub tim yuav tsum tau hais kom meej nyob rau hauv hom ntawv uas tuaj yeem nkag siab los ntawm cov ntawv sau hloov tsheb. Yog hais tias qhov kev teeb tsa tshwm sim tsis tau hloov pauv hauv nws cov chaw, tom qab ntawd, piv txwv, hnub Lub Xya Hli 11, 2011, sau hauv daim ntawv ntawm 11.07.2011, yuav nkag siab los ntawm tus editor kom raug.
Kauj ruam 2
Sau hnub kawg rau lub sij hawm xam hauv lub xov tooj ntawm tes tom ntej (A2) thiab nyem Enter.
Kauj ruam 3
Nkag mus rau tom hauv ntej ntawm tes (A3) muaj cov paib sib txig sib luag, thiab tom qab nws ua cov qauv hauv qab no: (XYOO (A2) -YOO (A1)) * 12 + HLI (A2) - HLI (A1) Qhov kos npe sib npaug yog txhais los ntawm cov ntawv kis kho ntawv qhia raws li kev qhia kom txiav txim siab txhua yam uas nws yog ua raws li ib tug qauv, tsis yog ntawv nyeem. Tom qab koj nias tus yuam sij Enter, qhov sib txawv nyob rau lub hlis ntawm qhov kawg thiab hnub pib yuav raug suav thiab tshwm rau hauv lub ntsej muag nrog tus qauv.
Kauj ruam 4
Yog tias qee yam tau suav tsis raug lossis sau cov ntawv sau #VALUE! Tshwm sim hauv lub xovtooj nrog cov qauv, ces nco ntsoov tias cov hnub nyob rau hauv hom ntawv raug. Tom qab ntawd xaiv ob lub hlwb hnub, txoj cai-nias thiab xaiv Hom Duab los ntawm cov ntawv qhia zaub mov.
Kauj ruam 5
Nyem rau kab "Hnub" nyob rau hauv daim ntawv ntawm sab laug ("Naj npawb Qhia Tawm") thiab xaiv hom ntawv uas phim cov hom ntawv uas koj siv thaum sau hnub tim. Cog lus rau qhov hloov pauv mus rau hom ntawv ntawm ob lub hlwb los ntawm nias OK.
Kauj Ruam 6
Qhib dua qhib kev sib tham rau kev hloov hom ntawv ntawm cov hlwb, tab sis tam sim no rau lub xov tooj ntawm tes uas muaj tus qauv - right-click nws thiab xaiv "Format Cells".
Kauj Ruam 7
Nyem Kab General nyob rau hauv Daim Ntawv Npav Cov Naj Npawb Sau thiab ua txhaum qhov hloov los ntawm nias OK. Tom qab cov hom ntawv raug mus raws li cov ntaub ntawv hom nyob rau hauv lub hlwb, hnub sib txawv hauv lub hlis yuav tsum tau muab tso tawm kom raug.
Kauj ruam 8
Hauv txoj kev piav qhia, qhov sib txawv hauv ib hlis yog suav nrog kev suav mus ncig - txhua lub hli tsis tiav, tsis hais hnub twg, xam tau tias yog ua tiav. Ntawd yog, kab ke ntawm cov hnub hauv lub hlis ntawm hnub pib thiab hnub xaus tsis raug suav nrog. Koj tuaj yeem ntxiv cov mis thiab suav cov hli suav mus rau tus naj npawb ze tshaj plaws ntawm txhua lub hlis (ob qho tib si nce thiab nqis). Txhawm rau ua qhov no, sau ib daim ntawv muaj vaj huam sib luag hauv plaub ntawm plaub, thiab tom qab nws cov qauv hauv qab no: YOG HAIS TIAS (HNUB (A2)> = HNUB (A1); 0; -1) + (XYOO (A2) -YIAM (A1)) * 12 + HLI (A2) - HLI (A1)
