I have several worksheets with employees ID numbers and expenses. They can
be reimbursed ½ of what they have spent up to a total of $400 on each tab.
They have a maximum of $1000 to be reimbursed for across all tabs. They might
not have expenses in each category (tab).
Is there a formula that could calculate for me which employees have reached
their maximum and which employees have not?