Thread: Need a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbelles jbelles is offline
external usenet poster
 
Posts: 3
Default Need a formula

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?