Forum Discussion
Changing multiplier based on cell value
See if you can apply the example from the attached workbook. It's not very fancy and can surely be optimized with more advanced techniques and using some functions that only exist in newer Excel functions.
Thank you.
I just found out from my boss that the points system will be different and that it only applies to participation on weekends. An employee who completes a course on a Saturday gets 4 points, on a Sunday gives 6 points. The points change when an employee has attended more than 7 courses. So from the eighth course, participation on a Saturday will give 5 points and participation on a Sunday will give 7 points. There's one sheet per month, so the formula must take all sheets into account so that the summary on the total sheet is correct. Please see the attached file.
Sorry that I've given the wrong information in the first post, I unfortunately had too little information.
Hope you have a chance to have a look on this again, it's really appreciated!