SOLVED

Spaltennamen in Formel statt Zellenbezug

%3CLINGO-SUB%20id%3D%22lingo-sub-2282337%22%20slang%3D%22de-DE%22%3EColumn%20names%20in%20formula%20instead%20of%20cell%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282337%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20your%20help.%3C%2FP%3E%3CP%3EThe%20case%3A%3C%2FP%3E%3CP%3EThere%20are%20two%20columns%3A%20A%3D%20Quantity%3C%2FP%3E%3CP%3EB%3D%20Price%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20now%20be%20in%20the%20cell%20in%20which%20the%20formula%20%3DA2*B2%20is%20now%20%3Dquantity*price.%3C%2FP%3E%3CP%3EThat%20is%2C%20the%20column%20name%2C%20not%20the%20cell%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20find%20anything%20on%20the%20internet%20just%20for%20Excel%202010%2F13.%20But%20this%20would%20be%20the%20for%20Excel%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3CP%3EDRF92%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282337%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282355%22%20slang%3D%22en-US%22%3ERe%3A%20Spaltennamen%20in%20Formel%20statt%20Zellenbezug%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034719%22%20target%3D%22_blank%22%3E%40DRF92%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDo%20you%20mean%20something%20like%20that%20...%20in%20that%20direction%3F%20..Please%20see%20the%20file.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hallo Community,

 

ich bräuchte eure Hilfe.

Der Fall:

Es gibt zwei Spalten: A= Menge

                                  B= Preis

 

Es soll nun in der Zelle in welcher die Formel =A2*B2 steht nun =Menge*Preis stehen.

Sprich der Spaltenname und nicht der Zellenbezug.

 

Ich finde nichts im Internet nur etwas für Excel 2010/13. Bräuchte dies aber für Excel 2016.

 

Danke für Eure Hilfe

DRF92

3 Replies

@DRF92 

 

Do you mean something like that ... in that direction? ..Please see the file.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

best response confirmed by DRF92 (New Contributor)
Solution

@DRF92 

Wählen Sie Spalte A aus.
Klicken Sie in das Feld Name auf der linken Seite der Formelleiste.
Geben Sie Menge ein und drücken Sie die Eingabetaste.

 

S0336.png

Wählen Sie Spalte B.
Klicken Sie in das Feld Name auf der linken Seite der Formelleiste.
Geben Sie Preis ein und drücken Sie die Eingabetaste.

 

S0337.png


Sie können jetzt die Formel =Menge*Preis verwenden.

 

S0338.png

@Hans Vogelaar 

Perfekt vielen Dank!!