Looking to make simple formulas

[bjp1965]

....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?key=p_tgV2c7MXtG9uqPWf-QpDA

 

[Tom Ogilvy]

If you are entering hours as a number (rather than a date serial):

=IF(A1<1,0,IF(A1<40,1,IF(A1<80,2,IF(A1<120,3,"-"))))


I don't know why you would want 3 separate formulas, but perhaps

=if(And(A1>=80,A1<120),"3 weeks","")

=if(And(A1>=40,A1<80),"2 weeks","")

=if(And(A1>=1,A1<40),"1 week","")

 

[Don Guillett]

try
=ROUNDUP(E1/40,0)

 

[bjp1965]

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