I
inoexcel
Hi there,
I am creating a scoring model to determine a letter grade based upon
raw score.
I have a list of inputs (ie assignments, tests) with different weights
and i've created a forumla that calculates out the raw score.
Is there a way that I can create a vlookup formula/table to determine
corresponding letter grade, without having to put 1%, 2%, 3%, .....100
down a column? I'd like to have something like
For example,
_A_ _B_
0-50 F
51-53 D-
54-57 D
57-60 D+
61-63 C-
I am creating a scoring model to determine a letter grade based upon
raw score.
I have a list of inputs (ie assignments, tests) with different weights
and i've created a forumla that calculates out the raw score.
Is there a way that I can create a vlookup formula/table to determine
corresponding letter grade, without having to put 1%, 2%, 3%, .....100
down a column? I'd like to have something like
For example,
_A_ _B_
0-50 F
51-53 D-
54-57 D
57-60 D+
61-63 C-