The same dictionary as the flat translation table,
arranged by the category Microsoft uses in the Function Wizard. Use this page when you
know what you want to do but cannot remember the function name in your target
locale.
Logical
Conditional and boolean operators. Note that TRUE and FALSE are also localized — German WAHR/FALSCH — and the translator handles them on the same axis as function names.
English
German
French
Spanish
IF
WENN
SI
SI
IFS
WENNS
SI.CONDITIONS
SI.CONJUNTO
IFERROR
WENNFEHLER
SIERREUR
SI.ERROR
IFNA
WENNNV
SI.NON.DISP
SI.ND
AND
UND
ET
Y
OR
ODER
OU
O
NOT
NICHT
NON
NO
XOR
XODER
OUX
XO
TRUE
WAHR
VRAI
VERDADERO
FALSE
FALSCH
FAUX
FALSO
Lookup & Reference
The category that produces the most cross-locale failures. VLOOKUP/SVERWEIS/RECHERCHEV/BUSCARV are four entirely different strings for the same parser node.
English
German
French
Spanish
VLOOKUP
SVERWEIS
RECHERCHEV
BUSCARV
HLOOKUP
WVERWEIS
RECHERCHEH
BUSCARH
XLOOKUP
XVERWEIS
RECHERCHEX
BUSCARX
LOOKUP
VERWEIS
RECHERCHE
BUSCAR
INDEX
INDEX
INDEX
INDICE
MATCH
VERGLEICH
EQUIV
COINCIDIR
XMATCH
XVERGLEICH
EQUIVX
COINCIDIRX
OFFSET
BEREICH.VERSCHIEBEN
DECALER
DESREF
INDIRECT
INDIREKT
INDIRECT
INDIRECTO
CHOOSE
WAHL
CHOISIR
ELEGIR
ROW
ZEILE
LIGNE
FILA
ROWS
ZEILEN
LIGNES
FILAS
COLUMN
SPALTE
COLONNE
COLUMNA
COLUMNS
SPALTEN
COLONNES
COLUMNAS
Math & Trigonometry
English
German
French
Spanish
SUM
SUMME
SOMME
SUMA
SUMIF
SUMMEWENN
SOMME.SI
SUMAR.SI
SUMIFS
SUMMEWENNS
SOMME.SI.ENS
SUMAR.SI.CONJUNTO
SUMPRODUCT
SUMMENPRODUKT
SOMMEPROD
SUMAPRODUCTO
ROUND
RUNDEN
ARRONDI
REDONDEAR
ROUNDUP
AUFRUNDEN
ARRONDI.SUP
REDONDEAR.MAS
ROUNDDOWN
ABRUNDEN
ARRONDI.INF
REDONDEAR.MENOS
INT
GANZZAHL
ENT
ENTERO
MOD
REST
MOD
RESIDUO
ABS
ABS
ABS
ABS
POWER
POTENZ
PUISSANCE
POTENCIA
SQRT
WURZEL
RACINE
RAIZ
Statistical
English
German
French
Spanish
AVERAGE
MITTELWERT
MOYENNE
PROMEDIO
AVERAGEIF
MITTELWERTWENN
MOYENNE.SI
PROMEDIO.SI
AVERAGEIFS
MITTELWERTWENNS
MOYENNE.SI.ENS
PROMEDIO.SI.CONJUNTO
COUNT
ANZAHL
NB
CONTAR
COUNTA
ANZAHL2
NBVAL
CONTARA
COUNTBLANK
ANZAHLLEEREZELLEN
NB.VIDE
CONTAR.BLANCO
COUNTIF
ZÄHLENWENN
NB.SI
CONTAR.SI
COUNTIFS
ZÄHLENWENNS
NB.SI.ENS
CONTAR.SI.CONJUNTO
MAX
MAX
MAX
MAX
MAXIFS
MAXWENNS
MAX.SI.ENS
MAX.SI.CONJUNTO
MIN
MIN
MIN
MIN
MINIFS
MINWENNS
MIN.SI.ENS
MIN.SI.CONJUNTO
MEDIAN
MEDIAN
MEDIANE
MEDIANA
MODE
MODALWERT
MODE
MODA
STDEV
STABW
ECARTYPE
DESVEST
VAR
VARIANZ
VAR
VAR
Text
English
German
French
Spanish
LEFT
LINKS
GAUCHE
IZQUIERDA
RIGHT
RECHTS
DROITE
DERECHA
MID
TEIL
STXT
EXTRAE
LEN
LÄNGE
NBCAR
LARGO
TRIM
GLÄTTEN
SUPPRESPACE
ESPACIOS
UPPER
GROSS
MAJUSCULE
MAYUSC
LOWER
KLEIN
MINUSCULE
MINUSC
PROPER
GROSS2
NOMPROPRE
NOMPROPIO
CONCATENATE
VERKETTEN
CONCATENER
CONCATENAR
CONCAT
TEXTKETTE
CONCAT
CONCAT
TEXTJOIN
TEXTVERKETTEN
JOINDRE.TEXTE
UNIRCADENAS
SUBSTITUTE
WECHSELN
SUBSTITUE
SUSTITUIR
REPLACE
ERSETZEN
REMPLACER
REEMPLAZAR
FIND
FINDEN
TROUVE
ENCONTRAR
SEARCH
SUCHEN
CHERCHE
HALLAR
TEXT
TEXT
TEXTE
TEXTO
VALUE
WERT
CNUM
VALOR
Date & Time
If you're doing date arithmetic across locales, also see the Date Errors reference.
English
German
French
Spanish
TODAY
HEUTE
AUJOURDHUI
HOY
NOW
JETZT
MAINTENANT
AHORA
DATE
DATUM
DATE
FECHA
YEAR
JAHR
ANNEE
AÑO
MONTH
MONAT
MOIS
MES
DAY
TAG
JOUR
DIA
WEEKDAY
WOCHENTAG
JOURSEM
DIASEM
EOMONTH
MONATSENDE
FIN.MOIS
FIN.MES
EDATE
EDATUM
MOIS.DECALER
FECHA.MES
NETWORKDAYS
NETTOARBEITSTAGE
NB.JOURS.OUVRES
DIAS.LAB
WORKDAY
ARBEITSTAG
SERIE.JOUR.OUVRE
DIA.LAB
Financial
The German names are notably terse: NBW, IKV, RMZ — three letters where English uses three.
English
German
French
Spanish
NPV
NBW
VAN
VNA
IRR
IKV
TRI
TIR
PMT
RMZ
VPM
PAGO
PV
BW
VA
VA
FV
ZW
VC
VF
RATE
ZINS
TAUX
TASA
NPER
ZZR
NPM
NPER
Information
English
German
French
Spanish
ISBLANK
ISTLEER
ESTVIDE
ESBLANCO
ISNUMBER
ISTZAHL
ESTNUM
ESNUMERO
ISTEXT
ISTTEXT
ESTTEXTE
ESTEXTO
ISERROR
ISTFEHLER
ESTERREUR
ESERROR
ISNA
ISTNV
ESTNA
ESNOD
Dynamic Array (Microsoft 365)
The dynamic-array family is younger than most localization listings online; verify any third-party reference against your installed channel.