Need help with complicated IF THEN formula with several fields to consider

my understanding is that i will apply the formula You can use a combination of the doctor's name and a unique identifier, such as a timestamp, to create a unique instance identifier. Assuming the doctor's name is in Column B of the Daily Audit tab, you can use the following formula in the Compensation Reduction tab (Column A) to create a unique identifier

Formula:

Please Login or Register  to view this content.

This formula concatenates the doctor's name with the current timestamp.

2. Pulling Information from Daily Audit tab to Compensation Reduction tab
Assuming you want to pull information from the Daily Audit tab into the Compensation Reduction tab based on the unique instance identifier, you can use the VLOOKUP or INDEX-MATCH function.
For example, if the unique instance identifier is in Column A of both tabs, and you want to pull the information from Column C of the Daily Audit tab to Column B of the Compensation Reduction tab, you can use:

Formula:

Please Login or Register  to view this content.

3. Calculating Penalty Based on Price List
To calculate the penalty based on the service and the number of days late, you can use nested IF statements or the LOOKUP function. Assuming the service is in Column C and the days late is in Column D of the Compensation Reduction tab:

Formula:

Please Login or Register  to view this content.

This assumes that the service in the Compensation Reduction tab matches the service in the Price List tab, and the penalty is calculated as the product of the penalty rate and the number of days late.

Remember to adjust the cell references according to your actual spreadsheet layout and data range.

Administrative Note:

Where you have provided a workbook solution, please also include a clear explanation of what you've done and how (including formulae/code as approriate) in the post in question (for the benefit of members unable to download attachments).

This is about making your assistance accessible to all.

Thanks.

EDIT: Thanks for the explanation, but you have now removed the sample workbook! Please put the workbook back - you need both the workbook AND the explanation. Thanks.

EDIT AGAIN: Thank you.

This proposal is adds a row to the Price List sheet. The added row could be moved and/or hidden for aesthetic purposes.
The values in the added row are: 2, 3, 4, 365, 2, 4, 6 and 365
The formula for column F on the Compensation Reduction sheet could be:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.