With the last thing first: The ALS is simply the Dutch version of IF in the Dutch Excel. So, if the computer is configured with the Dutch Office 2000 any English Excel spreadsheet is automatically "translated" to Dutch Excel statements and also the changes in symbols are done automatically. . .even prices in which you would use a period . . .$45.76. . .for a decimal are converted to $ 45,76.
Of course, any remarks that are not part of the Excel functions remain in English
In my latest remark on this I mentioned that everything works if I get an English Excel spread. The point I made thereafter was that IF a calculation requires a number then IF that number is not given (blank cell) then the calculation can not proceed! I do not know yet what alternatives there are for this. For me it is no problem that an empty Cell is given a zero but often a 0 price give a calculation problem. . . That was my point for in many cases you create than division by zero.
I will check out later your suggestion in regards to:
As you can see even though B128 is blank, roll 128 does not have error messages.
Which appears to be a case in which a "missing" price(Empty Cell) is presented for a calculation. . .I will see if that relates to what I asked.
Is what you call "roll" the same as what I call "row" ?
I have not yet had any time to look into OpenOffice . . .I need 89 hours in a day to get everything done I want to do
I bought a scanner for my computer today but had no time to install it yet. . .was supposed to meet my son for lunch but he did not show up. . more hours wasted Have not heard anything from him. I hope he is alright.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.