Excel

What is open square bracket in excel?
Shiv Mahima OjhaAsked:
Who is Participating?
 
Bill PrewCommented:
Another use of square brackets in formulas is when referencing a cell in another workbook, so if Book1 wants to reference a cell in Book2 it would use:

=[Book2]Sheet1!$A$1


»bp
0
 
Justin EvansCommented:
The open square bracket is used for column references.

please see this website below for an example

http://excelsemipro.com/2011/04/formulas-and-structured-data-in-excel-tables/

kind Regards

Justin
0
 
Bill PrewCommented:
Do you mean in Excel formulas?  If so, please provide a sample of a formula you are seeing this, it can indicate several things, so hard to be sure without seeing your formula.

Another purpose for them in a formula is if you use "R1C1" cell addressing, rather than "A1".  For example this formula in cell A1:

=R[1]C[1]

Would refer to the contents of cell B2.



»bp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.