4 ms·
>> People view some spreadsheet cells as state... But a cell with a function is not a function, it’s a result of calling a function at a certain set of values.
by heavenlyblue 7y ago
>> People view some spreadsheet cells as state...
But a cell with a function is not a function, it’s a result of calling a function at a certain set of values. That is even true if you only use ArrayFormula.
E.g. you can’t define a formula inside a cell and the call that cell with certain arguments.
- _bxg1 7y agoThe arguments are the other cells it references, which are themselves either state or other functions