Sum in English. But what in other languages?

  • Thread starter Thread starter Alfred
  • Start date Start date
A

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!
 
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
 
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
 
Back
Top