What does an Excel formula mean

What does "@" mean in Excel formulas?
authormessage
Ignorant guest
guest


Posted:
Feb 13, 2012, 12:52 pm
First name:

       Version: Office 2010

Hello knowing!

I have now "worked through" all the Excel forums, MS Office tools and experiences of my colleagues known to me, unfortunately without success. I ask for help.
I just need a general description of what an @ sign does directly in an Excel formula.
e.g .:
= [@ [TOTAL

What does @ mean here? I cannot find a functional description anywhere. Is it a reference to a custom (hidden) list? A reference to the column headers of another worksheet?

I have a concrete Excel table, but I am not allowed to put it in here (hot data). Unfortunately, I have not succeeded in 'generalizing' this table. That is why I am simply hoping for a functional description of this @ -sign. That would help me a lot.

(What I already know: In "Form cells" => User-defined formatting, type "@ *." Can automatically fill a cell up to the end of the cell)
< Peter >
Excel moderator who is still learning


Posted:
Feb 13, 2012, 1:00 p.m.
Call name: It depends on who is calling
Place of residence: The most beautiful country in Germany's Gaun
    UpAll times are
GMT + 1 hour
You can Post in this forum.
You can Reply to posts in this forum.
You can your posts in this forum Not to edit.
You can your posts in this forum Not Clear.
You can to polls in this forum Not participate.
You can Files in this forum Not Post
You can Download files in this forum

Related topics
Forum / Topics reply author Calls last contribution
Excel VBA (macros): what does that mean ???4matzen2410728 Nov 2013, 10:49
matzen24
Excel VBA (macros): what does this code mean?2XaTaX11330 Jul 2013, 2:26 pm
XaTaX
Excel formulas: Excel formulas with variable names of the reference files possible?1sunshine919519 Oct 2012, 10:12
Starfighter82
Excel VBA (macros): Change Excel formulas in VBA2Coxinator19708 Feb 2012, 11:24 pm
Gerd L
Excel help: What does the * in functions1Guest 0815200Jan 24th 2012, 5:22 pm
FCH
Excel formats: Excel formulas - output last entry in A14peterF172011 Jan 2012, 12:18 pm
Braunsdorf83
Excel VBA (macros): Runtime error 400. What does it mean and where is the error5MWolf594Feb 22, 2011, 5:40 pm
MWolf
Excel VBA (macros): what does the following mean ...2stef0908berlin19223 Jan 2011, 7:07 pm
stef0908berlin
Excel formulas: what does the dollar sign in a formula mean?4wauzi834501 Dec 2010, 10:31 pm
< Peter >
Excel VBA (macros): Change Excel formulas with a button. (Reference)2seppwert39119 Aug 2009, 7:02 pm
Nepumuk
Excel VBA (macros): What does this message mean?3Exceedi69803 Nov 2008, 8:58 pm
Bamberg
Excel formulas: Excel formulas for sports table19Ymatt2224470Aug 15, 2008, 3:43 pm
Raimund