A.I.M. Users Bulletin Board

[SFSecurity]

Thanks Adam, got it. Now a couple of questions. What does $/Y stand for in column Y? I notice that you have to enter rather large numbers to change the results in column AC. What is that number and what is it supposed to stand for? How do you derive that number?

Then in column AC you have the formula:

=IF(A18<>"";1+(A18-A17)/365*Y17/100;"")

What function does 365*Y17 serve? It looks like a divide by zero error if Y17 = 0 because 365*0 = 0. Is there a set of parens missing or some additional number missing?

I noticed something a bit screwy in the Test page as it downloaded in the Hold Zone calcs and can't quite figure out how or why. Here is an image of the section.



How did the Hold Zone % go to 4000% and the lower hold zone go to a negative number? Did something get corrupted during the upload? Or is it the problem with the formula above divide by zero issue? Or is something screwy with the New Portfolio Control? That goes to zero and I'm not sure why.

I downloaded it a second time to check to make sure it was not on my end and got the same results.

Best,

Allen