How to find formula keywords for none English regional options

[Ming Zhao]

In my Visual Studio for Office application, I have the code that writes to an
Excel cell a formula

=IF(AND($A40<>"",$B40<>""),$A40-$B40,"")

It works well when the Windows’ Regional Option is English. But it does not
work when the Regional Option is changed to Swedish.

For Swedish settings, the separator needs to be changed from , to ; which
can be obtained from System.Globalization.CultureInfo.CurrentCulture. But it
also needs to change “IF†to “WENN†and “AND†to “UNDâ€. In another formula, I
have “POWERâ€.

Is there any system parameter that can return the text strings as the
replacement of “IFâ€, “ANDâ€, “Powerâ€, etc. for the given regional option?
Otherwise to use a big Case statement to switch on the three letters Windows
language name is neither convenient nor complete.

Thanks in advance for any information.

 

[Bob Phillips]

You would write the formula in the English form, Excel will translate it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)