ID c?a bi: 2551525 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

Tm t?t

nng cao chinh xac, chc nng ng nht cua ham ap ng c ky vong va tn cac ham m ta chc nng chinh xac hn, mt s ham Excel a c cp nht, i tn hoc thm vaoth vin ham trong Microsoft Excel 2010, Microsoft Excel Services 2010 va Microsoft Excel Online 2010.

Ngoai ra, mt s ham nhp thng xuyn se c ban ia hoa lai theo 10 ngn ng khac nhau (Ting Sec, ting an Mach, ting Ha Lan, ting Y, ting Na Uy, ting B ao Nha, ting B ao Nha Brazil, ting Ty Ban Nha, ting Thuy in va ting Th Nhi Ky). iu nay dn n li #NAME? khi nhp tn ham tng t trong Microsoft Excel 2007 thay vi tn ham a cp nht trong Excel 2010. Khi ban m s lam vic trong Excel 2010, Excel Services 2010 hoc trong Excel Online cha tn ham t cac phin ban Excel trc, tn ham a cp nht se xut hin.

Do phan hi cua khach hang, Microsoft a quyt inh a cac ham c nhp thng xuyn nay tr lai tn a ban ia hoa cua Excel 2007. a tn ham tr lai tn nm 2007, hay tai Microsoft Office 2010 Goi Dich vu 1.

Vi du

Ham VLOOKUP c t tn theo ting Ty Ban Nha la BUSCARV trong Excel 2007. Tuy nhin, trong Excel 2010, tn ting Ty Ban Nha c i thanh CONSULTAV. Nu ban nhp BUSCARV thay vi CONSULTAV trong Excel 2010 trc SP1, ban se gp phai li #NAME?.

tai tao hanh vi nay, hay lam theo cac bc sau trong phin ban Excel 2010 ting Ty Ban Nha:
  1. Tao s lam vic Excel mi.
  2. Trong A1, nhp 1 ri trong A2, nhp 2.
  3. Trong B1, nhp a ri trong B2, nhp b.
  4. Trong D1, nhp 1 ri trong D2, nhp =BUSCARV(D1,A1:B2,2).
Nu ban cha cai t Goi Dich vu 1, ban se gp phai li #NOMBRE?khi nhp =BUSCARV(D1,A1:B2,2) trong Excel 2010. Ham ung nhp vao phin ban Excel 2010 trc SP1 la =CONSULTAV(D1,A1:B2,2).

Tuy nhin, khi a cai t Goi Dich vu 1, ban se gp phai li #NOMBRE?nu nhp =CONSULTAV(D1,A1:B2,2) trong Excel 2010. Ham ung nhp vao phin ban Excel 2010 sau SP1 la =BUSCARV(D1,A1:B2,2).




Thng tin thm

Sau khi cai t Goi Dich vu 1, tt ca cac s lam vic a tao trong phin ban Excel trc o, bao gm s lam vic Excel 2010 trc SP1 se t ng hin thi tn ham cp nht. Ban khng phai nhp lai cac ham xem tn cp nht.

tai xung va cai t Office 2010 SP1, hay truy cp bai vit sau trong C s Kin thc Microsoft:

2460049 - M ta Office 2010 SP1


i vi khach hang la doanh nghip, hay truy cp bt ky hoc tt ca cac bai vit sau trong C s Kin thc Microsoft tuy theo mi trng cua ban:

2460043 - M ta Office 2010 Goi Ngn ng SP1
2460073 - M ta Office Online SP1
2460056 - M ta Office Servers 2010 Goi Ngn ng SP1
2460044 - M ta v Goi Giao din Ngn ng Office 2010 SP1
2460045 - M ta SharePoint Server 2010 SP1
2460047 - M ta SharePoint va Project Server 2010 SP1

Bang Ham va Ngn ng

Phn sau y cung cp ngn ng va ham c Goi Dich vu 1 cp nht.

Ting Sec
Bang sau lit k cac ham trang tinh bng ting Sec a c thay i trong Goi Dich vu 1:

Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
IFERRORCHYBHODNIFERROR
LEFTVLEVOZLEVA
NOTNENNE
RIGHTVPRAVOZPRAVA
TEXTTEXTHODNOTA.NA.TEXT


Ting an Mach
Bang sau lit k cac ham trang tinh bng ting an Mach a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
AVERAGEGENNEMSNITMIDDEL
AVERAGEIFGENNEMSNIT.HVISMIDDEL.HVIS
AVERAGEIFSGENNEMSNIT.HVISSMIDDEL.HVISER
COUNTIFSTL.HVISSTL.HVISER
CUBEKPIMEMBERKUBEKPIMEDLEMKUBE.KPI.MEDLEM
CUBEMEMBERPROPERTYKUBEMEDLEMSEGENSKABKUBEMEDLEM.EGENSKAB
CUBERANKEDMEMBERKUBERANGERETMEDLEMKUBERANGERET.MEDLEM
CUBESETKUBE.ANGIVKUBEST
CUBESETCOUNTKUBE.ANGIV.ANTALKUBEST.ANTAL
DAVERAGEDGENNEMSNITDMIDDEL
DOLLARVALUTAKR
FLOORGULVAFRUND.GULV
GCDFLLES.DIVISORSTRSTE.FLLES.DIVISOR
HYPERLINKLINKHYPERLINK
IFERRORHVISFEJLHVIS.FEJL
INTHELHELTAL
ISERRER.FEER.FJL
LOOKUPOPSLAGSL.OP
MODETILSTANDHYPPIGST
NNTAL
OCT2DECOCT.TIL.DECOKT.TIL.DEC
RECEIVEDMODTAGETMODTAGET.VED.UDLB
RIGHTBHJRE_BHJREB
SUMIFSSUM.HVISSSUM.HVISER

Bang sau lit k cac ham t Vi lnh bng ting an Mach a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
RESET.TOOLBARNULSTIL.VRKTJSLINJEGENDAN.VRKTJSLINJE
TEXT.BOXTEKSTFELTTEKSTBOKS

Ting Ha Lan
Bang sau lit k cac ham trang tinh bng ting Ha Lan a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
CHOOSEKIESKIEZEN
CLEANSCHOONWISSEN.CONTROL
DAVERAGEDGEMIDDELDEDBGEMIDDELDE
DAYS360D360DAGEN360
DCOUNTDAANTALDBAANTAL
DGETDHAALDBLEZEN
DOLLARVALUTAEURO
DSTDEVDSTDEVDBSTDEV
DSUMDSOMDBSOM
FINDVINDEN.ALLESVIND.ALLES
LOOKUPOPZOEKENZOEKEN
LOWERKLEINELETTKLEINE.LETTERS
MIDMIDDENDEEL
NPVHNWNHW
PMTAFLOSSINGBET
PROPERBEGINKAPBEGINLETTERS
REPLACEVERVANGVERVANGEN
ROUNDAFRONDINGAFRONDEN
SLNRAALIN.AFSCHR
SQRTVWORTELWORTEL
UPPERHOOFDLETTHOOFDLETTERS
VALUEGETALWAARDE
VDBVAPVDB

Bang sau lit k cac ham t Vi lnh bng ting Ha Lan a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
BREAKEINDEONDERBREKEN
FORVOORVAN
GOTOGANAARGA.NAAR
GROUPGROEPGROEPEREN
NOTEOPMERKINGNOTITIE
RESTARTOPNIEUWOPNIEUW.STARTEN

Ting Y
Bang sau lit k cac ham trang tinh bng ting Y a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
FINDRICERTROVA
MINUTEMINUTIMINUTO
SECONDSECONDISECONDO


Ting Na Uy
Bang sau lit k cac ham trang tinh bng ting Na Uy a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
CHARTEGNTEGNKODE
CLEANRYDDRENSK
IPMTRANNUITETRAVDRAG
ISPMTER.ANNUITETER.AVDRAG
MAXMAKSSTRST
PMTANNUITETAVDRAG

Bang sau lit k cac ham t Vi lnh bng ting Na Uy a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
NEXTNEXTNESTE

Ting B ao Nha
Bang sau lit k cac ham trang tinh bng ting B ao Nha a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
FIXEDFIXOFIXA
NANDN?O.DISP
USDOLLARMOEDA2MOEDA.EUA

Ting B ao Nha - Brazil
Bang sau lit k cac ham trang tinh bng ting B ao Nha - Brazil a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
COLUMNCOLUNACOL
FACTFATOFATORIAL
FIXEDFIXODEF.NM.DEC
FREQUENCYFREQUNCIAFREQNCIA
MINMNMNIMO
PRODUCTPRODUTOMULT
RECEIVEDRECEBIDORECEBER
SEARCHPESQUISARLOCALIZAR
SERIESSUMSOMASRIESOMASEQNCIA
STDEVDESVPAD.NDESVPAD
TRUNCTRUNCTRUNCAR
VARVARESTVAR

Bang sau lit k cac ham t Vi lnh bng ting B ao Nha - Brazil a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
DATE.STRINGCADEIA.DATADATA.SRIE
ENABLE.COMMANDHABILITAR.COMANDOATIVAR.COMANDO
ENABLE.TOOLHABILITAR.FERRAMENTAATIVAR.FERRAMENTA
EXECUTEEXECUTAREXECUTE
FCLOSEARQ.FECHARARQN.FECHAR
GET.WORKSPACEINFO.ESPAO.TRABALHOINFO.REA.TRABALHO
LINKSLINKSVNCULOS
NUMBER.STRINGCADEIA.NMEROSEQNCIA.NMERO
REGISTERREGISTRARREGISTRO
RESUMECONINTUARREINIC

Ting Ty Ba Nha
Bang sau lit k cac ham trang tinh bng ting Ty Ban Nha a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
CHARCARCARACTER
CONVERTCONVERTCONVERTIR
DATEVALUEVALFECHAFECHANUMERO
DAYS360DAS360DIAS360
DCOUNTBDCUENTABDCONTAR
HLOOKUPCONSULTAHBUSCARH
IFERRORSIERRORSI.ERROR
MIDMEDEXTRAE
MODRESTORESIDUO
MODEMODOMODA
NANDNOD
SQRTRCUADRAIZ
TBILLEQLETRA.DE.TES.EQV.A.BONOLETRA.DE.TEST.EQV.A.BONO
TIMETIEMPONSHORA
TIMEVALUEVALHORAHORANUMERO
TRIMRECORTARESPACIOS
VLOOKUPCONSULTAVBUSCARV

Bang sau lit k cac ham t Vi lnh bng ting Ty Ban Nha a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
GOTOIRIR.A
NEXTSIGUIENTESALIR.BUCLE
RETURNDEVOLVERVOLVER

Ting Thuy in
Bang sau lit k cac ham trang tinh bng ting Thuy in a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
CLEANRENSASTDA
DAYS360D360DAGAR360
DDBDFAVDEGAVSKR
FALSEFALSKFALSKT
HLOOKUPHTSKLETAKOLUMN
HOURTIMTIMME
ISNARETRSAKNAD
ISNUMBERRNUMRTAL
ISTHAIDIGIT?RTHAISIFFRAISTHAIDIGIT
LEFTVNSTERPILVNSTER
LOWERSMGEMENER
MIDMITTEXTEXT
MODELGETYPVRDE
NIN
NAETSAKNAS
NPVNVLFNETNUVRDE
PMTAVBETBETALNING
PVNVNUVRDE
RATEPRSRNTA
RIGHTHGERPILHGER
SLNLNALINAVSKR
SYDATPRSAVSKR
TRIMSTDARENSA
TRUESANNSANT
UPPERSTORAVERSALER
VLOOKUPVTSKLETARAD

Ting Th Nhi Ky
Bang sau lit k cac ham trang tinh bng ting Th Nhi Ky a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
SUMTOPLAMTOPLA

Bang sau lit k cac ham t Vi lnh bng ting Th Nhi Ky a c thay i trong Goi Dich vu 1:
Thu g?n b?ng nyBung r?ng b?ng ny
Ham ting Anh nm 2010Excel 2010Excel 2010 SP1
GET.MOVIEAL.FILMGET.MOVIE
MOVIE.COMMANDFILM.KOMUTMOVIE.COMMAND






Chu y y la mt bai vit "XUT BAN NHANH" c tao trc tip t trong trung tm h tr cua Microsoft. Thng tin co trong tai liu nay c cung cp nhm tra li cac vn mi xut hin. Do vic cung cp nhanh chong, tai liu co th co li in n va co th c sa i bt ky luc nao ma khng cn thng bao. Hay xem iu khoan S dung xem xet thm.

Thu?c tnh

ID c?a bi: 2551525 - L?n xem xt sau cng: 17 Thang T 2014 - Xem xt l?i: 2.1
p d?ng
  • Microsoft Excel 2010
T? kha:
KB2551525

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com