Formula GuideExcel Formula Guide in Italian
Complete documentation of 238+ Excel formulas translated and explained in Italian with practical examples.
Formula Guide
This is a reference for 238+ Excel formulas covering Italian names, correct syntax for Italian Excel, and a ready-to-use example for each one. Formulas are split into 10 categories - browse by topic or search if you are not sure where to start.
Note: This formula guide is written in Italian, as it documents Italian Excel syntax where function names, argument separators, and boolean values differ from the English version (e.g. VLOOKUP becomes CERCA.VERT, TRUE/FALSE becomes VERO/FALSO, and commas become semicolons).
What each formula page includes
- Italian and English name (e.g. CERCA.VERT / VLOOKUP)
- Italian syntax with the
;separator used in Italian Excel - Practical example ready to copy
- Tip for real-world use
Available categories
| Category | Formulas | Description |
|---|---|---|
| Lookup and reference | 39 | CERCA.VERT, CERCA.X, INDICE, CONFRONTA, FILTRO, ORDINA... |
| Math | 59 | SOMMA, ARROTONDA, PRODOTTO, SUBTOTALE, RADQ, SEQUENZA... |
| Logic | 19 | SE, E, O, SE.ERRORE, PIU.SE, SWITCH, LET, LAMBDA... |
| Text | 29 | SINISTRA, DESTRA, LUNGHEZZA, SOSTITUISCI, CONCATENA... |
| Date and time | 25 | OGGI, DATA, GIORNO.SETTIMANA, FINE.MESE, GIORNI.LAVORATIVI... |
| Statistics | 24 | MAX, MIN, MEDIANA, DEV.ST, PERCENTILE, CORRELAZIONE... |
| Conditional | 5 | SOMMA.PIU.SE, MEDIA.SE, MAX.PIU.SE... |
| Financial | 15 | RATA, VA, VF, VAN, TIR.COST, AMMORT... |
| Information | 17 | VAL.VUOTO, VAL.ERRORE, VAL.NUMERO, TIPO, CELLA... |
| Database | 6 | DB.SOMMA, DB.CONTA.NUM, DB.MEDIA, DB.MAX... |
Not sure which formula you need?
Head to Search Formulas and describe in Italian what you want to do - you will find the right formula even without knowing its name.