Integration Formulas & International Options

Hi,
Testing some complex formulas available on the net, I find it difficult to translate with punctuation request.
Convert the formulas to English / Italian
Link: Traduttore funzioni Excel

The functions in this way can translate, remains the problem of punctuation.
What are the correct settings should I use to be able to introduce the formulas so I can enable disabled with a cycle

The formula type:

Quote:

---

=MID(REPT(",x",SUMPRODUCT(--($B$3:$B$9=$E3),--($A$3:$A$9=F$2))),2,255)

---

Become a:

Quote:

---

=STRINGA.ESTRAI(RIPETI(";x";MATR.SOMMA.PRODOTTO(--($B$3:$B$9=$E3);--($A$3:$A$9=F$2)));2;255)

---

Do I have to resign myself to change the format in English, including punctuation ...

Thank you in advance for any clarification

Why don't you use this site: Excel Translator English and apply the action for the separators.

Hi,

Formula to convert:

Quote:

---

=MID(REPT("x",SUMPRODUCT(--($B$3:$B$9=$E3),--($A$3:$A$9=F$2))),2,255)

---

En.excel-translator.de:

Quote:

---

=STRINGA.ESTRAI(RIPETI("x",MATR.SOMMA.PRODOTTO(--($B$3:$B$9=$E3),--($A$3:$A$9=F$2))),2,255)

---

Remains the only place of punctuation: , con ;

Quote:

---

=STRINGA.ESTRAI(RIPETI("x";MATR.SOMMA.PRODOTTO(--($B$3:$B$9=$E3);--($A$3:$A$9=F$2)));2;255)

---

Use this setting to practice

Thanks for the link reported

Note that there is an Option in the translator tool to replace commas with semicolons automatically while translating the formula from English to Italian or other language.

Hi,

Formula to convert:

Quote:

---

=IF(AND($C4<>"",OR(MONTH($C4)=1,MONTH(EDATE($C4,1) )=1,MONTH(EDATE($C4,2))=1)),VLOOKUP($D4,$R$4:$S$5, 2,FALSE),"")

---

En.excel-translator.de:

Quote:

---

=SE(E($C4<>"";O(MESE($C4)=1;MESE(DATA.MESE($C4;1)) =1;MESE(DATA.MESE($C4;2))=1));CERCA.VERT($D4;$R$4: $S$5;2;FALSO);"")

---

Perfect! I recommend it to everyone.

Quote:

---

Originally Posted by PcMax

[...]Perfect! I recommend it to everyone.

---

That's what I thought I said in post #2 :eek:.