Login Page - Create Account

Support Board


Date/Time: Mon, 02 Feb 2026 11:45:28 +0000



Post From: New Spreadsheets INDIRECT function

[2015-05-03 23:04:52]
Sawtooth - Posts: 4312
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