Forum Discussion
error in ADRES() function using an array constant parameter
This is most likely due to the fact that your system locale uses the comma as decimal separator. As such, the array constant
{1,2;3,4}does not represent a 2-row-by-2-column array; rather a 2-row-by-1-column array, the 2 elements of which are one and two-tenths and three and four-tenths.
The ADDRESS function's row_num and column_num parameters accept non-integer inputs, truncating to the integer portion only in such cases.
Also, I assume you must be selecting four cells within the worksheet and array-entering that formula with CSE. Any cell within the first row of your selected array will return the result of
ADDRESS(33,1)And any cell within the second row of your selected array will return the result of
ADDRESS(33,3)You need to find out what represents the separator for horizontal arrays for your version of Excel; clearly it is not the comma. For example, assuming it is the backslash (\), the correct syntax would be
=ADDRESS(33;{1\2;3\4})Regards
This is most likely due to the fact that your system locale uses the comma as decimal separator. As such, the array constant
{1,2;3,4}does not represent a 2-row-by-2-column array; rather a 2-row-by-1-column array, the 2 elements of which are one and two-tenths and three and four-tenths.
The ADDRESS function's row_num and column_num parameters accept non-integer inputs, truncating to the integer portion only in such cases.
Also, I assume you must be selecting four cells within the worksheet and array-entering that formula with CSE. Any cell within the first row of your selected array will return the result of
ADDRESS(33,1)And any cell within the second row of your selected array will return the result of
ADDRESS(33,3)You need to find out what represents the separator for horizontal arrays for your version of Excel; clearly it is not the comma. For example, assuming it is the backslash (\), the correct syntax would be
=ADDRESS(33;{1\2;3\4})Regards