Can't see conventional references

[vilas desai]

Dear Experts

Please advise me how do I interpret this formula

=[@[JnBox ID]]&"_"&[@[JB Term inal]]

Why dont I see a conventional references in the formula?

Thanks
Vilas Desai

[HansV]

Those are called structured table references.

[@[JnBox ID]] refers to the column named JnBox ID in the same row as the cell with the formula, and [@[JB Term inal]] refers to the column named JB Term inal in the same row as the cell with the formula (both in the same table).

The advantage of using a structured reference is that the column names are more readable than cell references - if the column names are meaningful, it is easier to understand what the formula refers to.

If you don't like this, you can turn it off:
- Select File > Options.
- Select Formulas in the navigation pane on the left.
- Clear the check box 'Use table names in formulas'.
- Click OK.
This will take effect when you create new formulas; existing formulas won't change.

See for example Structured reference for more info.

[vilas desai]

Oh Hans Thanks a lot.