| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array of formulas (regional difference)
'Following works for both US and Dutch x = "=if(x,0,0)" y = Array("hello", "=w") ' Following works for US, but not in Dutch, why? y = Array("hello", "=if(x,0,0)") The default argument separator for Dutch regional settings is ";" For US the comma is used. Try the following statement y = Array("hello", "=if(x;0;0)") regards, Erik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regional Settings / Finding out Array separator characters | New Users to Excel | |||
| Average of a difference between 2 cels in a table/array | Excel Worksheet Functions | |||
| Second largest in array of difference in high-low values in cells | Excel Worksheet Functions | |||
| Could someone tell me the difference in these formulas? | Excel Worksheet Functions | |||
| Array difference? | Excel Programming | |||
![Erik Creyghton[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
