A.I.M. Users Bulletin Board

[lostcowboy]

Hi Conrad, when talking about spreadsheets it may be worth while to download the original spread sheet. The spreadsheet that is being adjusted is on http://www.aim-users.com/aimware.htm in that worksheet you have to put in the stock prices manually. The third sheet is a example sheet for the stock CAER.
The stock prices are put in the B column. If you go down to roll 127 and roll 128 you should be able to see what the formula is doing for you. In roll 128 B128 is blank, if the Columns that use the B column did not have some type of checking you would see error messages in them. As you can see even though B128 is blank, roll 128 does not have error messages.

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?