Excel - please help my with indirect function

Asked By PETROLINI7 on 27-Jun-12 10:00 AM
Hello,
sorry if I write in English.
I need your help with the German version of excel.

If I write this formula on cell A2..

=INDIREKT("R[-1]K";FALSCH)

I got an error. It should give me the contents of cell A1...
Some syntax error?.

Thank you in advance.


Bernhard Sander replied to PETROLINI7 on 27-Jun-12 11:25 AM
Hello PETROLINI75,


Row is Zeile, column is Spalte in german.
Instead of sqare brackets [] use round brackets ()

=INDIREKT("Z(-1)S";FALSCH)
should do the job.

Regards
Bernhard Sander