Verified starter mapping set

Function Translation Table

Search the cross-language function mappings currently supported by the translator.

91 mapped functions

English	French	German	Spanish	Use
SUM	SOMME	SUMME	SUMA	Adds numbers or ranges.
AVERAGE	MOYENNE	MITTELWERT	PROMEDIO	Returns the arithmetic mean.
COUNT	NB	ANZAHL	CONTAR	Counts cells containing numbers.
COUNTA	NBVAL	ANZAHL2	CONTARA	Counts non-empty cells.
COUNTIF	NB.SI	ZÄHLENWENN	CONTAR.SI	Counts cells matching one condition.
COUNTIFS	NB.SI.ENS	ZÄHLENWENNS	CONTAR.SI.CONJUNTO	Counts cells matching multiple conditions.
IF	SI	WENN	SI	Returns one value when a test is true and another when false.
IFS	SI.CONDITIONS	WENNS	SI.CONJUNTO	Tests multiple conditions in order.
IFERROR	SIERREUR	WENNFEHLER	SI.ERROR	Returns a fallback value when a formula errors.
IFNA	SI.NON.DISP	WENNNV	SI.ND	Returns a fallback when #N/A occurs.
AND	ET	UND	Y	Returns TRUE when all tests are true.
OR	OU	ODER	O	Returns TRUE when any test is true.
NOT	NON	NICHT	NO	Reverses a logical value.
XOR	OUX	XODER	XO	Returns TRUE when an odd number of tests are true.
SWITCH	CHOISIR.SI	ERSTERWERT	CAMBIAR	Matches a value against a list of cases.
VLOOKUP	RECHERCHEV	SVERWEIS	BUSCARV	Looks vertically in the first column of a table.
HLOOKUP	RECHERCHEH	WVERWEIS	BUSCARH	Looks horizontally in the first row of a table.
XLOOKUP	RECHERCHEX	XVERWEIS	BUSCARX	Looks up a value in a range and returns a corresponding result.
LOOKUP	RECHERCHE	VERWEIS	BUSCAR	Looks up a value in a vector or array.
INDEX	INDEX	INDEX	INDICE	Returns a value at a row and column position.
MATCH	EQUIV	VERGLEICH	COINCIDIR	Returns the relative position of a value.
XMATCH	XEQUIV	XVERGLEICH	COINCIDIRX	Modern match function with flexible search modes.
CHOOSE	CHOISIR	WAHL	ELEGIR	Chooses a value from a list by index.
OFFSET	DECALER	BEREICH.VERSCHIEBEN	DESREF	Returns a reference offset from a starting cell.
INDIRECT	INDIRECT	INDIREKT	INDIRECTO	Builds a reference from text.
ROW	LIGNE	ZEILE	FILA	Returns a row number.
COLUMN	COLONNE	SPALTE	COLUMNA	Returns a column number.
ROWS	LIGNES	ZEILEN	FILAS	Returns the number of rows in a reference.
COLUMNS	COLONNES	SPALTEN	COLUMNAS	Returns the number of columns in a reference.
FILTER	FILTRE	FILTER	FILTRAR	Filters a range using criteria.
SORT	TRIER	SORTIEREN	ORDENAR	Sorts a range or array.
UNIQUE	UNIQUE	EINDEUTIG	UNICOS	Returns unique values.
SEQUENCE	SEQUENCE	SEQUENZ	SECUENCIA	Creates a sequence of numbers.
SUMIF	SOMME.SI	SUMMEWENN	SUMAR.SI	Adds values matching one condition.
SUMIFS	SOMME.SI.ENS	SUMMEWENNS	SUMAR.SI.CONJUNTO	Adds values matching multiple conditions.
SUMPRODUCT	SOMMEPROD	SUMMENPRODUKT	SUMAPRODUCTO	Multiplies corresponding values and returns their sum.
PRODUCT	PRODUIT	PRODUKT	PRODUCTO	Multiplies supplied numbers.
ABS	ABS	ABS	ABS	Returns the absolute value.
POWER	PUISSANCE	POTENZ	POTENCIA	Raises a number to a power.
SQRT	RACINE	WURZEL	RAIZ	Returns a square root.
ROUND	ARRONDI	RUNDEN	REDONDEAR	Rounds a number to a specified number of digits.
ROUNDUP	ARRONDI.SUP	AUFRUNDEN	REDONDEAR.MAS	Rounds away from zero.
ROUNDDOWN	ARRONDI.INF	ABRUNDEN	REDONDEAR.MENOS	Rounds toward zero.
MOD	MOD	REST	RESIDUO	Returns the remainder after division.
INT	ENT	GANZZAHL	ENTERO	Rounds a number down to an integer.
TRUNC	TRONQUE	KÜRZEN	TRUNCAR	Truncates a number to a set number of digits.
RAND	ALEA	ZUFALLSZAHL	ALEATORIO	Returns a random number between 0 and 1.
RANDBETWEEN	ALEA.ENTRE.BORNES	ZUFALLSBEREICH	ALEATORIO.ENTRE	Returns a random integer between two values.
MIN	MIN	MIN	MIN	Returns the smallest value.
MAX	MAX	MAX	MAX	Returns the largest value.
MEDIAN	MEDIANE	MEDIAN	MEDIANA	Returns the median.
AVERAGEIF	MOYENNE.SI	MITTELWERTWENN	PROMEDIO.SI	Averages values matching one condition.
AVERAGEIFS	MOYENNE.SI.ENS	MITTELWERTWENNS	PROMEDIO.SI.CONJUNTO	Averages values matching multiple conditions.
LARGE	GRANDE.VALEUR	KGRÖSSTE	K.ESIMO.MAYOR	Returns the k-th largest value.
SMALL	PETITE.VALEUR	KKLEINSTE	K.ESIMO.MENOR	Returns the k-th smallest value.
TODAY	AUJOURDHUI	HEUTE	HOY	Returns today’s date.
NOW	MAINTENANT	JETZT	AHORA	Returns the current date and time.
DATE	DATE	DATUM	FECHA	Builds a date from year, month and day.
YEAR	ANNEE	JAHR	AÑO	Returns the year from a date.
MONTH	MOIS	MONAT	MES	Returns the month from a date.
DAY	JOUR	TAG	DIA	Returns the day of month.
WEEKDAY	JOURSEM	WOCHENTAG	DIASEM	Returns the weekday number.
WEEKNUM	NO.SEMAINE	KALENDERWOCHE	NUM.DE.SEMANA	Returns the week number.
EOMONTH	FIN.MOIS	MONATSENDE	FIN.MES	Returns the last day of a month offset.
EDATE	MOIS.DECALER	EDATUM	FECHA.MES	Moves a date by whole months.
WORKDAY	SERIE.JOUR.OUVRE	ARBEITSTAG	DIA.LAB	Returns a workday before or after a date.
NETWORKDAYS	NB.JOURS.OUVRES	NETTOARBEITSTAGE	DIAS.LAB	Counts working days between dates.
TEXT	TEXTE	TEXT	TEXTO	Formats a value as text.
VALUE	CNUM	WERT	VALOR	Converts text representing a number into a number.
LEN	NBCAR	LÄNGE	LARGO	Returns the number of characters in text.
TRIM	SUPPRESPACE	GLÄTTEN	ESPACIOS	Removes extra spaces from text.
LEFT	GAUCHE	LINKS	IZQUIERDA	Returns characters from the start of text.
RIGHT	DROITE	RECHTS	DERECHA	Returns characters from the end of text.
MID	STXT	TEIL	EXTRAE	Returns characters from the middle of text.
SUBSTITUTE	SUBSTITUE	WECHSELN	SUSTITUIR	Replaces matching text.
REPLACE	REMPLACER	ERSETZEN	REEMPLAZAR	Replaces text by position.
UPPER	MAJUSCULE	GROSS	MAYUSC	Converts text to uppercase.
LOWER	MINUSCULE	KLEIN	MINUSC	Converts text to lowercase.
PROPER	NOMPROPRE	GROSS2	NOMPROPIO	Capitalizes words.
FIND	TROUVE	FINDEN	ENCONTRAR	Finds case-sensitive text.
SEARCH	CHERCHE	SUCHEN	HALLAR	Finds text without case sensitivity.
TEXTJOIN	JOINDRE.TEXTE	TEXTVERKETTEN	UNIRCADENAS	Joins text with a delimiter.
ISBLANK	ESTVIDE	ISTLEER	ESBLANCO	Tests whether a cell is blank.
ISERROR	ESTERREUR	ISTFEHLER	ESERROR	Tests whether a value is an error.
ISNUMBER	ESTNUM	ISTZAHL	ESNUMERO	Tests whether a value is numeric.
ISTEXT	ESTTEXTE	ISTTEXT	ESTEXTO	Tests whether a value is text.
FORMULATEXT	FORMULETEXTE	FORMELTEXT	FORMULATEXTO	Returns a formula as text.
LET	NOMMER	LET	LET	Assigns names to calculation results inside a formula.
SUBTOTAL	SOUS.TOTAL	TEILERGEBNIS	SUBTOTALES	Calculates a subtotal while optionally ignoring hidden rows.
HYPERLINK	LIEN_HYPERTEXTE	HYPERLINK	HIPERVINCULO	Creates a clickable hyperlink.
TRANSPOSE	TRANSPOSE	MTRANS	TRANSPONER	Switches rows and columns.