Hi,

Thank you for taking the time to review my thread.

I believe there may have been a misunderstanding regarding the intent of my question. I wasn't seeking help to complete the homework in its entirety—rather, I was asking for a single formula to address a specific difficulty I was unable to work through. While I could resort to hard coding, I was hoping for a better solution, which is why I reached out for support.

To be clear, this formula alone does not resolve the rest of the tasks required to complete the assignment.

Thanks.