....to keep track of grants and balances for my employees. If anyone is
interested in assisting me let me know. The link to the spreadsheet is
below.
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.

http://spreadsheets.google.com/pub?k...XtG9uqPWf-QpDA