D
Dre
There are 100 students and their grades are calculated by (example:
factor (5.9) x score (3). The factors range from 5.9 to 6.9 and the
score from 1-5. The factor could be based on analytical writing,
Quantative, Verbal, so on. There must be a way to calculate these
scores with a lookup function instead of typing in a formula like the
example above.
Another example: Quantative factor: 6.1, student score 4 (6.1x4).
There are 10 factors total and the percentages change for each.
Ideally, I would like to type in the score and excel calculate the
factor and give me the overall percentage for that test question.
Any help will be greatly appreciated
Dre
factor (5.9) x score (3). The factors range from 5.9 to 6.9 and the
score from 1-5. The factor could be based on analytical writing,
Quantative, Verbal, so on. There must be a way to calculate these
scores with a lookup function instead of typing in a formula like the
example above.
Another example: Quantative factor: 6.1, student score 4 (6.1x4).
There are 10 factors total and the percentages change for each.
Ideally, I would like to type in the score and excel calculate the
factor and give me the overall percentage for that test question.
Any help will be greatly appreciated
Dre