Sum in English. But what in other languages?

[Alfred]

Hi!

I have an annoying problem I wanted to solve long time ago. When I use an
Excel version other than English, I keep forgetting the equivalent to
functions in
other languages (e.g. "sum" is "summa" in the Swedish and "Somme" in French
version).

I bet there is a smart way to solve this problem. Any ideas? Many thanx!

 

[Harald Staff]

Sure. As long as you know the english equivalent, for entry (or for pasting solutions from
english newsgroups) just select the cell and run a small macro like this:

Sub EnterEngFormula()
ActiveCell.Formula = _
InputBox("English formula in " & _
ActiveCell.Address & ":")
End Sub

Likewise, if you're in Norway and see something like =FINN.RAD in a cell, select and run
this to see/copy what on earth that might be:

Sub ShowEnglishFormula()
Call InputBox("English formula in " & _
ActiveCell.Address & ":", , _
ActiveCell.Formula)
End Sub

Those tricks are very useful because you can write them there and then anywhere in a few
seconds. For more extensive international work, install KeepITcool's translator found at
http://members.chello.nl/keepitcool/download.html

 

[chen hong]

can't you use the buttons?

 

[Anders S]

Hi Alfred,

With my Swedish version of Excel I use the Immediate Window in the VBA Editor all the time to translate functions.

In the Immediate Window, enter
range("A17").Formula = "=sum(B1,B2)"

=SUMMA(B1;B2)
will be entered in A17 - note the colon/semicolon conversion

?range("A17").Formula
will return
=SUM(B1,B2)

Also,
?range("A17").FormulaLocal
will return
=SUMMA(B1;B2)

If there are quotes in the formula, they must be doubled, like in
range("A17").Formula = "=""Blaha"" & "" blaha"""

Best regards,
Anders Silven