Integration Formulas & International Options

[PcMax]

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:

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

Become a:

=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

[rollis13]

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

[PcMax]

Hi,

Formula to convert:

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

En.excel-translator.de:

=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 ;

=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

[NBVC]

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.

[PcMax]

Hi,

Formula to convert:

=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:

=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.

[rollis13]

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

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