NYCPHP Meetup

[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:

0     F
60    D
65    D+
70    C
etc...

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
flip out.

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
worksheet:

=vlookup( D15, 'Letter Grades'!A1:B8, 2 )

Done.

-- 
cmerlo at turing.matcmp.ncc.edu        http://turing.matcmp.ncc.edu/~cmerlo

Windows:  More than enough rope.



More information about the talk mailing list