| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for bonus or penalty
students are required to complete a designated number of homework assignment,
then receive a bonus or penalty for every additional or deficient home assignment. Andrea Carrion completed 9 homeworks, rather than 12, and thus has a 6-point penalty (2 points per each missing assignment. The bonus or penalty is added to the test average to determine the semester average. Enter the formulas for the first student in cells H4 and I4. Please help me with the formulas. 60 50 40 79 63.0 9 -6 57.0 Required # of assignments: 12 Penalty for missing 2 bonus for additional assignment: 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
