Arrays
Elements of arrays can be accessed directly using bracket notation. The value to use as an index starts at the number 1.
=ARRAY(1, 2, 3)[2]→2
=ARRAY(1, 2, 3)[1]→1
=ARRAY(1, 2, 3)[0]→#ERROR!
Updated 7 months ago
Elements of arrays can be accessed directly using bracket notation. The value to use as an index starts at the number 1.
=ARRAY(1, 2, 3)[2]→2
=ARRAY(1, 2, 3)[1]→1
=ARRAY(1, 2, 3)[0]→#ERROR!
Updated 7 months ago