....to keep track of grants and balances for my employees. If anyone is
interested in assisting mr let me know and I will show th spreadsheet.
I basically want three formulas:

*If less than 120 hours but over 80 hours = 3 weeks vacation
*If less than 80 hours but over 40 hours = 2 weeks vacation
*If less than 40 hours but over 1 hour = 1 week vacation

It is the second formula that is giving me the problem. Thanks.