Excel functions Portuguese English
With lots of Excel users making use of the product in other languages it is useful to understand what the formula are called in both English and the alternate language.
For this page we are showing the key functions that we feel are most useful and covered on this website from Portuguese for our Mozambican and Angolan readers. For a full listing of the Portuguese name for the Excel functions you can visit this translation site.
| Function | Função |
| IF | SE |
| AND | E |
| OR | OU |
| CLEAN | LIMPAR |
| CONCATENATE | CONCATENAR |
| DOLLAR | MOEDA |
| TEXT | TEXTO |
| LEFT, LEFTB | ESQUERDA, ESQUERDAB |
| LEN, LENB | NÚM.CARACT, NÚM.CARACTB |
| MID, MIDB | SEG.TEXTO, SEG.TEXTOB |
| RIGHT, RIGHTB | DIREITA, DIREITAB |
| FIND, FINDB | LOCALIZAR, LOCALIZARB |
| SEARCH, SEARCHB | PROCURAR, PROCURARB |
| VALUE | VALOR |
| SUBSTITUTE | SUBST |
| LOWER | MINÚSCULAS |
| PROPER | INICIAL.MAIÚSCULA |
| REPT | REPETIR |
| TRIM | COMPACTAR |
| UPPER | MAIÚSCULAS |
| HLOOKUP | PROCH |
| VLOOKUP | PROCV |
| RANK | ORDEM |
| IFERROR | SE.ERRO |
| ISERROR | É.ERRO |
| AVERAGEIF | MÉDIA.SE |
| AVERAGEIFS | MÉDIA.SE.S |
| COUNTIF | CONTAR.SE |
| COUNTIFS | CONTAR.SE.S |
| LARGE | MAIOR |
| MAX | MÁXIMO |
| MIN | MÍNIMO |
| SUM | SOMA |
| SUMIF | SOMA.SE |
| SUMIFS | SOMA.SE.S |
| SUMPRODUCT | SOMARPRODUTO |
| CHOOSE | SELECCIONAR |
| TRANSPOSE | TRANSPOR |
| DATE | DATA |
| DAY | DIA |
| MONTH | MÊS |
| YEAR | ANO |
| EOMONTH | FIMMÊS |
| WEEKDAY | DIA.SEMANA |
| WEEKNUM | NÚMSEMANA |
| WORKDAY | DIA.TRABALHO |
| NETWORKDAYS | DIATRABALHOTOTAL |
| DATEVALUE | DATA.VALOR |
| DAYS360 | DIAS360 |
| YEARFRAC | FRACÇÃOANO |