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 (http://www.excelling.it/index.php?option=com_content&view=article&id=268:traduttore-funzioni-excel&catid=39:varie&Itemid=54)

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 (http://en.excel-translator.de/) 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 :eek:.