MS Excel cell reference

cherryblossomzel

A colleague has somehow managed to generate a formula that include a cell reference that looks like this:

[@[Statement actual]]

instead of the usual A1 or C3 etc.

What on earth does that mean? ("Statement actual" is the name of the column the cell is in) When I try to redo the formula in a different cell, the same strange cell reference comes up when I click on that cell, though I can type the cell reference in manually and that then looks normal.

The cell reference cannot be changed by clicking and dragging the borders of the cell when the formula is selected.


The cell in question is formated as an acountancy-type cell, but even when I change it to "Number" it still does the funny.

Google is no help at all.

Edit: is it because the cell is in a table?

System

Hi

The formulas are

=SUM(C6*D6)

=SUM(seven*eight)

12 12 144 12 12 144
The numbers are 12 and the answer is 144.

So in your query formula have any cells been renamed (from C7 to seven, and D7 is now eight) like I have done??

Cell A1 becomes cell ] as a reference?

droopsnoot

Does this help: http://superuser.com/questions/501691/what-does-the-bar-foo-operator-do-in-excel-in-particular-the-at-sign

cherryblossomzel

droopsnoot wrote: »

Does this help: http://superuser.com/questions/501691/what-does-the-bar-foo-operator-do-in-excel-in-particular-the-at-sign

Yes it does, thank you. I couldn't find anything before.

I've advised my colleague to stop using tables. When in doubt, pretend the problem doesn't exist:rotfl: