[nycphp-talk] Anyone out there know how to write MS Excel 2000 VB Macros?
Christopher R. Merlo
cmerlo at turing.matcmp.ncc.edu
Wed Apr 2 13:34:28 EST 2003
On 2003-04-02 13:19 -0500, soazine at pop.erols.com
<soazine at pop.mail.rcn.net> wrote:
> All he wants is a means of translating a letter grade in a column of cells
> into a number (e.g. "A-" or "a-" -> 3.7 or "B+" or "b+" -> 3.3).
I use the VLOOKUP function. I have two columns which look like this:
Let's say that starts at cell A1, and goes through B8.
Now, if cell D15 has a number grade in it, put this in E15 to
calculate the letter grade:
=vlookup( D15, A1:B8, 2 )
That means, look up the value stored in D15 in the table mentioned
above in the cells A1 through B8, and return what you find in the
second column, which is the letter grades.
No macro needed, so now you can e-mail it to people and they won't
The last thing I do is make a separate worksheet with the letter
grades, so from each section's worksheet, I just refer to the grades
=vlookup( D15, 'Letter Grades'!A1:B8, 2 )
cmerlo at turing.matcmp.ncc.edu http://turing.matcmp.ncc.edu/~cmerlo
Windows: More than enough rope.
More information about the talk