please help my with indirect function

27/06/2012 - 16:00 von PETROLINI75 | Report spam
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.
 

Lesen sie die antworten

#1 Bernhard Sander
27/06/2012 - 17:25 | Warnen spam
Hello PETROLINI75,

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?.




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

Ähnliche fragen