| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
| scalable headings in Microsoft Excel when editing long formulas | Excel Discussion (Misc queries) | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Threaded Mode
