Integration Formulas & International Options

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