First of all I use range names for single cells in Calc and it works fine.
My problem was in a very deeply nested formula. The formula works fine when
I use a cell reference but does not return anything when there is a cell
name.
The structure of the formula is as follows. If have only included formula
names to make it simple.
{IF(IF(ISERR(INDEX(SMALL(DATE(year;month;day)......}
When year, month, or day is a cell reference there is no problem ($A$1 for
example). When I use a cell name it does not work (CalYear for example).
Could it be that names must refer to a range if included in an array formula
"{...}"?
--
Dennis Marks
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
