On Feb 8, 2009, at 6:17 PM, Paul Berkowitz wrote: On 2/8/09 1:22 PM, "Deivy Marck Petrescu" <email@hidden> wrote:
So, the R3 is right (I entered RC[-1] in S3, same row one column before), I d not understand why the -- ' -- show up. They were not supposed to be there.
Actually I saw those too in 2008 using your script exactly, but since I wasn't sure what the script was supposed to be doing I didn't know what to do to avoid them. That's why I keep asking for some examples to see alternate ways of making it work properly in 2008.
--
Paul Berkowitz
Actually, it is irrelevant what would be in T2:U6 in my examples. But, so it might be easy to clarify, LOOKUP(CELL, TABLE, VECTOR) means lookup where would cell be in the table and return the value from the vector I use that to assign grades. Say that 0-50 gets an F, 50-70 a D, 70-80 a C, 8 -90 a B and 90+ an A, T2:T6 would be 0, 50, 70, 80, 90 U2 to U6 would be F,D,C,B,A Now if CELL is a value less than 50, the vector (U2:U6) returns F, less than 80 but more than 70, it returns B.
But the lookup formula should not depend on the values of the table and the vector. I am curious to find out what did you enter in 2008 to get the quotes. Did you use say R3 or RC[-1] to get the quotes? I believe there is a bug here. And one I can not really understand. Probably it has to do with excel inner workings.
|