Generate a report where there are yearly cap on reimbursement for employees

Hi All,

Need help with this.

I was asked to create this report and am not able.

Would somebody be able to help me with is last bit i am looking to perfect the report.

If you look at the tab named "Table of Reimbursement Summary", cell e34, should show zero as the worker had reached the yearly cap of 700 but it still shows a second time.

The attached excel file has Instructions in 1st tab.

Thanks for all help.

Apologies if my formula looks shabby, but please do suggest other better formulas if you think this may look much more refined.

Welcome to the forum.

Administrative Note:

Don't tell us that it is URGENT, please. To you it may be, but to us it isn’t. If it’s urgent, you should be calling on a consultant, not a volunteer who is giving their free time.

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

Thank you. I'll have a look shortly, if nobody else gets in first.