I used Tom's sugestion and it worked great but I wanted to thank you
for your time.

On Jan 1, 12:21 pm, "Don Guillett" wrote:
try
=ROUNDUP(E1/40,0)
--
Don Guillett
SalesAid Software
wrote in oglegroups.com...



...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...tG9uqPWf-QpDA- Hide quoted text -- Show quoted text -