Replies to post #34170 on A.I.M. Users Bulletin Board (AIMUSERS)

[aim hier]

I assume CAER is a European stock. The name sounds ominous to me for a stock. Caer is a Spanish verb meaning to fall, or collapse. Not a trait I look for in stocks.

[ls7550]

Hi LC

By the way I use openoffice, it does not have the function ALS, what does ALS do. How can a IF statement work if it is changed to a ALS statement?

ALS is just Dutch for IF

[Conrad]

Hallo Cowboy!

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.

[Conrad]

OK Cowboy,

I have looked at that spread you linked to me and I understand what you mean:

B127 is the last data entry and B128 is still empty. . No problem!
On Row 128 there is no Data Entry yet so the calculation could not be done anyway, and I always duplicated the precious price in the cells below.

If the prices in B129 and B130 are filled in and B128 is empty then the calculation goes haywire in that spread too!.

I noticed that in that spread there is an Automatic Row Addition Feature installed.. . ARAF

I have not even learned how to do that! No doubt it is an simple statement. But below the last Row I have various information blocks, so if I ad rows I have to move these down first. . unless that can be done automatically too.

I need to read Excel for Dummies :-)