View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vasil Ivanov Vasil Ivanov is offline
external usenet poster
 
Posts: 1
Default How can I write multidimensional arrays in Excel Formulas?

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