Thread
:
How can I write multidimensional arrays in Excel Formulas?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
external usenet poster
Posts: 10,593
How can I write multidimensional arrays in Excel Formulas?
You have a continental language setup, where the ; and , are inter-changed.
Just switch them around (oh, it probably means that . is the thousands
separator and , is the decimal separator for you).
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Vasil Ivanov" <Vasil
wrote in message
...
I read in the documentation. That multidimensional arrays should look
something like that ={1,2,3;4,5,6;7,8,9}, but my Excel regards that as an
error. The program allows me only to type that: = {1;2;3;4;5;6;7;8;9}. I
have
also noticed that in the Excel documentation that function parameters are
delimited by comma like that:
=if(true(),1,0), but again Excel tells me that this is an error. When I
write it with semicolon like if(true();1;0) it is working. Can you explain
me
what is happening?
P.S. I am using MS Excel 2003 (11.6560.6568) SP2
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips