Common Italian (CERCA.VERT, SE…) and Portuguese (PROCV, SE…) function names mapped to English.
Italian and Portuguese Excel both translate function names, so formulas from those versions look unfamiliar in English Excel. This reference maps the most common Italian and Portuguese function names to English. For all 522 functions, use the full translation table.
| Italian | English |
|---|---|
SOMMA | SUM |
MEDIA | AVERAGE |
SE | IF |
CERCA.VERT | VLOOKUP |
CERCA.X | XLOOKUP |
SOMMA.SE | SUMIF |
CONTA.SE | COUNTIF |
CONFRONTA | MATCH |
INDICE | INDEX |
SE.ERRORE | IFERROR |
| Portuguese | English |
|---|---|
SOMA | SUM |
MÉDIA | AVERAGE |
SE | IF |
PROCV | VLOOKUP |
PROCX | XLOOKUP |
SOMASE | SUMIF |
CONT.SE | COUNTIF |
CORRESP | MATCH |
ÍNDICE | INDEX |
SEERRO | IFERROR |
SOMMA.SE/SOMASE (SUM+IF) and CONTA.SE/CONT.SE (COUNT+IF) are predictable.CERCA.VERT / PROCV for VLOOKUP, CERCA.X / PROCX for XLOOKUP.VERO/FALSO (IT) / VERDADEIRO/FALSO (PT) for TRUE/FALSE.Paste an Italian or Portuguese formula into the formula translator, set the source language, and it converts the names, separators and constants to English at once.