Solved: Excel's Formulas Name List (German-English)

[Erdin? E. Ka]

Hi everyone.

I need a list of Excel's Formulas Name List (German-English)

English: German:
IF WENN
AND UND
OR ODER

something like this...

Can anyone have a list like this?

Thanks in advance.

[Bob Phillips]

.

[TonyJollans]

Not a direct translation - and not directly comparable lists - but the information you need is here for English (all on one page) and hier for German (links to categorised lists). Not ideal, perhaps, but I'm sure you'll be able to match them up.

[TonyJollans]

Actually I've just had a closer look and the lists seem to be in the same order (English equivalent alphabetical) so matching them should be straightforward. Also the individual function urls seem to be similar enough to compare directly. For example DAVERAGE in English is at office.microsoft.com/en-us/assistance/HP052090451033 and DBMITTELWERT is at office.microsoft.com/de-de/assistance/HP052090451031. In other words the language and country elements change but the rest remains the same.

I do notice what looks like a typo in that DBANZAHL2 (DCOUNTA) is billed as DBANZAHL (DCOUNT) but I'm sure you can work it out.

[TonyJollans]

What I didn't note, though, was Bob's reply :-) He's already done all the work.

[Erdin? E. Ka]

Hi xls AND TonyJollans,

It's ok. I solved the matter with your answers.

Thank you very much.