Summary

To provide improved function accuracy, consistent functionality that meets expectation, and function names that more accurately describe their functionality, several Excel functions were updated, renamed, or added to the function library in Microsoft Excel 2010, Microsoft Excel Services 2010 and Microsoft Excel Online 2010.

Additionally, some frequently entered functions were re-localized in 10 different languages (Czech, Danish, Dutch, Italian, Norwegian, Portuguese, Portuguese-Brazil, Spanish, Swedish, and Turkish). This results in a #NAME? error when the familiar Microsoft Excel 2007 function name is entered instead of the updated function name in Excel 2010. When you open a workbook in Excel 2010, Excel Services 2010 or in the Excel Online that contains function names from earlier versions of Excel, the updated function name appears.

Because of customer feedback, Microsoft has decided to return these frequently entered functions back to their Excel 2007 localized names. To return the function names to their 2007 names, download Microsoft Office 2010 Service Pack 1.

Example

The VLOOKUP function in Spanish is named BUSCARV under Excel 2007. However, in Excel 2010 the Spanish name was changed to CONSULTAV. If you enter BUSCARV instead of CONSULTAV in Excel 2010 pre-SP1 you would receive a #NAME? error.

To reproduce this behavior, follow these steps in the Spanish version of Excel 2010:

  1. Create a new Excel workbook.

  2. In cell A1, type 1, and then in cell A2, type 2.

  3. In cell B1, type a, and then in cell B2, type b.

  4. In cell D1, type 1, and then in cell D2, type =BUSCARV(D1,A1:B2,2).

If you have not installed Service Pack 1, you will receive the error #¿NOMBRE? when you enter =BUSCARV(D1,A1:B2,2) in Excel 2010. The correct function to enter in a pre-SP1 Excel 2010 version is =CONSULTAV(D1,A1:B2,2).

However, when you install Service Pack 1, you will receive the error #¿NOMBRE? if you enter =CONSULTAV(D1,A1:B2,2) in Excel 2010. The correct function to enter in a post-SP1 Excel 2010 version is =BUSCARV(D1,A1:B2,2).



More Information

After Service Pack 1 is installed, all workbooks that were created in earlier versions of Excel including pre-SP1 Excel 2010 workbooks automatically display the updated function names. The functions do not have to be re-entered in order to see the updated names.

To download and install Office 2010 SP1, visit the following Microsoft Knowledge Base article:

2460049 - Description of Office 2010 SP1

For enterprise customers, visit any or all of these Microsoft Knowledge Base articles depending on your environment:

2460043 - Description of Office 2010 Language Pack SP1
2460073 - Description of Office Online SP1
2460056 - Description of Office Servers 2010 Language Pack SP1
2460044 - Description of Office Language Interface Pack 2010 SP1
2460045 - Description of SharePoint Server 2010 SP1
2460047 - Description of SharePoint and Project Server 2010 SP1

Function and Language tables

The following section provides the languages and functions updated by Service Pack 1.

Czech
The following table lists the Czech worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

IFERROR

CHYBHODN

IFERROR

LEFT

VLEVO

ZLEVA

NOT

NENÍ

NE

RIGHT

VPRAVO

ZPRAVA

TEXT

TEXT

HODNOTA.NA.TEXT



Danish
The following table lists the Danish worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

AVERAGE

GENNEMSNIT

MIDDEL

AVERAGEIF

GENNEMSNIT.HVIS

MIDDEL.HVIS

AVERAGEIFS

GENNEMSNIT.HVISS

MIDDEL.HVISER

COUNTIFS

TÆL.HVISS

TÆL.HVISER

CUBEKPIMEMBER

KUBEKPIMEDLEM

KUBE.KPI.MEDLEM

CUBEMEMBERPROPERTY

KUBEMEDLEMSEGENSKAB

KUBEMEDLEM.EGENSKAB

CUBERANKEDMEMBER

KUBERANGERETMEDLEM

KUBERANGERET.MEDLEM

CUBESET

KUBE.ANGIV

KUBESÆT

CUBESETCOUNT

KUBE.ANGIV.ANTAL

KUBESÆT.ANTAL

DAVERAGE

DGENNEMSNIT

DMIDDEL

DOLLAR

VALUTA

KR

FLOOR

GULV

AFRUND.GULV

GCD

FÆLLES.DIVISOR

STØRSTE.FÆLLES.DIVISOR

HYPERLINK

LINK

HYPERLINK

IFERROR

HVISFEJL

HVIS.FEJL

INT

HEL

HELTAL

ISERR

ER.FE

ER.FJL

LOOKUP

OPSLAG

SLÅ.OP

MODE

TILSTAND

HYPPIGST

N

N

TAL

OCT2DEC

OCT.TIL.DEC

OKT.TIL.DEC

RECEIVED

MODTAGET

MODTAGET.VED.UDLØB

RIGHTB

HØJRE_B

HØJREB

SUMIFS

SUM.HVISS

SUM.HVISER


The following table lists the Danish Macro sheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

RESET.TOOLBAR

NULSTIL.VÆRKTØJSLINJE

GENDAN.VÆRKTØJSLINJE

TEXT.BOX

TEKSTFELT

TEKSTBOKS


Dutch
The following table lists the Dutch worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

CHOOSE

KIES

KIEZEN

CLEAN

SCHOON

WISSEN.CONTROL

DAVERAGE

DGEMIDDELDE

DBGEMIDDELDE

DAYS360

D360

DAGEN360

DCOUNT

DAANTAL

DBAANTAL

DGET

DHAAL

DBLEZEN

DOLLAR

VALUTA

EURO

DSTDEV

DSTDEV

DBSTDEV

DSUM

DSOM

DBSOM

FIND

VINDEN.ALLES

VIND.ALLES

LOOKUP

OPZOEKEN

ZOEKEN

LOWER

KLEINELETT

KLEINE.LETTERS

MID

MIDDEN

DEEL

NPV

HNW

NHW

PMT

AFLOSSING

BET

PROPER

BEGINKAP

BEGINLETTERS

REPLACE

VERVANG

VERVANGEN

ROUND

AFRONDING

AFRONDEN

SLN

RAA

LIN.AFSCHR

SQRT

VWORTEL

WORTEL

UPPER

HOOFDLETT

HOOFDLETTERS

VALUE

GETAL

WAARDE

VDB

VAP

VDB


The following table lists the Dutch Macro sheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

BREAK

EINDE

ONDERBREKEN

FOR

VOOR

VAN

GOTO

GANAAR

GA.NAAR

GROUP

GROEP

GROEPEREN

NOTE

OPMERKING

NOTITIE

RESTART

OPNIEUW

OPNIEUW.STARTEN


Italian
The following table lists the Italian worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

FIND

RICER

TROVA

MINUTE

MINUTI

MINUTO

SECOND

SECONDI

SECONDO



Norwegian
The following table lists the Norwegian worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

CHAR

TEGN

TEGNKODE

CLEAN

RYDD

RENSK

IPMT

RANNUITET

RAVDRAG

ISPMT

ER.ANNUITET

ER.AVDRAG

MAX

MAKS

STØRST

PMT

ANNUITET

AVDRAG


The following table lists the Norwegian Macro sheet functions that where changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

NEXT

NEXT

NESTE


Portuguese
The following table lists the Portuguese worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

FIXED

FIXO

FIXA

NA

ND

NÃO.DISP

USDOLLAR

MOEDA2

MOEDA.EUA


Portuguese - Brazil
The following table lists the Portuguese - Brazil worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

COLUMN

COLUNA

COL

FACT

FATO

FATORIAL

FIXED

FIXO

DEF.NÚM.DEC

FREQUENCY

FREQUÊNCIA

FREQÜÊNCIA

MIN

MÍN

MÍNIMO

PRODUCT

PRODUTO

MULT

RECEIVED

RECEBIDO

RECEBER

SEARCH

PESQUISAR

LOCALIZAR

SERIESSUM

SOMASÉRIE

SOMASEQÜÊNCIA

STDEV

DESVPAD.N

DESVPAD

TRUNC

TRUNC

TRUNCAR

VAR

VAREST

VAR


The following table lists the Portuguese - Brazil Macro sheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

DATE.STRING

CADEIA.DATA

DATA.SÉRIE

ENABLE.COMMAND

HABILITAR.COMANDO

ATIVAR.COMANDO

ENABLE.TOOL

HABILITAR.FERRAMENTA

ATIVAR.FERRAMENTA

EXECUTE

EXECUTAR

EXECUTE

FCLOSE

ARQ.FECHAR

ARQN.FECHAR

GET.WORKSPACE

INFO.ESPAÇO.TRABALHO

INFO.ÁREA.TRABALHO

LINKS

LINKS

VÍNCULOS

NUMBER.STRING

CADEIA.NÚMERO

SEQÜÊNCIA.NÚMERO

REGISTER

REGISTRAR

REGISTRO

RESUME

CONINTUAR

REINIC


Spanish
The following table lists the Spanish worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

CHAR

CAR

CARACTER

CONVERT

CONVERT

CONVERTIR

DATEVALUE

VALFECHA

FECHANUMERO

DAYS360

DÍAS360

DIAS360

DCOUNT

BDCUENTA

BDCONTAR

HLOOKUP

CONSULTAH

BUSCARH

IFERROR

SIERROR

SI.ERROR

MID

MED

EXTRAE

MOD

RESTO

RESIDUO

MODE

MODO

MODA

NA

ND

NOD

SQRT

RCUAD

RAIZ

TBILLEQ

LETRA.DE.TES.EQV.A.BONO

LETRA.DE.TEST.EQV.A.BONO

TIME

TIEMPO

NSHORA

TIMEVALUE

VALHORA

HORANUMERO

TRIM

RECORTAR

ESPACIOS

VLOOKUP

CONSULTAV

BUSCARV


The following table lists the Spanish Macro sheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

GOTO

IR

IR.A

NEXT

SIGUIENTE

SALIR.BUCLE

RETURN

DEVOLVER

VOLVER


Swedish
The following table lists the Swedish worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

CLEAN

RENSA

STÄDA

DAYS360

D360

DAGAR360

DDB

DFAV

DEGAVSKR

FALSE

FALSK

FALSKT

HLOOKUP

HTSÖK

LETAKOLUMN

HOUR

TIM

TIMME

ISNA

ÄRET

ÄRSAKNAD

ISNUMBER

ÄRNUM

ÄRTAL

ISTHAIDIGIT

ŽRTHAISIFFRA

ISTHAIDIGIT

LEFT

VÄNSTERPIL

VÄNSTER

LOWER

SMÅ

GEMENER

MID

MITT

EXTEXT

MODE

LÄGE

TYPVÄRDE

N

I

N

NA

ET

SAKNAS

NPV

NVLF

NETNUVÄRDE

PMT

AVBET

BETALNING

PV

NV

NUVÄRDE

RATE

PRS

RÄNTA

RIGHT

HÖGERPIL

HÖGER

SLN

LNA

LINAVSKR

SYD

ÅATP

ÅRSAVSKR

TRIM

STÄDA

RENSA

TRUE

SANN

SANT

UPPER

STORA

VERSALER

VLOOKUP

VTSÖK

LETARAD


Turkish
The following table lists the Turkish worksheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

SUM

TOPLAM

TOPLA


The following table lists the Turkish Macro sheet functions that were changed in Service Pack 1:

English 2010 Function

Excel 2010

Excel 2010 SP1

GET.MOVIE

AL.FILM

GET.MOVIE

MOVIE.COMMAND

FILM.KOMUT

MOVIE.COMMAND







Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×