Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |