Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 20:00:37 +0000



Post From: New Spreadsheets INDIRECT function

[2015-05-03 23:04:52]
Sawtooth - Posts: 4141
Thanks for adding this function, except it gives a #SYNTAX error with this:
=INDIRECT("C"&"3")
This syntax is needed/used to create a cell reference from 2 text sources.

Even using an intermediate cell with this also give a #SYNTAX error:
="C"&"3"

Both of the above work in the Old Spreadsheets.


Date Time Of Last Edit: 2015-05-03 23:20:10