Excel table reference difference between [@column] and [column]

Question

I have a table in Excel and some equations in columns for all rows.

I have equation like this: =IF([@C1]=0,[@C2],MIN([@C1], [@C2]))

and then like this: =IF([C1]=0,[C2],MIN([C1], [C2]))

Goal is to check column C1 and if it is not 0, use minimum between C1 and C2.

If I use first option with @, it works ok, while second always returns 0, no matter what is in C1 or C2.

What is the difference between equations?

Answer 1

With @ you refer to the same row as where your formula is. Without the @, you make reference to the entire column.

But your formula is confusing as C1 is usually not a column but a cell in Excel. Typical syntax for using structured references with Excel tables is TableName[ColumnName] to refer to a column of a table.