Forum

Notifications
Clear all

Error Code when creating Array

4 Posts
3 Users
0 Reactions
122 Views
(@henrikl)
Posts: 5
Active Member
Topic starter
 

Hi,

When I write the following code I expect the answer should be number of columns covered in the array {1,2,3;4,5,6} But instead receive I an error code, see attached file.

=COLUMNS({1,2,3;4,5,6})

I have pressed Ctrl+Shift+Enter

Capture-1.JPG

Thank you

/Henrik

 
Posted : 07/05/2020 9:16 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Henrik,

I can't reproduce that error. The formula returns 3 for me.

Do you get the same error with:

=COLUMNS({1,2,3})

OR

=COLUMNS({0,0,0;0,0,0})

Both should return 3. The second row, specified by the semi-colon, is irrelevant/discarded by COLUMNS anyway.

Mynda

 
Posted : 07/05/2020 7:20 pm
(@henrikl)
Posts: 5
Active Member
Topic starter
 

Hi Mynda,

Thank you for your answer and your effeort to help me.

I have already solved the problem. In my region (I live in Sweden) is the "," replaced by ""

When I wrote =COLUMNS({123;456}) did it work fine.

 

Thank you again!

Br

Henrik

 
Posted : 08/05/2020 4:33 am
(@debaser)
Posts: 838
Member Moderator
 

I'd assume it's your regional settings. You probably need something like:

=COLUMNS({123;0})

 
Posted : 08/05/2020 5:09 am
Share: