Referenzformat

%3CLINGO-SUB%20id%3D%22lingo-sub-2001479%22%20slang%3D%22de-DE%22%3EReference%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2001479%22%20slang%3D%22de-DE%22%3E%3CP%3EHow%20do%20I%20take%20the%20value%20in%20cell%20Z(-1)S(-1)%20into%20cell%20ZS%20without%20entering%20the%20address%20directly%3F%3C%2FP%3E%3CP%3EI%20couldn't%20find%20the%20description%20of%20the%20use%20of%20%24Z(-1)%24S(-1).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2001479%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2001554%22%20slang%3D%22en-US%22%3ERE%3A%20Referenzformat%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2001554%22%20slang%3D%22en-US%22%3EIf%20you%20switch%20the%20address%20notation%20from%20A1%20to%20the%20R1C1%20reference%20style%20(you%20might%20like%20to%20think%20of%20it%20as%20Z1S1)%20a%20relative%20reference%20would%20be%20given%20by%20%3DR%5B-1%5DC%5B-1%5D.%3C%2FLINGO-BODY%3E
Occasional Visitor

Wie übernehme ich den Wert in der Zelle Z(-1)S(-1) into  Zelle ZS, ohne die Adresse direkt einzugeben?

Die Beschreibung der  Benutzung von $Z(-1)$S(-1) habe ich nicht gefunden.

 

2 Replies
If you switch the address notation from A1 to the R1C1 reference style (you might like to think of it as Z1S1) a relative reference would be given by =R[-1]C[-1].

Hi @RimiBS 

 

You can use the field name if your data is in table, this way you will not use the reference.