View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Griffindor107 Griffindor107 is offline
external usenet poster
 
Posts: 2
Default How do I set a maximum amount in a cell?

I am trying to create a sequence of equations that will calculate the amount
of paid vacations my employees have. In our policies, you can accrue paid
vacation every month, but there is a cap on how much you an you only can have
a certain amount of paid vacation. So, I would like to to have a cell add
up, but have a maximum amount that it can add to and once it hits that
maximum, it won't go any higher.
Any help would be greatly appreciated.
Thanks,