Formula GuideHow to Use Excel SOS
Quick guide to get started with Excel SOS and solve Excel problems in Italian.
How it works
Excel SOS works in Italian and covers four main use cases.
- Formula translation
Type an English or Italian formula name and get the complete translation:
/traduci VLOOKUP
Result:
- Italian name: CERCA.VERT
- Syntax:
CERCA.VERT(value; table; index; [range]) - Example:
=CERCA.VERT(A2; Sheet2!A:C; 3; FALSO)
- Natural language search
Don't know the formula name? Describe what you want to do:
/cerca sum only the cells from Milan
Excel SOS will find SOMMA.SE and show you how to use it.
- Free questions
Ask any question about Excel:
"How do I calculate the difference between two dates in months?"
The AI will respond with the correct formula and a practical example.
- Screenshot diagnosis
Upload a screenshot of your Excel sheet with an error. The AI will analyze the content and explain:
- What the error is
- Why it occurs
- How to fix it
Italian syntax rules
In Italian Excel there are some important differences:
| Element | English | Italian |
|---|---|---|
| Argument separator | , (comma) | ; (semicolon) |
| TRUE / FALSE | TRUE, FALSE | VERO, FALSO |
| Decimal separator | . (period) | , (comma) |
| Function names | VLOOKUP, IF, SUM | CERCA.VERT, SE, SOMMA |
Practical example
English formula: =VLOOKUP(A2, Sheet2!A:C, 3, FALSE)
Italian formula: =CERCA.VERT(A2; Foglio2!A:C; 3; FALSO)
Note how: the comma becomes a semicolon, FALSE becomes FALSO, and Sheet becomes Foglio.