I hope I can describe this adequately. I have a daily audit where tons of rows of information will be inputted. I have a tab (Compensation Reduction) that will calculate a penalty EACH time a doctor does not complete his report on time. The penalty amounts vary depending on the type of test and the number of days the report is late (this is calculated in the tab, Price List). I was able to setup most of my formulas but now I am stuck on how to tell the cell to pull the exact reduction rate based on the service and # of days late. Also, there will be several instances where the doctor is going to be listed in the Compensation Reduction spreadsheet more than once. How do I capture each entry from the Daily Audit tab as a unique instance in the Compensation Reduction tab, so it does not override one of the previous instances? I'm guessing I will need a formula in the Compensation Reduction tab for column A to pull the psychologist's name from the Daily Audit tab with a rule that it will pull it each time as a unique instance. I just don't know how to do that. I've uploaded an example of the form to help with my explanation.
So I have two issues if someone with expert Excel knowledge can help me! Thank you!
Bookmarks