Looking to make some simple formulas...
 

....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.

Looking to make some simple formulas...
 

=(A1<120)*(A180)*3+(A140)*(A1<80)*2+(A1<40)*(A1 1)*1
--
Gary''s Student


" wrote:

....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.

Looking to make some simple formulas...
 

Maybe another option:

=(--(A11)+(A140)+(A180))*ISNUMBER(A1)

If there is no chance for Text, the ISNUMBER can be dropped.
--
Dana DeLouis
Windows XP & Office 2003


"Gary''s Student" wrote in message
...
=(A1<120)*(A180)*3+(A140)*(A1<80)*2+(A1<40)*(A1 1)*1
--
Gary''s Student


" wrote:

....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.